Why is pg_lsn marking itself a preferred type?

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Why is pg_lsn marking itself a preferred type?
Дата
Msg-id 16255.1401218833@sss.pgh.pa.us
обсуждение исходный текст
Ответы Re: Why is pg_lsn marking itself a preferred type?
Список pgsql-hackers
One of these doesn't belong:

postgres=# select typname, typcategory from pg_type where typispreferred;  typname   | typcategory 
-------------+-------------bool        | Btext        | Soid         | Nfloat8      | Ninet        | Itimestamptz |
Dinterval   | Tvarbit      | Vpg_lsn      | U
 
(9 rows)

Was there any actual rationale to this, or was it just somebody who did
not understand what that bit is for?

I think it's probably mostly harmless given the lack of casts to or from
pg_lsn, but it's still a darn bad idea to have any preferred types in the
'U' category.  If we leave it like this it will bite us in the rear
eventually.

The most expedient response at this late date seems to be to change the
entry in pg_type.h without bumping catversion.  That way at least it
will be right in databases initdb'd after beta2.
        regards, tom lane



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

Предыдущее
От: Heikki Linnakangas
Дата:
Сообщение: Re: Race condition within _bt_findinsertloc()? (new page split code)
Следующее
От: Heikki Linnakangas
Дата:
Сообщение: Re: PG Manual: Clarifying the repeatable read isolation example