Re: Last inserted row id with complex PK - Mailing list pgsql-general

From David Johnston
Subject Re: Last inserted row id with complex PK
Date
Msg-id 1389209042695-5785901.post@n5.nabble.com
Whole thread Raw
In response to Re: Last inserted row id with complex PK  (Nelson Green <nelsongreen84@gmail.com>)
Responses Re: Last inserted row id with complex PK  (Nelson Green <nelsongreen84@gmail.com>)
List pgsql-general
Nelson Green wrote
> My apologies, I was not completely clear. I will not know any of the
> columns in advance. The most recent insert is the result of user input
> from
> a web form, so I won't know what project or what user generated the last
> insert. That was why I wandered if that information was stored anywhere in
> the system.

I'd probably add either (or both) a table-level auto-sequence field and a
"recordcreationdate" default timestamptz field.

David J.





--
View this message in context:
http://postgresql.1045698.n5.nabble.com/Last-inserted-row-id-with-complex-PK-tp5785863p5785901.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.


pgsql-general by date:

Previous
From: Jeff Janes
Date:
Subject: Re: Consistent file-level backup of pg data directory
Next
From: Nelson Green
Date:
Subject: Re: Last inserted row id with complex PK