Re: REFERENCES troubles - Mailing list pgsql-general

Delete the , after KEY and give owner a datatype and everything works
fine. I have tested.

Jesus.

On Wed, 5 Jul 2000, planx plnetx wrote:

> > > CREATE TABLE workers(
> > >   name        varchar(30),
> > >   firstname   varchar(30),
> > >   id_personal decimal(10)NOT NULL UNIQUE PRIMARY KEY,
> > > );
> > >
> > > CREATE TABLE payements(
> > >   date_of     date,
> > >   owner       REFERENCES   workers(id_personal)
> > > );