Hi list...<br /><br />Please i have a problem with this...<br /><br />I create the follow tables...<br /><br
/>--------------------------------------------------------<br/><br />CREATE TABLE empresa (<br /> id_empresa
integer NOT NULL primary key, <br /> nombre varchar(45),<br />);<br />CREATE TABLE casino (<br />
id_casino integer NOT NULL,<br /> id_empresa integer REFERENCES empresa(id_empresa),<br /><br
/> nombre varchar(45), <br /><br /> primary key(id_casino,id_empresa)<br />);<br />CREATE TABLE maq_casino
(<br/> id_empresa integer NOT NULL REFERENCES casino(id_empresa),<br /> id_casino integer NOT NULL
REFERENCES casino(id_casino),<br /><br /> ubicacion_sala varchar(45) default NULL,<br /> primary
key(id_empresa,id_casino,id_tipo_maquina,id_maq_casino)<br/>);<br /><br
/>--------------------------------------------------------<br/><br />When i'm gonna to create the last table i got this
error:<br /><br />ERROR: no hay restriccion unique que coincida con las columnas dadas en la tabla referida
<<casino>><br/><br />That in english is like .. there is no a unique constraint with columns referred in
casinotable. <br /><br /><br />Please where is the problem...<br /><br />Greetings ...<br /><br />Krackem<br /><br
/><br/>