Table Constraints Bug

From: Matthew Arp <x00010000(at)att(dot)net>
To: pgadmin-support(at)postgresql(dot)org
Subject: Table Constraints Bug
Date: 2008-08-31 01:12:42
Message-ID: 490618.24822.qm@web83718.mail.sp1.yahoo.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgadmin-support

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),
  CONSTRAINT role_parent_fkey FOREIGN KEY (parent)
      REFERENCES "role" (uid) MATCH SIMPLE
      ON UPDATE NO ACTION ON DELETE RESTRICT
)
WITH (OIDS=FALSE);
ALTER TABLE "role" OWNER TO glasshook_admin;

Responses

Browse pgadmin-support by date

  From Date Subject
Next Message Guillaume Lelarge 2008-09-01 16:34:37 Re: Table Constraints Bug
Previous Message Julius Tuskenis 2008-08-29 14:23:27 Re: Detected error in pgAdmin III v1.8.4