From: Pich LY <ly@esigetel.fr>
To: pgsql-sql@postgresql.org
Subject: FOREIGN KEY ...
Date: Thu, 18 Jun 1998 15:57:09 -0100
Message-ID: <358946E5.2938@esigetel.fr> (raw)
Hi there,
I'm a french student at ESIGETEL, a school engineer specialized in
Networks and Telecommunications.
Now, I've some trouble with my end year project. We are 4 students
working on an local Intranet using PostgreSQL as the database manager
(and Apache as the HTTP server).
The problem is insignifiant : how can you declare an attribute as a
foreign key ?
The tables we are focus on are :
CLIENT FACTURATION
------ -----------
(pkey) no_cli <--\ no_factu (pkey)
client \-- no_cli (foreign key)
adr_cli adr_livr
... ...
The query (in SQL language) used to declare the "FACTURATION" table is :
CREATE TABLE Facturation
(
no_factu INTEGER PRIMARY KEY,
no_cli INTEGER REFERENCES Client,
adr_livr VARCHAR(50),
...
);
We can also use :
CREATE TABLE Facturation
(
no_factu INTEGER PRIMARY KEY,
no_cli INTEGER,
adr_livr VARCHAR(50),
...
CONSTRAINT ct_factu REFERENCES (no_cli) FOREIGN KEY
Client (no_cli)
);
But it doesn't seems to work ! "psql" gives us the following message :
"NOTICE: CREATE TABLE/FOREIGN KEY clause ignored: not yet
implemented"
!!!
What's the right syntaxe ???
Thanks for the help...
;-)
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: ly@esigetel.fr
Subject: Re: FOREIGN KEY ...
In-Reply-To: <358946E5.2938@esigetel.fr>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox