CREATE TABLE with REFERENCE

From: kay-uwe(dot)genz <kug1977(at)web(dot)de>
To: PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: CREATE TABLE with REFERENCE
Date: 2003-07-28 16:23:49
Message-ID: DE982951-C117-11D7-905D-000A27B51AF2@web.de
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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?

Second question. Is there a method of INSERT INTO both tables VALUES
without group them in the same Transaction?

regards

Kay-Uwe

Responses

Browse pgsql-general by date

  From Date Subject
Next Message psql-mail 2003-07-28 16:28:56 Re: Hardware selection
Previous Message jose antonio leo 2003-07-28 16:16:04 update innside transactions?