Nup - DROP COLUMN (well at least the code I wrote) deliberately prevents you
from doing that!
Chris
> -----Original Message-----
> From: Rod Taylor [mailto:rbt@rbt.ca]
> Sent: Sunday, 3 November 2002 10:49 PM
> To: Christopher Kings-Lynne
> Cc: Tom Lane; pgsql-committers@postgresql.org
> Subject: Re: [COMMITTERS] pgsql-server/src/bin/psql print.c
>
>
> On Sun, 2002-11-03 at 06:37, Christopher Kings-Lynne wrote:
> > Out of interest, how does one get a table of no columns?
>
> ALTER TABLE DROP COLUMN :)
>
> > On Fri, 1 Nov 2002, Tom Lane wrote:
> >
> > > CVSROOT: /cvsroot
> > > Module name: pgsql-server
> > > Changes by: tgl@postgresql.org 02/11/01 10:12:19
> > >
> > > Modified files:
> > > src/bin/psql : print.c
> > >
> > > Log message:
> > > Avoid malloc(0) when printing a table of no columns. On
> some platforms
> > > this returns NULL, which confuses the code.
> > >
> > >
> > > ---------------------------(end of
> broadcast)---------------------------
> > > TIP 5: Have you checked our extensive FAQ?
> > >
> > > http://www.postgresql.org/users-lounge/docs/faq.html
> > >
> >
> >
> > ---------------------------(end of broadcast)---------------------------
> > TIP 4: Don't 'kill -9' the postmaster
> >
> --
> Rod Taylor
>