Re: Creating a zero-column table

From: Robert Treat <xzilla(at)users(dot)sourceforge(dot)net>
To: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
Cc: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, pgsql-hackers(at)postgresql(dot)org
Subject: Re: Creating a zero-column table
Date: 2002-12-13 14:44:26
Message-ID: 1039790666.6352.21.camel@camel
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 2002-12-13 14:59:39 Re: Creating a zero-column table
Previous Message Tom Lane 2002-12-13 14:43:19 Re: FW: Duplicate oids!