Postgres Pro
Downloads
Home   >   mailing lists

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

From Nelson Green
Subject Last inserted row id with complex PK
Date
Msg-id CAGo-KZkErWMrRutaBP8TGQUfCCYi_bnqfvwoomqZqUGCD9z4bA@mail.gmail.com
Whole thread Raw
Responses Re: Last inserted row id with complex PK
Re: Last inserted row id with complex PK
Re: Last inserted row id with complex PK
List pgsql-general
Tree view
I have a projects log table with a three column PK, project_num, person_num, and sequence, where each new entry for a project/person combination increments the sequence, which is not an auto incrementing sequence. Is there any way to retrieve the last entry to the table? For instance, if the last entry for person 427 on project 15 was sequence number 125, is that information available to me anywhere?

Thanks,
Nelson

pgsql-general by date:

Previous
From: gator_ml@yahoo.de
Date:
Subject: Re: Consistent file-level backup of pg data directory
Next
From: Francisco Olarte
Date:
Subject: Re: Last inserted row id with complex PK