Re: Foreign key creation error

Miha Radej wrote:

> Hi!
>
> I've tried creating in pgAdmin3. The generated SQL output was
>
> CREATE TABLE public."KOMENTARJI"
> (
>    "idKomentarja" bigserial NOT NULL,
>    "idRecepta" int8 NOT NULL,
>    "idUporabnika" int8 NOT NULL,
>    "Komentar" text NOT NULL,
>    "DatumVnosa" text NOT NULL,
>    "IPVnosa" text NOT NULL,
>    CONSTRAINT "fkey_KOMENTAR_RECEPT" FOREIGN KEY (idRecepta) 
> REFERENCES "RECEPTI" (idRecepta)    ON UPDATE RESTRICT ON DELETE 
> RESTRICT,
>    CONSTRAINT "fkey_KOMENTAR_UPORABNIK" FOREIGN KEY (idUporabnika) 
> REFERENCES "UPORABNIKI" (idUporabnika)    ON UPDATE RESTRICT ON DELETE 
> RESTRICT,
>    CONSTRAINT "pkey_KOMENTARJI" PRIMARY KEY ("idKomentarja")
> ) WITHOUT OIDS;
>
> When hitting OK pgAdmin reported an error. I tried manually entering 
> this query by adding quotes to column names in the foreign key 
> constraints:
>
> CREATE TABLE public."KOMENTARJI"
> (
>    "idKomentarja" bigserial NOT NULL,
>    "idRecepta" int8 NOT NULL,
>    "idUporabnika" int8 NOT NULL,
>    "Komentar" text NOT NULL,
>    "DatumVnosa" text NOT NULL,
>    "IPVnosa" text NOT NULL,
>    CONSTRAINT "fkey_KOMENTAR_RECEPT" FOREIGN KEY ("idRecepta") 
> REFERENCES "RECEPTI" ("idRecepta")    ON UPDATE RESTRICT ON DELETE 
> RESTRICT,
>    CONSTRAINT "fkey_KOMENTAR_UPORABNIK" FOREIGN KEY ("idUporabnika") 
> REFERENCES "UPORABNIKI" ("idUporabnika")    ON UPDATE RESTRICT ON 
> DELETE RESTRICT,
>    CONSTRAINT "pkey_KOMENTARJI" PRIMARY KEY ("idKomentarja")
> ) WITHOUT OIDS;
>
> and the query was accepted, the table and everything created.
>
> Did I do something wrong when creating the table and foreign keys? Or 
> is there some other reason that the column names in foreign keys 
> weren't wrapped with double quotes? 


Thanks Miha,
quoting missed, patched in CVS. There might be other places where quotes 
are missing, please don't hesitate to claim all of them.

Regards,
Andreas