Re: Last inserted row id with complex PK

Поиск
Список
Период
Сортировка
От David Johnston
Тема Re: Last inserted row id with complex PK
Дата
Msg-id 1389209042695-5785901.post@n5.nabble.com
обсуждение исходный текст
Ответ на Re: Last inserted row id with complex PK  (Nelson Green <nelsongreen84@gmail.com>)
Ответы Re: Last inserted row id with complex PK  (Nelson Green <nelsongreen84@gmail.com>)
Список 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 по дате отправления:

Предыдущее
От: Jeff Janes
Дата:
Сообщение: Re: Consistent file-level backup of pg data directory
Следующее
От: Nelson Green
Дата:
Сообщение: Re: Last inserted row id with complex PK