Ross, you make some powerful arguments here. Probably the most
significant was the idea that you need a unique identifier for every
row, and it should be of a consistent type, which primary key is not.
We clearly need a GUC parameter to turn on/off oids. But it seems we
will always need the
Curt Sampson [EMAIL PROTECTED] writes:
I object. I personally think we should be moving towards not using OIDs
as the default behaviour, inasmuch as we can, for several reasons:
All these objections are global in nature, not specific to CREATE TABLE
AS. The argument that persuaded me to do
On Thu, Jan 23, 2003 at 10:03:28AM -0500, Tom Lane wrote:
Curt Sampson [EMAIL PROTECTED] writes:
I object. I personally think we should be moving towards not using OIDs
as the default behaviour, inasmuch as we can, for several reasons:
All these objections are global in nature, not
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Why don't you just include them by default, otherwise if WITHOUT OIDS
appears in the CREATE TABLE command, then don't include them ?
Well, adding a WITHOUT OIDS option to CREATE TABLE AS would be a new
feature, which I don't have the
Christopher Kings-Lynne [EMAIL PROTECTED] writes:
Why don't you just include them by default, otherwise if WITHOUT OIDS
appears in the CREATE TABLE command, then don't include them ?
Well, adding a WITHOUT OIDS option to CREATE TABLE AS would be a new
feature, which I don't have the
We've gotten a couple of complaints now about the fact that 7.3 doesn't
include an OID column in a table created via CREATE TABLE AS or SELECT
INTO. Unless I hear objections, I'm going to revert it to including an
OID, and back-patch the fix for 7.3.2 as well. See discussion a couple
days ago on
Why don't you just include them by default, otherwise if WITHOUT OIDS
appears in the CREATE TABLE command, then don't include them ?
Chris
-Original Message-
From: [EMAIL PROTECTED]
[mailto:[EMAIL PROTECTED]]On Behalf Of Tom Lane
Sent: Wednesday, 22 January 2003 4:12 AM
To: [EMAIL