Web Development

Ask something
Discussion Locked

ERROR:Relation "Category" does not exist

0 helpful
3 replies

by whyong

Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

i'm currently converting a vb program from access97 to postgres sql. In the existing program, lots of code are using "adodc1.update". but when the code run under postgres, an error message "ERROR: Relation "Category" does not exist" come out.. please help!!

Thanks!!

3 replies

by jhermiz

This may be a problem with references. It looks like your using ADO code and a reference may be pointing to DAO or at least the ADO reference is below the DAO reference. Goto tools->references and check what references are missing or what references need to be MOVED UP ahead of any old references. The update method isn't getting recognized.

Jon

by whyong

postgres is "case sensitive".. make sure that you have spelt the table name exactly in the postgres. When you open a "select statement" to get the recordset from postgres, it will not give you any error, but when you pass (update) the record back topostgres, it'll give error msg "ERROR: Relation "Category" does not exist" .. b'cos the table name "category" (small "c") and "Category" (big capital "C") are different.

This discussion is closed to new replies.