REFERENCES troubles - Mailing list pgsql-general

From planx plnetx
Subject REFERENCES troubles
Date
Msg-id 20000704205904.84017.qmail@hotmail.com
Whole thread Raw
Responses Re: REFERENCES troubles  ("Robert B. Easter" <reaster@comptechnews.com>)
Re: REFERENCES troubles  (JanWieck@t-online.de (Jan Wieck))
List pgsql-general
I get this error when creating a database:

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)
);


IT gimme error!!!
why this isn't right?
the postgres documentation seem say to do in this manner...
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com


pgsql-general by date:

Previous
From: "Eric Jain"
Date:
Subject: Combining two SELECTs
Next
From: teg@redhat.com (Trond Eivind Glomsrød)
Date:
Subject: Re: [HACKERS] proposed improvements to PostgreSQL license