Parse error creating tables
От | Juan Jose Natera Abreu |
---|---|
Тема | Parse error creating tables |
Дата | |
Msg-id | 01061812180803.25813@juanjose обсуждение исходный текст |
Список | pgsql-novice |
Hello all, I Just installed PostGreSQL 7.1.2, and i created a database, but i am not able to create the tables i need to, Here are 2 of the tables i am trying to create: CREATE TABLE Distribucion ( Id serial PRIMARY KEY NOT NULL, Nombre varchar(15) ); CREATE TABLE Perfil_Aplicacion ( Id serial PRIMARY KEY NOT NULL, Nombre varchar(20), Abreviatura char(4), Descripcion varchar(50), Distribucion integer, Enviar_Correo boolean, Enviar_Page boolean, Enviar_Popup boolean, Numero_Aprobadores integer, Numero_Acciones integer, Cierre_Automatico boolean, Caduca integer, FOREIGN KEY Distribucion REFERENCES Distribucion(Id) ); I always get parsing errors like: psql:/home/juanjose/proyectos/TroubleTickets/TablasTT.sql:39: ERROR: parser: parse error at or near "distribucion" Since i couldnt create them by hand, I tryed using pgaccess 0.98.7 but if i try to add a constraint i get the same error and the table is not created, what am i doing wrong? Thanks Juan Jose -- fortune generated signature: Everyone talks about apathy, but no one ____does anything about it.
В списке pgsql-novice по дате отправления: