Re: [GENERAL] value

2010-09-16 Thread Gissur Þórhallsson
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

Re: [GENERAL] value

2010-09-16 Thread 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

Re: [GENERAL] value

2010-09-16 Thread Gissur Þórhallsson
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

[GENERAL] value

2010-09-15 Thread Gissur Þórhallsson
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