Re: lifetime of the old CTID

Поиск
Список
Период
Сортировка
От Ron
Тема Re: lifetime of the old CTID
Дата
Msg-id bf9dd01c-5d21-dc25-1ca7-9826e2f3e136@gmail.com
обсуждение исходный текст
Ответ на Re: lifetime of the old CTID  (Matthias Apitz <guru@unixarea.de>)
Ответы Re: lifetime of the old CTID  (Matthias Apitz <guru@unixarea.de>)
Список pgsql-general
On 7/6/22 01:18, Matthias Apitz wrote:
[snip]
> Ofc, each table has its own primary key(s), used for example for the
> SELECT ctid, * FROM d01buch WHERE ...
>
> As I said, we came to PostgreSQL from Sybase (and Oracle) and Sybase has
> for each table a so called SYB_IDENTITY_COLUMN which is static for the
> table and its value does not change.

The DBA who designed that should be flogged for pretending that 
SYB_IDENTITY_COLUMN is a primary key.

-- 
Angular momentum makes the world go 'round.



В списке pgsql-general по дате отправления:

Предыдущее
От: David Rowley
Дата:
Сообщение: Re: Multiple Indexes
Следующее
От: Matthias Apitz
Дата:
Сообщение: Re: lifetime of the old CTID