Re: [BUGS] Bug #759: 7.3beta1 DROP COLUMN DEPENDENCY PROBLEM

2002-09-09 Thread Tim Knowles
ou try and drop the orignal table too? If this is the case I'd imagine the route to take would be to manually dump all the dependent views, drop those views, drop the column and then recreate the views. Best Regards, Tim Knowles On Fri, 2002-09-06 at 09:17, Tom Lane wrote: > Rod Taylor

[BUGS] FW: 7.3b1 : DROP DOMAIN CASCADE CAN LEAVE A TABLE WITH NO COLUMNS

2002-09-26 Thread Tim Knowles
Hello, I have found it is possible for a user with create table permission to crash the 7.3b1 backend. The crash occurs because it is possible to have a table with no columns after a DROP DOMAIN CASCADE. Create a table with one column (with that columns type specified as a domain) then issue t

[BUGS] Bug #785: 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT

2002-09-30 Thread Tim Knowles
article on WAL's at http://www.dbazine.com/gulutzan2.html Best Regards, Tim Knowles -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 27 September 2002 16:34 To: [EMAIL PROTECTED]; [EMAIL PROTECTED] Subject: Re: [BUGS] Bug #785: 7.3b2 : Possible Inconsistency with D

Re: [BUGS] Bug #785: 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT

2002-09-30 Thread Tim Knowles
? Best Regards, Tim Knowles -Original Message- From: Tom Lane [mailto:[EMAIL PROTECTED]] Sent: 30 September 2002 15:51 To: Tim Knowles Cc: [EMAIL PROTECTED] Subject: Re: [BUGS] Bug #785: 7.3b2 : Possible Inconsistency with DROP INDEX ... CASCADE and DROP CONSTRAINT "Tim Knowle