Bug in foreign key constraint SQL
От | David Rowley |
---|---|
Тема | Bug in foreign key constraint SQL |
Дата | |
Msg-id | 004b01ce6a25$a194a290$e4bde7b0$@gmail.com обсуждение исходный текст |
Список | pgadmin-support |
On Testing Version 1.18.0 Alpha 1 I noticed that in the SQL pane for a self-referencing foreign key constraint the match type is listed as "unknown". I'm running pgAdmin on windows 7 64bit on postgresql 9.3 beta1 on the same OS Here's the text from the SQL pane. -- Foreign Key: core.menu_nodes_parentid_fkey -- ALTER TABLE core.menu_nodes DROP CONSTRAINT menu_nodes_parentid_fkey; ALTER TABLE core.menu_nodes ADD CONSTRAINT menu_nodes_parentid_fkey FOREIGN KEY (classid, parentid) REFERENCES core.menu_nodes(classid, nodeid) MATCH Unknown ON UPDATE CASCADE ON DELETE CASCADE; Of couse, this is not valid SQL. And here's the text from pg_dump of the same constraint. -- -- TOC entry 2773 (class 2606 OID 33756) -- Name: menu_nodes_parentid_fkey; Type: FK CONSTRAINT; Schema: core; Owner: postgres -- ALTER TABLE ONLY menu_nodes ADD CONSTRAINT menu_nodes_parentid_fkey FOREIGN KEY (classid, parentid) REFERENCES menu_nodes(classid, nodeid) ON UPDATE CASCADE ON DELETE CASCADE; I didn't test previous versions of PgAdmin Regards David Rowley.
В списке pgadmin-support по дате отправления: