Обсуждение: Removing OIDs

Поиск
Список
Период
Сортировка

Removing OIDs

От
Sam Barnett-Cormack
Дата:
Is there any way to remove OIDs from an existing table, or even a whole
database? I never use the damn things and my database is big, so I'd
like to do anything I can to shrink it.

Also, are there any performance implications to this?

I'm currently using 7.3.4, but will shortly be moving to 7.4

--

Sam Barnett-Cormack
Software Developer                           |  Student of Physics & Maths
UK Mirror Service (http://www.mirror.ac.uk)  |  Lancaster University

Re: Removing OIDs

От
Marek Lewczuk
Дата:
Sam Barnett-Cormack wrote:

> Is there any way to remove OIDs from an existing table, or even a whole
> database? I never use the damn things and my database is big, so I'd
> like to do anything I can to shrink it.
>
> Also, are there any performance implications to this?
>
> I'm currently using 7.3.4, but will shortly be moving to 7.4
>

ALTER TABLE [ ONLY ] name [ * ] SET WITHOUT OIDS

ML.