On Tue, Mar 25, 2003 at 13:01:17 -0700, Roy Souther <roy@SiliconTao.com> wrote:
> First of all I am a programmer not an DBA expert.
>
> For a long time now when I create a table I have an index field that is
> of type int4 to be the primary key. All of the queries and activity on
> each record uses this field to do the posting, manipulating and reading
> of data to and from tables.
[snip]
> Is there a better way to do this? How do DBAs with a lot of connections
> safely create new records?
The short answer is to use sequences. Use currval to get the value assigned
earlier in the same transaction.