problem creating table
От | blackgr |
---|---|
Тема | problem creating table |
Дата | |
Msg-id | Pine.LNX.4.10.9907011627130.829-100000@localhost.localdomain обсуждение исходный текст |
Ответы |
Re: [SQL] problem creating table
|
Список | pgsql-sql |
I haven't been able to get following definition for table entity to work. I keep getting a "parse error at or near position." The definition for table phone works fine. I can delete the line with the definition for position and the table is created, but why escapes me at the moment. Any clues appreciated. Glynn Black blackgr@alltel.net CREATE SEQUENCE entity_id_seq; CREATE TABLE entity (entity_id_number int4 DEFAULT NEXTVAL('entity_id_seq'),name varchar(60) not null,address1 varchar(60)not null,address2 varchar(60),city varchar(60) not null,state char(2) not null,zip char(10) not null,descriptionvarchar(60),type int2 not null,position int2 not null, PRIMARY KEY (entity_id_number)); CREATE SEQUENCE phone_id_seq; CREATE TABLE phone (phone_id_number int4 DEFAULT NEXTVAL('phone_id_seq'),entity int4 not null,type int2 not null,phone_numberchar(7) not null,area_code char(3) not null, PRIMARY KEY (phone_id_number));
В списке pgsql-sql по дате отправления: