Re: REFERENCES troubles

>From: "Robert B. Easter" <reaster@comptechnews.com>
>To: "planx plnetx" <planetx2100@hotmail.com>, pgsql-general@postgresql.org
>Subject: Re: [GENERAL] REFERENCES troubles
>Date: Tue, 4 Jul 2000 18:38:28 -0400
>
>On Tue, 04 Jul 2000, planx plnetx wrote:
> > 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...
>
>You could try something like this instead:
>
>CREATE TABLE workers(
>    id_personal    SERIAL PRIMARY KEY,
>    name        VARCHAR(30),
>    firstname        VARCHAR(30)
>);
>CREATE TABLE payements(
>    date_of        DATE,
>    owner        REFERENCES   workers
>);
>
>PRIMARY KEY implies UNIQUE NOT NULL
>SERIAL will be an INTEGER DEFAULT nextval('workers_id_personal_seq') so
>they
>get a number automatically.

Yes thanks, but why I can't specify a column like the manual say:
REFERENCES   workers(id_personal)?

how the simple REFERENCES workers can get the primary key? maybe it is
automatiQUE????????
________________________________________________________________________
Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com