This is a discussion on Re: [NOVICE] Last ID Problem within the pgsql Hackers forums, part of the PostgreSQL category; --> > > Since OID's are now deprecated, and will eventually disappear, > > wouldn't it be a good idea, ...
| |||||||
| FAQ | Members List | Calendar | Search | Today's Posts | Mark Forums Read |
| ||||
| > > 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 back out.... Or in terms of tuples,. No longer exist, if vacuum full have run... .... JOhn ---------------------------(end of broadcast)--------------------------- TIP 7: don't forget to increase your free space map settings |
| ||||
| > No one has stated that they will disappear. Ohh,... just the impression I've been getting when speaking with people. .... John ---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org |