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.
--
Sent via pgadmin-support mailing list ([email protected])
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgadmin-support
