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
>
> which is probably not what you might expect.
>
No, indeed it is not.
My solution - which seems to be working - is replacing:
new.my_table_id
with:
currval(pg_get_serial_sequence('my_table', 'my_table_id'))
in the on_insert rule
This does the trick.
Thanks,
Gissu
ngful subject in my original
post, sorry about that,
Kind regards,
Gissur Þórhallsson
Loftmyndir ehf.
Laugavegur 13
IS 101 Reykjavík - Iceland
sími (tel): (+354) 540 2500
tölvupóstur (email): gis...@loftmyndir.is
t the issue is.
Does anybody have any idea what is going on?
Kind regards from Iceland,
Gissur Þórhallsson
Loftmyndir ehf.
Laugavegur 13
IS 101 Reykjavík - Iceland
sími (tel): (+354) 540 2500
tölvupóstur (email): gis...@loftmyndir.is