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,
> >
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
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
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"
> \_
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"
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"
\__