Skip site navigation (1) Skip section navigation (2)

Re: Relation "autonummeringl2" does not exist

From: Dave Cramer <pg(at)fastcrypt(dot)com>
To: Nico <haegens_nico(at)yahoo(dot)com>
Cc: pgsql-jdbc(at)postgresql(dot)org
Subject: Re: Relation "autonummeringl2" does not exist
Date: 2005-01-22 19:05:31
Message-ID: 41F2A3FB.4000206@fastcrypt.com (view raw or flat)
Thread:
Lists: pgsql-jdbc
You should avoid upper case column names, 'autonumberingL2' is different 
than "autonumberingL2"

note the double quotes vs single quotes.

Dave

Nico wrote:

>Hello,
>as I have told, I am making a servlet that generates a menu and one that 
>changes it(deleting, adding & updating items). However it returns an error:
>Relation "autonummeringl2" does not exist
>autonummeringL2 is the name of a sequence that raises a field by 1 each time 
>it is called. Any suggestions are welcome.
>
>Nico.
>
>Here is the table creation sql:
> CREATE TABLE "tblMenuL2" (
>    "MenuL2ID" integer DEFAULT nextval('autonummeringL2'::text) NOT NULL,
>    "MenuL1ID" integer NOT NULL,
>    "MenuL2Name" character varying(50) NOT NULL,
>    "MenuL2Page" character varying(50),
>    "MenuL2Order" smallint NOT NULL
>);
>ALTER TABLE ONLY "tblMenuL2"
>    ADD CONSTRAINT "pkMenuL2ID" PRIMARY KEY ("MenuL2ID");
>ALTER TABLE ONLY "tblMenuL2"
>    ADD CONSTRAINT "fkMenuL1ID" FOREIGN KEY ("MenuL1ID") REFERENCES 
>"tblMenuL1"("MenuL1ID") ON UPDATE CASCADE ON DELETE CASCADE;
>ALTER TABLE ONLY "tblMenuL2"
>    ADD CONSTRAINT "MenuL2Volgorde" UNIQUE ("MenuL2ID", "MenuL1ID");
>
>Here is the update query & insert. It happens during the insert query.:
>UPDATE "tblMenuL2" SET "MenuL2Order"="MenuL2Order"+1 WHERE "MenuL2Order">=5; 
>INSERT INTO "tblMenuL2"("MenuL1ID", "MenuL2Name", "MenuL2Page", 
>"MenuL2Order") VALUES(1, 'naam', 'pagina', 5); 
>
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 4: Don't 'kill -9' the postmaster
>
>
>  
>

-- 
Dave Cramer
http://www.postgresintl.com
519 939 0336
ICQ#14675561


In response to

Responses

pgsql-jdbc by date

Next:From: NicoDate: 2005-01-22 19:34:31
Subject: Re: Relation "autonummeringl2" does not exist
Previous:From: NicoDate: 2005-01-22 13:03:40
Subject: Relation "autonummeringl2" does not exist

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group