Обсуждение: Relation "autonummeringl2" does not exist
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);
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
I changed the name of sequences in the database. It works fine now. Thanks. "Dave Cramer" <pg@fastcrypt.com> schreef in bericht news:41F2A3FB.4000206@fastcrypt.com... > 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 > > > ---------------------------(end of broadcast)--------------------------- > TIP 7: don't forget to increase your free space map settings >