Erbil KARAMAN wrote:
i'm using pgAdmin III - 1.6.1 - rev:5709 win32 binary version

when i try to view table details, sometimes foreign keys comes with
missing column names which causes a syntax error when i try to
recreate or copy table.

ex:
pgAdmin III:
---------------------
CONSTRAINT xxx_yyy_fkey FOREIGN KEY ()
     REFERENCES yyy () MATCH SIMPLE
     ON UPDATE NO ACTION ON DELETE NO ACTION

original pgdump of table:
-----------------------------------
ALTER TABLE ONLY xxx
   ADD CONSTRAINT xxx_yyy_fkey FOREIGN KEY (yyy) REFERENCES yyy(id);

I cannot reproduce that here. Can you provide a self contained test case to reproduce it please? I assume 2 tables and a foreign key are all thats required (or three? ONLY implies your using inheritance).

Regards, Dave.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to