From: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
---|---|
To: | "Tamsin" <tg_mail(at)bryncadfan(dot)co(dot)uk> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Rules & sequences |
Date: | 2000-07-31 14:38:47 |
Message-ID: | 9361.965054327@sss.pgh.pa.us |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
"Tamsin" <tg_mail(at)bryncadfan(dot)co(dot)uk> writes:
> I'm having a problem with my insert rule -
> create rule address_ins as on insert to address DO
> insert into address_hist values (new.*,current_timestamp,'insert');
> The problem is, my address table has default nextval('address_id_seq') as
> the default for the Primary key. When I insert into the address table, the
> rule seems to take the nextval of the sequence for the audit table, and then
> the actual insert into the address table takes another nextval,
I think this may be an inherent problem in the way rules are handled
(unless Jan has an idea how to fix it). You'd probably have better luck
using a trigger.
regards, tom lane
From | Date | Subject | |
---|---|---|---|
Next Message | g | 2000-07-31 14:42:34 | Re: select question |
Previous Message | Tom Lane | 2000-07-31 14:33:08 | Re: gcc-version |