Thread: FOREIGN KEY ...

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

;-)

The message says it all...

The syntax is recognized ( u've used the right one ) but foreign keys are
not implemented in this version.

U may wish to take a look at contrib/spi/refint*
under the Postgres source tree for implementation of referential integrity

    Marin

          -= Why do we need gates in a world without fences? =-


On Thu, 18 Jun 1998, Pich LY wrote:

> 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...
>
> ;-)
>