Re: [GENERAL] question on trigger

2012-02-11 Thread Terry Lee Tucker
On Saturday, February 11, 2012 09:22:44 AM mgo...@isstrucksoftware.net wrote: > I will have several triggers which will make sure that the data in some > columns in in uppercase format. For insert it is a no brainer, however for > updates, it is better to check and see if the new values is the sa

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