Re: problem with uniques and foreing keys - Mailing list pgsql-sql

From kernel.alert kernel.alert
Subject Re: problem with uniques and foreing keys
Date
Msg-id e24c449c0605061143p3e17264dsee6c8b0718836204@mail.gmail.com
Whole thread Raw
In response to problem with uniques and foreing keys  ("kernel.alert kernel.alert" <kernel.alert@gmail.com>)
List pgsql-sql
Sorry i had a mistake in the post it was with the definition of the primary key in the empresa table...

I'm having the same error when i build the last table...


thanks for your answers...
 

Hi list...

Please i have a problem with this...

I create the follow tables...

--------------------------------------------------------

CREATE TABLE empresa (
  id_empresa         integer  NOT NULL primary key,
  nombre             varchar(45),

      primary key(id_empresa)

);
CREATE TABLE casino (
  id_casino          integer  NOT NULL,
  id_empresa         integer      REFERENCES empresa(id_empresa),

  nombre             varchar(45),

  primary key(id_casino,id_empresa)
);
CREATE TABLE maq_casino (
  id_empresa      integer  NOT NULL REFERENCES  casino(id_empresa),
  id_casino       integer  NOT NULL REFERENCES  casino(id_casino),

  ubicacion_sala     varchar(45) default NULL,
  primary key(id_empresa,id_casino,id_tipo_maquina,id_maq_casino)
);

--------------------------------------------------------

When i'm gonna to create the last table i got this error:

 

ERROR:  no hay restriccion unique que coincida con las columnas dadas en la tabla referida <<casino>>

That in english is like .. there is no a unique constraint with columns referred  in casino table.


Please where is the problem...

Greetings ...

Krackem



pgsql-sql by date:

Previous
From: Bruno Wolff III
Date:
Subject: Re: problem with uniques and foreing keys
Next
From: Stephan Szabo
Date:
Subject: Re: problem with uniques and foreing keys