From: | "Martin A(dot) Marques" <martin(at)math(dot)unl(dot)edu(dot)ar> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | problems with CREATE TABLE |
Date: | 2000-11-22 22:30:24 |
Message-ID: | 00112219302400.20983@math.unl.edu.ar |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I'm on Potsgres 7.0.2 on Solaris, and I get a parse error when I try to
create this table:
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"),
CONSTRAINT "fk_tabla_s" FOREIGN KEY tabla REFERENCES tablas
("id_tabla")
);
OK, the table palabras and the table tablas exist, as they also have those
columnas to reference to. The error I get is:
ERROR: parser: parse error at or near "id_palabra"
If you need the CREATE TABLE statements of the other tables I can send them.
Saludos... :-)
--
"And I'm happy, because you make me feel good, about me." - Melvin Udall
-----------------------------------------------------------------
Martín Marqués email: martin(at)math(dot)unl(dot)edu(dot)ar
Santa Fe - Argentina http://math.unl.edu.ar/~martin/
Administrador de sistemas en math.unl.edu.ar
-----------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | GH | 2000-11-22 22:35:34 | Weird table permission stuff. |
Previous Message | George Armhold | 2000-11-22 21:45:34 | Re: trouble migrating from 6.3.2 (IRIX) to 7.0.2 (Linux) |