Re: [GENERAL] How to know a record has been updated, then reset the

--On Thursday, November 18, 2004 3:15 PM +0900 Michael Glaesemann <[EMAIL PROTECTED]> wrote: Would it work to drop and readd the trigger within a transaction? Would that make it multi-user safe? I can't think of another way to bypass an update trigger. I had that idea too, and I have no idea. :-(

[GENERAL] How to know a record has been updated, then reset the flag?

Hi All... I'm been fighting this problem for a few days now, and it seems like it should be simple. But the solution has eluded me so far... I need to flag a record when it is updated or when it is a new insert. Then I SELECT for the changed records and do something not related to Postgres. E

[GENERAL] getting val of serial field after insert

Hi All... I have been inserting records into a table using the SQL insert statement via the perl5 Pg module. One of the field types is serial, and I have been trying to figure out how to get the value that was assigned in the field as a result of the insert. The serial typed field is the only