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
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,
Gissur Þórhallsson
Loftmyndir ehf
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
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