Request a Demo
Home   >   mailing lists

Re: visibility rules for AFTER UPDATE Constraint Triggers Function - Mailing list pgsql-general

From Tom Lane
Subject Re: visibility rules for AFTER UPDATE Constraint Triggers Function
Date
Msg-id 9867.1199252202@sss.pgh.pa.us
Whole thread Raw
In response to visibility rules for AFTER UPDATE Constraint Triggers Function  (Richard Broersma Jr <rabroersma@yahoo.com>)
Responses Re: visibility rules for AFTER UPDATE Constraint Triggers Function
List pgsql-general
Tree view 
Richard Broersma Jr <rabroersma@yahoo.com> writes:
> However, It seems the select doesn't yet see the non-committed records. I.E. the record that should be equal to NEW
isin fact equal to OLD. 

Please provide a self-contained example.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: visibility rules for AFTER UPDATE Constraint Triggers Function
Next
From: Tom Lane
Date:
Subject: Re: basic questions: Postgres with yum on CentOS 5.1