Re: [GENERAL] Question on trigger data visibility

2010-08-30 Thread Tom Lane
Terry Lee Tucker writes: > On Monday, August 30, 2010 07:20:14 Maurice Gittens wrote: >> So, it seems that even though my trigger is defined as AFTER INSERT >> FOR EACH STATEMENT, the inserted row >> does not appear to be included in the join. >> >> So, now to my question: Should, as a matter of

Re: [GENERAL] Question on trigger data visibility

2010-08-30 Thread Terry Lee Tucker
On Monday, August 30, 2010 07:20:14 Maurice Gittens wrote: > Hi, > > Assume tablex, tabley and tablez are correctly populated in my database. > > My purpose is to enforce referential integrity between a column in the > tablex (the child) > and a column in tablez (the parent). > > Since normal fo

[GENERAL] Question on trigger data visibility

2010-08-30 Thread Maurice Gittens
Hi, Assume tablex, tabley and tablez are correctly populated in my database. My purpose is to enforce referential integrity between a column in the tablex (the child) and a column in tablez (the parent). Since normal foreign keys do not give me this functionality, I decide to write a trigger. My