On Sat, 2002-09-28 at 16:38, Tom Lane wrote:
> Rod Taylor <rbt(at)rbt(dot)ca> writes:
> > Leaving a zero-width table would be best, even if its not so useful. I
> > don't like rejecting a CASCADE as it kinda defeats the purpose of having
> > CASCADE.
> I did something about this --- as of CVS tip, you can do
> regression=# create table foo (f1 int);
> CREATE TABLE
> regression=# alter table foo drop column f1;
> ALTER TABLE
> regression=# select * from foo;
Which of course would dump as 'create table foo ();'.
I don't think relcache would like a table without any columns, which is
why the above is rejected.
Anyway, should pg_dump ignore the table entirely? Or do we try to allow
create table () without any attributes?
In response to
pgsql-hackers by date
|Next:||From: Tom Lane||Date: 2002-09-29 02:37:23|
|Subject: Re: Default privileges for new databases (was Re: Can't import large objects in most recent cvs) |
|Previous:||From: Lamar Owen||Date: 2002-09-29 02:19:29|
|Subject: Re: 7.2.3?|
pgsql-patches by date
|Next:||From: Tom Lane||Date: 2002-09-29 02:41:50|
|Subject: Re: [PATCHES] Cascaded Column Drop |
|Previous:||From: Bruce Momjian||Date: 2002-09-29 02:04:49|
|Subject: Re: 20020822_02_pitr.patch.gz|