Re: Wacky OID idea

Поиск
Список
Период
Сортировка
От Christopher Kings-Lynne
Тема Re: Wacky OID idea
Дата
Msg-id GNELIHDDFBOCMGBFGEFOKEICCDAA.chriskl@familyhealth.com.au
обсуждение исходный текст
Ответ на Re: Wacky OID idea  (Neil Conway <nconway@klamath.dyndns.org>)
Ответы Re: Wacky OID idea
Re: Wacky OID idea
Список pgsql-hackers
> I don't think it would be easy to do this without rewriting the table,
> as Alvaro suggested. And if you're going to give this DROP COLUMN
> variant totally different behavior from any other form of DROP COLUMN,
> ISTM that it doesn't belong with DROP COLUMN.

Especially if we start saving the 4 bytes that a NULL oid takes up in a
table tuple on disk.

Perhaps:

ALTER TABLE tab SET WITHOUT OIDS;

I think the reverse operation would really be impossible...?  Unless we run
through the entire table and insert an oid for each row from the oid
counter?

> That said, being able to remove the OIDs from a table would be fairly
> useful, IMHO.

Hell yeah.

By the way - I'm not saying I'll be implementing this any time soon!

Chris



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

Предыдущее
От: Neil Conway
Дата:
Сообщение: Re: Wacky OID idea
Следующее
От: Neophytos Demetriou
Дата:
Сообщение: Re: Error: missing chunk number ...