Re: Removing OIDs without recreate

On Fri, May 07, 2004 at 10:15:46AM +0200, Együd Csaba wrote:
> Hi,
> I'm winder if I can change the clause 'WITH OIDS' to 'WITHOUT OIDS' on a
> table without recreating it (eg. usong ALTER TABLE). The problem is that my
> tables are very big, and I do not need the OIDs at all. It was a mistake to
> create them with OIDs.
> Is there any way to correct it. Does it make any sense? Can it run out of
> OIDs during time?

 ALTER TABLE ...  SET WITHOUT OIDS;

 http://www.postgresql.org/docs/7.4/static/sql-altertable.html

    Karel

--
 Karel Zak  <zakkr@zf.jcu.cz>
 http://home.zf.jcu.cz/~zakkr/