Re: [SQL] multiple PK with a non UNIQUE field

[Mathieu Arnold]

+-le 26/06/2005 16:58 +0200, davide écrivait :
| CREATE TABLE appalto (
|     cod_op         int     not null references Opere,
|     cod_com     int     not null references Opere,
|     scadenza     date     not null,
|     importo        int     not null,       PRIMARY KEY (cod_op,cod_com)
| );

You have to :
CREATE TABLE appalto (
    cod_op         int     not null,
    cod_com     int     not null,
    scadenza     date     not null,
    importo        int     not null,
    PRIMARY KEY (cod_op,cod_com),
    foreign key (cod_op,cod_com) references opere (cod_op,cod_com)
);

-- 
Mathieu Arnold

---------------------------(end of broadcast)---------------------------
TIP 6: Have you searched our list archives?

               http://archives.postgresql.org