Re: [HACKERS] Last ID Problem - Mailing list pgsql-novice

From John Hansen
Subject Re: [HACKERS] Last ID Problem
Date
Msg-id 5066E5A966339E42AA04BA10BA706AE56245@rodrick.geeknet.com.au
Whole thread Raw
List pgsql-novice
> > Since OID's are now deprecated, and will eventually disappear,
> > wouldn't it be a good idea, to have INSERT and UPDATE
> return a copy of
> > the tuple that was inserted/updated?
>
> How about the TID?

Yea, that'd work. As long as you can get an arbitrary column back out, 'as it was at the time it was committed'.

Since not everything runs in a transaction,. And someone might have modified the row by the time you get to fetching it
backout.... 

Or in terms of tuples,. No longer exist, if vacuum full have run...

... JOhn

pgsql-novice by date:

Previous
From: John Hansen
Date:
Subject: Re: [HACKERS] Last ID Problem
Next
From: John Hansen
Date:
Subject: Re: [HACKERS] Last ID Problem