Chris Travers wrote:
Hi;
I noticed that rules were not behaving properly. I created a test
case, and it looks like the sequence is getting double-incrimented.
Is this the way this is supposed to work?
I know triggers would be better for something like this but I find
these results... surprising....
postgres=# insert into test1 (test) values (1);
This insert is implicitly specifying that you should use the default
value as the value for the ID column. The default is
nextval('test1_id_seq'), so this is what gets inserted into test2 as
well, thus incrementing the sequence twice.
--
Tommy Gildseth
--
Tommy Gildseth
DBA, Gruppe for databasedrift
Universitetet i Oslo, USIT
m: +47 45 86 38 50
