Re: Parse error creating tables

From: "Nikola Milutinovic" <Nikola(dot)Milutinovic(at)ev(dot)co(dot)yu>
To: "Juan Jose Natera Abreu" <jnatera(at)net-uno(dot)net>
Cc: "PostgreSQL novice" <pgsql-novice(at)postgresql(dot)org>
Subject: Re: Parse error creating tables
Date: 2001-06-19 05:16:20
Message-ID: 001f01c0f87e$f9d24a50$6e3da8c0@ev.co.yu
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-novice

> 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)
> );
FOREIGN KEY <field> REFERENCES <table>

Where <field is a field in your table and <table> is another table, your table is referncing.

Nix.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Diogo Saad 2001-06-19 21:51:01 database size
Previous Message GH 2001-06-19 03:14:52 Re: Insert into two tables