Re: pgadminIII - 1.6.1 - rev:5709

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.