Postgres Pro
Downloads
Home   >   mailing lists

return column id from insert - Mailing list pgsql-novice

From Rory Campbell-Lange
Subject return column id from insert
Date
Msg-id 20021112115034.GB17654@campbell-lange.net
Whole thread Raw
Responses Re: return column id from insert
Re: return column id from insert
List pgsql-novice
Tree view 
I asked a question about this earlier, and didn't get a response I
understood!

The issue is this:
I need to make a database insert and then make an image with the
resulting column id number, which is provided by a sequence.

This has to be a single action, otherwise I could fall into a race
condition with another insert going on concurrently.

Any help much appreciated.

Thanks
Rory

--
Rory Campbell-Lange
<rory@campbell-lange.net>
<www.campbell-lange.net>

pgsql-novice by date:

Previous
From: "Lakshmi Narayanan V"
Date:
Subject: Invlalid EUC_JP character
Next
From: Oliver Elphick
Date:
Subject: Re: return column id from insert