This question is locked. New answers and comments are not allowed.
Hello there, I am having a hard time with OA and Postgresql. It seems that I doesn't see any sequence when I am creating a table based on inheritance. For example:
I am having the table:
CREATE TABLE audit."Updates" (
"idUser" INTEGER NOT NULL,
"updateTime" DATE DEFAULT now() NOT NULL,
"idUpdateType" INTEGER NOT NULL
) WITHOUT OIDS;
Which serves as a base table for my auditing tables. Then I have a table from another schema, which hold the data that I am showing to the end user.
CREATE TABLE public."Class" (
"idClass" SERIAL,
"name" VARCHAR(150),
CONSTRAINT "Clas_pkey" PRIMARY KEY("idClass")
) WITHOUT OIDS;
As you can see there are two tables on different schema. Now I create the table:
CREATE TABLE audit."ClassUpdates" (
"ID" SERIAL,
CONSTRAINT "ClassUpdates_pkey" PRIMARY KEY("ID")
) INHERITS (audit."Updates", public."Curs")
WITHOUT OIDS;
So far no problem, add the tables Class and ClassUpdates in the same diagram to be mapped in and also to use the same context. It passes the validation and the classes are generated. Next I try to add some records in Class table, with no problems, but when I try to add the update made to the class table in my ClassUpdates table it shows me an error that the sequence created in ClassUpdate isn't seen by OA.
Where it is the problem?
Thanks in advance,
Lord Revan 007
I am having the table:
CREATE TABLE audit."Updates" (
"idUser" INTEGER NOT NULL,
"updateTime" DATE DEFAULT now() NOT NULL,
"idUpdateType" INTEGER NOT NULL
) WITHOUT OIDS;
Which serves as a base table for my auditing tables. Then I have a table from another schema, which hold the data that I am showing to the end user.
CREATE TABLE public."Class" (
"idClass" SERIAL,
"name" VARCHAR(150),
CONSTRAINT "Clas_pkey" PRIMARY KEY("idClass")
) WITHOUT OIDS;
As you can see there are two tables on different schema. Now I create the table:
CREATE TABLE audit."ClassUpdates" (
"ID" SERIAL,
CONSTRAINT "ClassUpdates_pkey" PRIMARY KEY("ID")
) INHERITS (audit."Updates", public."Curs")
WITHOUT OIDS;
So far no problem, add the tables Class and ClassUpdates in the same diagram to be mapped in and also to use the same context. It passes the validation and the classes are generated. Next I try to add some records in Class table, with no problems, but when I try to add the update made to the class table in my ClassUpdates table it shows me an error that the sequence created in ClassUpdate isn't seen by OA.
Where it is the problem?
Thanks in advance,
Lord Revan 007