On Wed, Jan 8, 2014 at 1:24 PM, David Johnston <pol...@yahoo.com> wrote:
> 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. > Yeah, default timestamp was the best solution I could come up with, but I was hoping there was a way to access the actual PK of the most recent insert. Looks like timestamp it is. Thanks everyone! > 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. > > > -- > Sent via pgsql-general mailing list (pgsql-general@postgresql.org) > To make changes to your subscription: > http://www.postgresql.org/mailpref/pgsql-general >
