Re: [pgadmin-support] Table Constraints Bug

2008-09-01 Thread Guillaume Lelarge
Matthew Arp a écrit : > pgAdminIII will not allow you to add a self-referential constraint while > using the GUI table editor, see the below example: > > CREATE TABLE "role" > ( > uid integer NOT NULL, > "name" character varying(32) NOT NULL, > parent integer NOT NULL DEFAULT 1, > CONSTRA

[pgadmin-support] Table Constraints Bug

2008-08-31 Thread Matthew Arp
pgAdminIII will not allow you to add a self-referential constraint while using the GUI table editor, see the below example:   CREATE TABLE "role" (   uid integer NOT NULL,   "name" character varying(32) NOT NULL,   parent integer NOT NULL DEFAULT 1,   CONSTRAINT role_pkey PRIMARY KEY (uid),   CONS