From: | Dmitry Tkach <dmitry(at)openratings(dot)com> |
---|---|
To: | "kay-uwe(dot)genz" <kug1977(at)web(dot)de> |
Cc: | PostgreSQL General <pgsql-general(at)postgresql(dot)org> |
Subject: | Re: CREATE TABLE with REFERENCE |
Date: | 2003-07-28 18:24:20 |
Message-ID: | 3F256A54.4000402@openratings.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
kay-uwe.genz wrote:
>Hi @ all,
>
>i've a little problem with two tables and FOREIGN KEYs. I've read about
>this long time ago, but didn't remember me where. Well, I hope you can
>help me.
>
>I've create two TABLEs "counties" and "cities". "Countries" have a row
>"capital" is REFERENCEd "cities". "cities" have a row country
>REFERENCEd "countries", where a save the country the city is placed.
>
>And now PG couldn't create the TABLEs, because the referenced table
>doesn't exists in time of creation. Is there another method of creating
>than the ALTER TABLE the first table after the second is living?
>
No. But what's wrong with ALTER TABLE?
>
>Second question. Is there a method of INSERT INTO both tables VALUES
>without group them in the same Transaction?
>
>
No (assuming, that you are talking about inserting a new country and a
capital at the same time, and that the country's capital column cannot
be null).
But what's wrong with transactions?
Dima
From | Date | Subject | |
---|---|---|---|
Next Message | scott.marlowe | 2003-07-28 18:24:28 | Re: Using YY-MM-DD date input |
Previous Message | Rajesh Kumar Mallah | 2003-07-28 18:23:20 | Re: CREATE TABLE with REFERENCE |