Postgres Pro
Downloads
Home   >   mailing lists

Re: DROP CASCADE - Mailing list pgsql-general

From Szymon Guz
Subject Re: DROP CASCADE
Date
Msg-id CAFjNrYuR=8ydrpqJbUZhLgfRNnvLV267_yfA=SdF1nKCb7SUuA@mail.gmail.com
Whole thread Raw
In response to DROP CASCADE  (Andreas <maps.on@gmx.net>)
List pgsql-general
Tree view
On 29 September 2012 18:08, Andreas <maps.on@gmx.net> wrote:
Hi
I encountered something that puzzled me a bit.
Is it expected that DROP table CASCADE drops this table and just the foreign key constraints but not the refering tables?

PG 9.2.1 on WinXP



Hi Andreas,
yes, it is expected, at least according to the documentation: http://www.postgresql.org/docs/9.1/static/ddl-depend.html 

"In this case, it doesn't remove the orders table, it only removes the foreign key constraint."

- Szymon

pgsql-general by date:

Previous
From: Andreas
Date:
Subject: DROP CASCADE
Next
From: big stone
Date:
Subject: a "dancing links" sudoku algorithm implemented in "pure" sql