Re: deprecating the use of OIDs

Поиск
Список
Период
Сортировка
От Neil Conway
Тема Re: deprecating the use of OIDs
Дата
Msg-id 1064875302.22627.2.camel@tokyo
обсуждение исходный текст
Ответ на Re: deprecating the use of OIDs  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: deprecating the use of OIDs  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
On Mon, 2003-09-29 at 18:37, Tom Lane wrote:
> It doesn't seem to me that this really buys much.  What we really want
> is a way for a dump/reload to remove OIDs from tables that formerly had
> them; otherwise people will not easily be able to migrate their existing
> tables away from having OIDs.

Can't they just use ALTER TABLE ... WITHOUT OIDS?

> > ... and a single SET can apply to
> > multiple CREATE TABLEs.
> 
> Not unless you want partial pg_restores to break.

So is it worth doing this rather than WITH/WITHOUT OIDS, then?

-Neil




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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: deprecating the use of OIDs
Следующее
От: Stephan Szabo
Дата:
Сообщение: Re: ADD FOREIGN KEY (was Re: [GENERAL] 7.4Beta)