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/