[HACKERS] 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: [HACKERS] Re: [SQL] getting the oid for a new tuple in a BEFORE trigger

2001-08-29 Thread Horst Herb
On Wednesday 29 August 2001 20:05, you wrote: > 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 As you don't know how many users access the server concurrently and in which order they

[HACKERS] 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