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/ ---------------------------(end of broadcast)--------------------------- TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
