Parse error creating tables - Mailing list pgsql-novice

From Juan Jose Natera Abreu
Subject Parse error creating tables
Date
Msg-id 01061812180803.25813@juanjose
Whole thread Raw
List 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 by date:

Previous
From: "Diogo Saad"
Date:
Subject: database size
Next
From: harrold@sage.che.pitt.edu
Date:
Subject: Re: Perl postgres question