primary/foreigner keys

From: lcampos(at)ics(dot)uci(dot)edu (Luis Miguel Campos)
To: pgsql-sql(at)postgresql(dot)org
Subject: primary/foreigner keys
Date: 2001-11-22 00:11:04
Message-ID: 5fa15e5f.0111211611.c4dd97b@posting.google.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Hi,
I am trying to do the following:
CREATE TABLE Customer (
customer_id SERIAL PRIMARY KEY;
account_id INTEGER UNIQUE REFERENCES Account DEFERRABLE);

CREATE TABLE Account (
account_id SERIAL PRIMARY KEY,
customer_leader_id INTEGER UNIQUE REFERENCES Customer DEFERRABLE);

Description:
I am trying to create two tables where several customers can belong to
an account and each account has a customer leader.
This involves having each tables primary keys to be the foreigner key
in the other table. (other solutions are welcome)

Problem:
First I can not create either table because the other is not known.
I tried even within a BEGIN; table creation; commit;
Secondly If I succeed how do I INSERT values into the tables?

I am sure someone has already faced such a problem, so there must be a
solution out there but I could not find it in the postgresql
documention.

Thank you for your help,
Miguel

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Andrew G. Hammond 2001-11-22 01:09:42 Re: PL/pgSQL examples NOT involving functions
Previous Message clayton cottingham 2001-11-22 00:04:34 ldap support