From: | Dave Page <dpage(at)pgadmin(dot)org> |
---|---|
To: | Thom Brown <thombrown(at)gmail(dot)com> |
Cc: | pgadmin-support <pgadmin-support(at)postgresql(dot)org> |
Subject: | Re: Foreign key to column on same table at table creation time |
Date: | 2009-10-06 02:42:19 |
Message-ID: | 937d27e10910051942k5df69bbeqf3da2be1e64a9aa3@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgadmin-support |
2009/10/4 Thom Brown <thombrown(at)gmail(dot)com>:
> I've noticed (at least in pgAdmin III v1.8.4) that I can't create a foreign key constraint pointing to the table I'm in the process of creating. I can do it manually though. Here's an example:
> CREATE TABLE testtable
> (
> id serial NOT NULL,
> parent_id integer,
> CONSTRAINT pk_testtable_id PRIMARY KEY (id),
> CONSTRAINT fk_testtable_parent_id FOREIGN KEY (parent_id)
> REFERENCES testtable (id) MATCH SIMPLE
> ON UPDATE NO ACTION ON DELETE NO ACTION
> )
> I could achieve this if I create the table then apply the foreign key, but it would be nice to be able to do this one step. Is it possible to add this for a future release?
The code to implement it in the current dialogues would be quite messy
I expect. There is a TODO item which has had a little work put into it
already to replace the main table dialogue and the sub dialogues with
one 'uber' window - that project should make it easier to implement
something like this in the future.
--
Dave Page
EnterpriseDB UK: http://www.enterprisedb.com
From | Date | Subject | |
---|---|---|---|
Next Message | Dave Page | 2009-10-06 02:42:25 | Re: Per-function configuration parameters loss |
Previous Message | Willy-Bas Loos | 2009-10-05 16:12:55 | downloading booleans to CSV slow |