Re: [GENERAL] "REFERENCES" and UNIQUE

2006-01-18 Thread Stephan Szabo
On Tue, 17 Jan 2006, Michelle Konzack wrote: > Am 2006-01-04 12:08:30, schrieb Stephan Szabo: > > > > On Wed, 4 Jan 2006, Michelle Konzack wrote: > > > > | CREATE TABLE countries ( > > > | serno int NOT NULL UNIQUE, > > > | isocode varchar(2) NOT NULL UNIQUE, > >

Re: [GENERAL] "REFERENCES" and UNIQUE

2006-01-17 Thread Michelle Konzack
Am 2006-01-04 12:08:30, schrieb Stephan Szabo: > > On Wed, 4 Jan 2006, Michelle Konzack wrote: > > | CREATE TABLE countries ( > > | serno int NOT NULL UNIQUE, > > | isocode varchar(2) NOT NULL UNIQUE, > > | EN textNOT NULL, > > | DE

Re: [GENERAL] "REFERENCES" and UNIQUE

2006-01-04 Thread Stephan Szabo
On Wed, 4 Jan 2006, Stephan Szabo wrote: > Which in this case hints that there's a problem with the schema. > > What is the final effect you're looking for? The above does let you Err, that should be doesn't. > lookup the DE or FR strings for a city of a member (what if two cities had > the sa

Re: [GENERAL] "REFERENCES" and UNIQUE

2006-01-04 Thread Stephan Szabo
On Wed, 4 Jan 2006, Michelle Konzack wrote: > > __( 'stdin' )_ > / > | psql:omegasector.sql:125: ERROR: there is no unique constraint matchi > | ng given keys for referenced table "cities" > \_

Re: [GENERAL] "REFERENCES" and UNIQUE

2006-01-04 Thread Jaime Casanova
On 1/4/06, Michelle Konzack <[EMAIL PROTECTED]> wrote: > Hello, > > I get the following error: > > __( 'stdin' )_ > / > | psql:omegasector.sql:125: ERROR: there is no unique constraint matchi > | ng given keys for referenced table "cities"

[GENERAL] "REFERENCES" and UNIQUE

2006-01-04 Thread Michelle Konzack
Hello, I get the following error: __( 'stdin' )_ / | psql:omegasector.sql:125: ERROR: there is no unique constraint matchi | ng given keys for referenced table "cities" \__