Re: [GENERAL] "OLD used in query that is not in a rule"

2012-03-26 Thread Gauthier, Dave
OK, and understood. And yes, I thought it was a global. Thanks Tom. -Original Message- From: Tom Lane [mailto:t...@sss.pgh.pa.us] Sent: Monday, March 26, 2012 10:52 AM To: Gauthier, Dave Cc: pgsql-general@postgresql.org Subject: Re: [GENERAL] "OLD used in query that is not in a

Re: [GENERAL] "OLD used in query that is not in a rule"

2012-03-26 Thread Tom Lane
"Gauthier, Dave" writes: > I get... "OLD used in query that is not in a rule" when trying to ref, for > example, OLD.tblcol1, from inside a stored procedure. Is this saying you > cannot use OLD.* (or NEW.* I suppose) unless it's from within a trigger > function (returns type "trigger")? Certa

[GENERAL] "OLD used in query that is not in a rule"

2012-03-26 Thread Gauthier, Dave
I get... "OLD used in query that is not in a rule" when trying to ref, for example, OLD.tblcol1, from inside a stored procedure. Is this saying you cannot use OLD.* (or NEW.* I suppose) unless it's from within a trigger function (returns type "trigger")? If so, is there some way to tap this in