From: | Guillaume Lelarge <guillaume(at)lelarge(dot)info> |
---|---|
To: | Eric Ongerth <ericongerth(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: DROP CONSTRAINT... CASCADE seems to be broken. Bug? |
Date: | 2011-01-01 22:25:09 |
Message-ID: | 4D1FA9C5.8030101@lelarge.info |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
Le 01/01/2011 18:37, Eric Ongerth a écrit :
> Hello, this is my first post about pgAdmin III. I searched the archives
> here but the keywords DROP, CONSTRAINT, CASCADE are all so common that I was
> unable to determine whether this is a known bug. Also it does not appear on
> the known-issues list that I could see.
>
>
> - Platform I'm running on: Windows 7 32-bit
> - Language: English
> - Distribution you used (source tarball, or binary): Windows 7 32-bit
> binary
> - Version I'm using: 1.12.0
>
> The issue: there's no crash. But right-clicking any constraint and choosing
> Drop Cascaded appears to be incorrectly implemented. I get an error window
> that reports that there are dependencies and suggesting that I need to use
> DROP...CASCADE instead. The report reads exactly as if I had used Drop.
> But I used Drop Cascaded!
>
> I can open the SQL window and write my own command:
> ALTER TABLE tablename DROP CONSTRAINT constraint_name CASCADE;
>
> This of course works perfectly. So maybe there is just a simple error
> somewhere in pgAdmin III's implementation of the DROP...CASCADE action via
> the right-click context menu on constraints?
>
You're right. We didn't take care of the cascading option for
constraints. This is now fixed.
Thank you for your report.
--
Guillaume
http://www.postgresql.fr
http://dalibo.com
From | Date | Subject | |
---|---|---|---|
Next Message | Guillaume Lelarge | 2011-01-02 22:29:14 | Re: Crash in a specific situation while adding constraints |
Previous Message | Eric Ongerth | 2011-01-01 18:30:23 | Crash in a specific situation while adding constraints |