Re: Return the primary key of a newly inserted row?

From: Kenneth Downs <ken(at)secdat(dot)com>
To: John Tregea <john(at)debraneys(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Return the primary key of a newly inserted row?
Date: 2006-06-22 11:24:11
Message-ID: 449A7DDB.8070802@secdat.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

John Tregea wrote:

> Greeting again,
>
> I am writing records to postgreSQL from an IDE called revolution. At
> the time I perform the INSERT command I need to retrieve the value of
> the serial_id column from the newly created row.

We have an after-insert trigger that raises it as a notice. NOTICE
SKEY(xxx)

Attachment Content-Type Size
ken.vcf text/x-vcard 186 bytes

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Kenneth Downs 2006-06-22 11:26:14 Re: Return the primary key of a newly inserted row?
Previous Message Florian G. Pflug 2006-06-22 10:44:29 Re: Bitwise OR in a group statement