Re: [SQL] getting the oid for a new tuple in a BEFORE trigger

2001-08-30 Thread Peter Eisentraut
Markus Wagner writes: > we need to control database changes within BEFORE triggers. > There is no problem with triggers called by update, but there is > a problem with triggers called by insert. > > We strongly need to know the oid of a newly inserted tuple. In this case, we > use tg_newtuple of

Re: [SQL] getting the oid for a new tuple in a BEFORE trigger

2001-08-30 Thread Francesco Casadei
On Wed, Aug 29, 2001 at 11:15:08AM +0200, Markus Wagner wrote: > Hi, > > we need to control database changes within BEFORE triggers. > There is no problem with triggers called by update, but there is > a problem with triggers called by insert. > > We strongly need to know the oid of a newly inse

Re: [SQL] getting the oid for a new tuple in a BEFORE trigger

2001-08-29 Thread Josh Berkus
Mark, The responses to your problem are gonna be kinda slow, as 2/3 of the core team, and many of the users, are at the Expo right now (and if anyone on the list is in the SF Bay Area, join us! BOF session tonight!) > we need to control database changes within BEFORE triggers. > There is no pro

Re: [SQL] getting the oid for a new tuple in a BEFORE trigger

2001-08-29 Thread omid omoomi
hi, Idon't know the best way but how about a quick insert in a temp table and adding 1 to the inserted oid column each time the trigger will run.! regards Omid >From: Markus Wagner <[EMAIL PROTECTED]> >To: [EMAIL PROTECTED], [EMAIL PROTECTED], >[EMAIL PROTECTED] >Subject: [SQL] getting the oid