Re: [HACKERS] [PATCHES] Cascaded Column Drop

2002-09-28 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: > Found in relcache.c earlier: > AssertArg(natts > 0); Okay, one other place to change ... there are probably more such ... regards, tom lane ---(end of broadcast)--- TIP 4: Don'

Re: [HACKERS] [PATCHES] Cascaded Column Drop

2002-09-28 Thread Rod Taylor
> regression=# create table foo (); > ERROR: DefineRelation: please inherit from a relation or define an attribute > > at least as far as the backend goes. Found in relcache.c earlier: AssertArg(natts > 0); Didn't look too hard to see what it protects, because it's more effort than it

Re: [HACKERS] [PATCHES] Cascaded Column Drop

2002-09-28 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> writes: >> 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 'crea

Re: [HACKERS] [PATCHES] Cascaded Column Drop

2002-09-28 Thread Rod Taylor
On Sat, 2002-09-28 at 16:38, Tom Lane wrote: > Rod Taylor <[EMAIL PROTECTED]> 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

Re: [HACKERS] [PATCHES] Cascaded Column Drop

2002-09-28 Thread Tom Lane
Rod Taylor <[EMAIL PROTECTED]> 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);