Re: [HACKERS] Last ID Problem

Поиск
Список
Период
Сортировка
От John Hansen
Тема Re: [HACKERS] Last ID Problem
Дата
Msg-id 5066E5A966339E42AA04BA10BA706AE56245@rodrick.geeknet.com.au
обсуждение исходный текст
Список 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 по дате отправления:

Предыдущее
От: John Hansen
Дата:
Сообщение: Re: [HACKERS] Last ID Problem
Следующее
От: John Hansen
Дата:
Сообщение: Re: [HACKERS] Last ID Problem