On Sat, May 13, 2006 at 02:11:14PM -0700, Karen Hill wrote:
> I'm having a bit of mystery in solving a postgresql puzzle. I have a
> table that when it gets inserted or updated or deleted it is logged
> into a log table. The log table contains who (current_user) did the
> insert/update/delete the CURRENT_TIMESTAMP. Everything works great
> except the INSERT because I cannot use OLD and NEW increments the
> serial twice!
You cannot use OLD because there is no old row. And rules are like
macros, so the nextval() gets evaluated twice.
You probably want a trigger...
--
Martijn van Oosterhout <kleptog@svana.org> http://svana.org/kleptog/
> From each according to his ability. To each according to his ability to litigate.