Relation Does not Exists

[zottty]

Dear Friends,

I guess the problem I am prosting right now should be quite trivial, but nevertheless I'm experienced with SQL, this does not stand for PostgreSQL.

I have a table with the stucture approx:

 idorvos | integer                  | not null default nextval(('idorvos'::text)::regclass)
nev     | character varying(255)   | not null

And I want to run the query:

INSERT INTO "orvos" ("idorvos","nev") VALUES (DEFAULT,'TESZT')

...and got the response

ERROR:  relation "idorvos" does not exist

I cannot change the query because it comes from PHPCake

Please tell me what the problem might be.

Thanks
z

[rski]

Dear Friends,

I guess the problem I am prosting right now should be quite trivial, but nevertheless I'm experienced with SQL, this does not stand for PostgreSQL.

I have a table with the stucture approx:

 idorvos | integer                  | not null default nextval(('idorvos'::text)::regclass)
nev     | character varying(255)   | not null

And I want to run the query:

INSERT INTO "orvos" ("idorvos","nev") VALUES (DEFAULT,'TESZT')

...and got the response

ERROR:  relation "idorvos" does not exist

I cannot change the query because it comes from PHPCake

Please tell me what the problem might be.

Thanks
z

INSERT INTO "orvos" (idorvos,nev) VALUES (DEFAULT,'TESZT ')

[zottty]

INSERT INTO "orvos" (idorvos,nev) VALUES (DEFAULT,'TESZT ')

Unfortunately that does not make a difference.

[rski]

Unfortunately that does not make a difference.

Did you receive the same error?
Do you have a sequence called idorvos?

[zottty]

Did you receive the same error?
Do you have a sequence called idorvos?

Thank you a lot. That was the problem, the problem was with the sequence, which didn't exists...

Best Luck
z