Re: REFERENCES troubles
От | Robert B. Easter |
---|---|
Тема | Re: REFERENCES troubles |
Дата | |
Msg-id | 00070418482603.01354@comptechnews обсуждение исходный текст |
Ответ на | REFERENCES troubles ("planx plnetx" <planetx2100@hotmail.com>) |
Список | pgsql-general |
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. > ________________________________________________________________________ > Get Your Private, Free E-mail from MSN Hotmail at http://www.hotmail.com -- Robert
В списке pgsql-general по дате отправления: