Re: BUG #1524: drop view cascade deletes other user's views

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: "Dennis van Dok" <d(dot)vandok(at)ecn(dot)nl>
Cc: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #1524: drop view cascade deletes other user's views
Date: 2005-03-05 04:43:59
Message-ID: 14047.1109997839@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

"Dennis van Dok" <d(dot)vandok(at)ecn(dot)nl> writes:
> Using DROP VIEW or DROP TABLE with CASCADE will drop all dependent views,
> even those that aren't owned by the caller.

This is per SQL spec.

regards, tom lane

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2005-03-05 04:46:28 Re: BUG #1527: select retrieves 0 rows after vacuum analyze
Previous Message Stephan Szabo 2005-03-04 22:18:09 Re: BUG #1522: there's a syntax error using psql, distinct