CREATE TABLE/AS does not allow WITH OIDS?

From: Thomas Lockhart <lockhart(at)fourpalms(dot)org>
To: pgsql-hackers(at)postgresql(dot)org
Subject: CREATE TABLE/AS does not allow WITH OIDS?
Date: 2002-11-07 16:38:51
Message-ID: 3DCA971B.7030805@fourpalms.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

... and the same for SELECT/INTO Also, the hasoids (or equivalent)
attribute is not picked up from the source table which would be another
way to push this property into the target table.

One or both of these mechanisms (I'd think both should be available)
would seem to be required to make these constructs useful in
environments requiring OIDs.

This seems to be a trivial but serious omission for this release.
Comments and suggestions?

- Thomas

From a syntax PoV, CREATE TABLE name WITH OIDS AS ... works. Haven't
worked out how to do the same for SELECT/INTO.

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Olivier PRENANT 2002-11-07 16:40:24 Re: [HACKERS] PostgreSQL supported platform report and a
Previous Message Achilleus Mantzios 2002-11-07 16:38:06 Re: [SQL] Problem: Referential Integrity Constraints lost