From: | Dave Page <dpage(at)postgresql(dot)org> |
---|---|
To: | Erbil KARAMAN <erbilkaraman(at)gmail(dot)com> |
Cc: | pgadmin-support(at)postgresql(dot)org |
Subject: | Re: pgadminIII - 1.6.1 - rev:5709 |
Date: | 2006-12-05 11:35:35 |
Message-ID: | 45755987.6000903@postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
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.
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2006-12-05 12:12:14 | Re: pgadminIII - 1.6.1 - rev:5709 |
Previous Message | Dave Page | 2006-12-05 11:05:31 | Re: Exporting results from query window to a file |