Re: Creating a zero-column table - Mailing list pgsql-hackers

From Robert Treat
Subject Re: Creating a zero-column table
Date
Msg-id 1039790666.6352.21.camel@camel
Whole thread Raw
In response to Re: Creating a zero-column table  (Philip Warner <pjw@rhyme.com.au>)
Responses Re: Creating a zero-column table
List pgsql-hackers
On Fri, 2002-12-13 at 03:43, Philip Warner wrote:
> At 02:56 AM 13/12/2002 -0500, Tom Lane wrote:
> >if it's not the only column in Amy's table, Beth can drop her type
> >and Amy's column along with it.
> 
> I keep forgetting PG's inheritance features. In a non-inheritance system, I 
> would vote for forcing a one column table to be dropped. For PG, I think 
> you are right.
> 

Just out of curiosity, do any of the SQL specs deal with 0 column
tables? I can't recall any dbms supporting a create table command that
didn't require at least 1 column.

Robert Treat




pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: FW: Duplicate oids!
Next
From: Tom Lane
Date:
Subject: Re: Creating a zero-column table