This question is locked. New answers and comments are not allowed.
Hi,
It's PostgreSQL 9.1
I upgraded yestrday to latest OAORM version and now I have HUGH problems with sequences. I can't insert into any table throw OAORM. I noticed it on a new project on which I work. Now I check other projects and they also now don't work anymore! Error is always when inserting and always about sequence :
Telerik.OpenAccess.RT.sql.SQLException: ERROR: 42P01: relation "cloud.tabCloudDok_id_cldok_master_seq" does not exist
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)
at OpenAccessRuntime.Relational.sql.PostgresSqlDriver.getAutoIncColumnValue(RelationalTable classTable, Connection con, Statement stat)
at OpenAccessRuntime.Relational.sql.AutoIncRelationalKeyGenerator.generatePrimaryKeyPost(String className, RelationalTable classTable, Object[] data, Connection con, Statement stat)
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
at OpenAccessRuntime.Relational.RelationalStorageManager.persistPass1(PersistGraph graph)
In version that I have previus (2011.2 or 2011.1) everything is worked OK!
Please Help, it's urgent.
p.s. Here is one table :
CREATE TABLE cloud."tabCloudDok" (
id_cldok_master INTEGER DEFAULT nextval('clouddok_id_master_seq'::text::regclass) NOT NULL,
id_dok INTEGER NOT NULL,
id_master INTEGER NOT NULL,
sifvrste CHAR(3),
vrsta VARCHAR(30),
broj_cloud INTEGER,
broj INTEGER NOT NULL,
brojdoc VARCHAR(30) NOT NULL,
datum DATE NOT NULL,
valuta DATE DEFAULT 'now'::text::date,
psifra VARCHAR(20),
pnaziv VARCHAR(60),
padresa VARCHAR(70),
osifra VARCHAR(15),
onaziv VARCHAR(60),
oadresa VARCHAR(60),
opis VARCHAR(60),
napomena VARCHAR(200),
inokurs NUMERIC(14,4),
inomon VARCHAR(5),
status SMALLINT DEFAULT 0,
pecat_i TIMESTAMP WITHOUT TIME ZONE,
storno BOOLEAN DEFAULT false,
radnik VARCHAR(32),
znak CHAR(1),
isporuka VARCHAR(64) DEFAULT '-'::character varying,
CONSTRAINT "CloudDok_pkey" PRIMARY KEY(id_cldok_master),
CONSTRAINT "unique_idx_CloudDok" UNIQUE(id_dok, id_master),
) WITHOUT OIDS;
It's PostgreSQL 9.1
I upgraded yestrday to latest OAORM version and now I have HUGH problems with sequences. I can't insert into any table throw OAORM. I noticed it on a new project on which I work. Now I check other projects and they also now don't work anymore! Error is always when inserting and always about sequence :
Telerik.OpenAccess.RT.sql.SQLException: ERROR: 42P01: relation "cloud.tabCloudDok_id_cldok_master_seq" does not exist
at Telerik.OpenAccess.RT.Adonet2Generic.Impl.StatementImp.executeQuery(String sql)
at OpenAccessRuntime.Relational.sql.PostgresSqlDriver.getAutoIncColumnValue(RelationalTable classTable, Connection con, Statement stat)
at OpenAccessRuntime.Relational.sql.AutoIncRelationalKeyGenerator.generatePrimaryKeyPost(String className, RelationalTable classTable, Object[] data, Connection con, Statement stat)
at OpenAccessRuntime.Relational.RelationalStorageManager.generateInserts(NewObjectOID oid, Int32 index, ClassMetaData cmd, PersistGraph graph, Int32[] fieldNos, CharBuf s, Object[] oidData, IntArray toUpdateIndexes)
at OpenAccessRuntime.Relational.RelationalStorageManager.persistPass1(PersistGraph graph)
In version that I have previus (2011.2 or 2011.1) everything is worked OK!
Please Help, it's urgent.
p.s. Here is one table :
CREATE TABLE cloud."tabCloudDok" (
id_cldok_master INTEGER DEFAULT nextval('clouddok_id_master_seq'::text::regclass) NOT NULL,
id_dok INTEGER NOT NULL,
id_master INTEGER NOT NULL,
sifvrste CHAR(3),
vrsta VARCHAR(30),
broj_cloud INTEGER,
broj INTEGER NOT NULL,
brojdoc VARCHAR(30) NOT NULL,
datum DATE NOT NULL,
valuta DATE DEFAULT 'now'::text::date,
psifra VARCHAR(20),
pnaziv VARCHAR(60),
padresa VARCHAR(70),
osifra VARCHAR(15),
onaziv VARCHAR(60),
oadresa VARCHAR(60),
opis VARCHAR(60),
napomena VARCHAR(200),
inokurs NUMERIC(14,4),
inomon VARCHAR(5),
status SMALLINT DEFAULT 0,
pecat_i TIMESTAMP WITHOUT TIME ZONE,
storno BOOLEAN DEFAULT false,
radnik VARCHAR(32),
znak CHAR(1),
isporuka VARCHAR(64) DEFAULT '-'::character varying,
CONSTRAINT "CloudDok_pkey" PRIMARY KEY(id_cldok_master),
CONSTRAINT "unique_idx_CloudDok" UNIQUE(id_dok, id_master),
) WITHOUT OIDS;