Re: OIDs

From: Frank Bax <fbax(at)sympatico(dot)ca>
To: "PostgreSQL Novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: OIDs
Date: 2005-05-02 21:20:07
Message-ID: 5.2.1.1.0.20050502171648.03fb8d60@pop6.sympatico.ca
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

At 05:09 PM 5/2/05, Keith Worthington wrote:
>Is it possible to change a table from 'WITH OIDS' to 'WITHOUT OIDS' and vice
>versa or must I DROP TABLE and CREATE TABLE using the desired attributes?

http://www.postgresql.org/docs/8.0/interactive/sql-altertable.html

The "SET WITHOUT OIDS" paragraph answers both questions.

In response to

  • OIDs at 2005-05-02 21:09:48 from Keith Worthington

Browse pgsql-novice by date

  From Date Subject
Next Message Ennio-Sr 2005-05-02 22:25:15 psql not warning while creating a wrong function?
Previous Message Terry Lee Tucker 2005-05-02 21:19:24 Re: OIDs