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
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 |