Re: [ADMIN] unique constraints on foreign keys

2004-09-20 Thread Stephan Szabo
On Mon, 20 Sep 2004, Jaime Casanova wrote: > --- Stephan Szabo <[EMAIL PROTECTED]> > escribió: > > > > On Mon, 20 Sep 2004, Jaime Casanova wrote: > > > > > There is a way to not enforce the creation of a > > > primary or unique index on a referenced table? > > > > Not really. It's not the index t

Re: [ADMIN] unique constraints on foreign keys

2004-09-20 Thread Jaime Casanova
--- Stephan Szabo <[EMAIL PROTECTED]> escribió: > > On Mon, 20 Sep 2004, Jaime Casanova wrote: > > > There is a way to not enforce the creation of a > > primary or unique index on a referenced table? > > Not really. It's not the index that's important > per-se, it's the uniqueness that is impl

Re: [ADMIN] unique constraints on foreign keys

2004-09-20 Thread Stephan Szabo
On Mon, 20 Sep 2004, Jaime Casanova wrote: > I have a reference table that holds all the status > used in a system (it's a very little table just 10 or > 15 rows). > > create table status ( > cod_status char(2) not null primary key, > nam_status textnot null > ); > > create

[ADMIN] unique constraints on foreign keys

2004-09-20 Thread Jaime Casanova
Hi all, I have a reference table that holds all the status used in a system (it's a very little table just 10 or 15 rows). create table status ( cod_status char(2) not null primary key, nam_status textnot null ); create table some_other_table ( ... definition of the tabl