Re: value - Mailing list pgsql-general

From Gissur Þórhallsson
Subject Re: value
Date
Msg-id AANLkTimXGZ1iSKSNSo9bDjVQUOmVLxFQ8xm=MqUR8eXA@mail.gmail.com
Whole thread Raw
In response to Re: value  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-general
OK, but you still need to be careful. That trick will only work if you
insert rows one at a time into the table. If you have a single insert
that inserts multiple rows (as in my example), it would fail because
the currval() call would return the same value for each row in the
insert created by the rule.
 
My advice would be to convert to triggers.
 
After going over your example a bit better, I think I will follow your advice.
Thanks a lot for the heads up.

Kind regards from Iceland,
Gissur Þórhallsson

pgsql-general by date:

Previous
From: hans@welinux.cl
Date:
Subject: Re: Simple schema diff script in Perl
Next
From: Florian Weimer
Date:
Subject: Re: Simple schema diff script in Perl