"Joshua D. Drake" <jd@xxxxxxxxxxxxxxxxx> writes: > On Wed, 2009-02-11 at 09:41 -0800, Steve Crawford wrote: >> My plan is to do the OID removal on 7.4. I can get a script with: >> SELECT >> 'ALTER TABLE ' || relname || ' SET WITHOUT OIDS;' > That won't drop the OID columns. Sure it will. I'd be a little worried about whether he shouldn't be using quote_identifier and/or schema-qualifying the names, but SET WITHOUT OIDS is the right command to be issuing. regards, tom lane -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
