Re: Altering existing table to be WITHOUT OIDs - Mailing list pgsql-general

From Tom Lane
Subject Re: Altering existing table to be WITHOUT OIDs
Date
Msg-id 20850.1022270773@sss.pgh.pa.us
Whole thread Raw
In response to Altering existing table to be WITHOUT OIDs  (Doug Fields <dfields-pg-general@pexicom.com>)
Responses Removing Referential Integrity
Re: Altering existing table to be WITHOUT OIDs
List pgsql-general
Doug Fields <dfields-pg-general@pexicom.com> writes:
> The documentation does not give any information about how I might do this
> in the ALTER TABLE, so it may not be possible, at least, not that way.

ALTER TABLE doesn't support it, but you could reach in and tweak
pg_class.relhasoids for your tables.  I think you would also need to
delete the pg_attribute row for oid for each such table if you wanted
to have a perfectly clean result.

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: Case Insensitive Data Type
Next
From: Tom Lane
Date:
Subject: Re: Page viewer software?