Re: Altering existing table to be WITHOUT OIDs

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Doug Fields <dfields-pg-general(at)pexicom(dot)com>
Cc: pgsql-general(at)postgresql(dot)org
Subject: Re: Altering existing table to be WITHOUT OIDs
Date: 2002-05-24 20:06:13
Message-ID: 20850.1022270773@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Doug Fields <dfields-pg-general(at)pexicom(dot)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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2002-05-24 20:07:57 Re: Page viewer software?
Previous Message Tom Lane 2002-05-24 20:02:42 Re: Case Insensitive Data Type