relation %s does not exist ??? It actually does. - Mailing list pgsql-odbc

  Hello guys,

  I am using ODBC driver to connect to Postgres via Delphi. It works fine, except a problem "ERROR: relation "sec_users" does not exist" and table sec_users exists in the database. I tried with public.sec_users and it is the same.

  In psql console application :
auto=#   select user_id
auto-#   from sec_users
auto-#   where user_name = 'postgres'
auto-#     and is_locked = false
auto-#     and passwd = md5('postgres')
auto-#     and (password_expire_date > current_timestamp or
auto(#          password_expire_date is null);
 user_id
---------
       1
(1 row)

  But I can not figure out why it doesn't work from ODBC ...----------------------------- “Убийствен пъзел” – вълнуващ като “Седем” и “Мълчанието на агнетата”. В кината от 11 март. http://www.newfilms-bg.com/