REFERENCES troubles

From: "planx plnetx" <planetx2100(at)hotmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: REFERENCES troubles
Date: 2000-07-04 20:59:04
Message-ID: 20000704205904.84017.qmail@hotmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Eric Jain 2000-07-04 21:09:02 RE: Combining two SELECTs
Previous Message Eric Jain 2000-07-04 20:36:01 Combining two SELECTs