Postgres Pro
Downloads
Home   >   mailing lists

Re: value - Mailing list pgsql-general

From Gissur Þórhallsson
Subject Re: value
Date
Msg-id AANLkTi=_ZrtTnzPpdet5eDr7Jeq=d=zxxHjyOPbeXRkB@mail.gmail.com
Whole thread Raw
In response to Re: value  (Dean Rasheed <dean.a.rasheed@gmail.com>)
Responses Re: value  (Dean Rasheed <dean.a.rasheed@gmail.com>)
List pgsql-general
Tree view
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.
Laugavegur 13
IS 101 Reykjavík - Iceland
sími (tel): (+354) 540 2500
tölvupóstur (email): gissur@loftmyndir.is

pgsql-general by date:

Previous
From: Peter Hopfgartner
Date:
Subject: Re: Getting FATAL: terminating connection due to administrator command
Next
From: Uwe Schroeder
Date:
Subject: Re: Transposing rows and columns