On 12/21/11 10:24 AM, Xiaoning Xu wrote:
Since the serial primary key of my partition table is the FK of some other tables, I need to get the id after each insertion. My solution now is to select the max id from the parent table. I am wondering if there is any other alternatives to solve this problem.
curval('sequencename') after doing the insert will return the correct value for this transaction, independent of any other concurrent trnasactions that may be going on. your max() method would fail with enough concurrency.
-- john r pierce N 37, W 122 santa cruz ca mid-left coast -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
