DROP CONSTRAINT... CASCADE seems to be broken. Bug?
От | Eric Ongerth |
---|---|
Тема | DROP CONSTRAINT... CASCADE seems to be broken. Bug? |
Дата | |
Msg-id | AANLkTinObh6XNoScxQhAR9c3ZZzHzE1oGvyyOb+pAnVg@mail.gmail.com обсуждение исходный текст |
Ответы |
Re: DROP CONSTRAINT... CASCADE seems to be broken.
Bug?
|
Список | pgadmin-support |
Hello, this is my first post about pgAdmin III. I searched the archives here but the keywords DROP, CONSTRAINT, CASCADEare all so common that I was unable to determine whether this is a known bug. Also it does not appear on the known-issueslist that I could see.<br /><br /><ul><li>Platform I'm running on: Windows 7 32-bit <li>Language: English<br/><li>Distribution you used (source tarball, or binary): Windows 7 32-bit binary<br /><li>Version I'm using: 1.12.0</ul>Theissue: there's no crash. But right-clicking any constraint and choosing Drop Cascaded appears to be incorrectlyimplemented. I get an error window that reports that there are dependencies and suggesting that I need to useDROP...CASCADE instead. The report reads exactly as if I had used Drop. But I used Drop Cascaded!<br /><br />I can openthe SQL window and write my own command:<br />ALTER TABLE tablename DROP CONSTRAINT constraint_name CASCADE;<br /><br/>This of course works perfectly. So maybe there is just a simple error somewhere in pgAdmin III's implementation ofthe DROP...CASCADE action via the right-click context menu on constraints?<br /><br />Thanks,<br />Eric<br />
В списке pgadmin-support по дате отправления: