nooby q: how get a row just inserted?

From: Kenneth Tilton <kentilton(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: nooby q: how get a row just inserted?
Date: 2009-05-30 22:02:26
Message-ID: 4A21ACF2.5020505@gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

I am probably breaking the rules here which is why I have a problem, but
here goes: I am trying to build an audit trail skeleton of all my table
inserts. Everything table has a column for the serial ID of an audit
trail table row I will create for each transaction or batch of
transactions if I like. My problem is that the audit trail table as I
conceive it does not have a natural primary key. I do have serial id and
timestamp columns supplied by PG, but being supplied by PG I need to
read back the row to get at their values.

If I were using OIDs on the table I realize the insert returns the oid
created, but (so far) I am not.

Am I going to have to use oids or fake a distinguishing column I can use
to read back an audit trail row just after inserting it?

I was hoping there was some select magic that would let me insert a row
within a select which extracted the PG-allocated serial id column, but I
do not see anything like that.

kt

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rodrigo Gonzalez 2009-05-30 22:23:19 Re: nooby q: how get a row just inserted?
Previous Message Tom Lane 2009-05-30 15:49:02 Re: How can I look at a recursive table dependency tree?