Re: problems with CREATE TABLE - Mailing list pgsql-general

From Peter Eisentraut
Subject Re: problems with CREATE TABLE
Date
Msg-id Pine.LNX.4.21.0011222358170.1093-100000@peter.localdomain
Whole thread Raw
In response to problems with CREATE TABLE  ("Martin A. Marques" <martin@math.unl.edu.ar>)
List pgsql-general
Martin A. Marques writes:

> CREATE TABLE ubicacion (
>        id        SERIAL,
>        id_palabra    INT,
>        tabla        INT NOT NULL,
>        id_row        INT NOT NULL,
>        CONSTRAINT "fk_ubic_id_palabra" FOREIGN KEY id_palabra
> REFERENCES palabras ("pid"),

... FOREIGN KEY (id_palabra) REFERENCES ...

>        CONSTRAINT "fk_tabla_s" FOREIGN KEY tabla REFERENCES tablas
> ("id_tabla")
> );

> ERROR:  parser: parse error at or near "id_palabra"

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/


pgsql-general by date:

Previous
From: GH
Date:
Subject: Weird table permission stuff.
Next
From: Sandeep Joshi
Date:
Subject: XA support / Dist. tran. support