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

From Ivan Petrov
Subject relation %s does not exist ??? It actually does.
Date
Msg-id 1110879153.aef3c71a275f0@mail.bg
Whole thread Raw
Responses Re: relation %s does not exist ??? It actually does.
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/

pgsql-odbc by date:

Previous
From: "Dave Held"
Date:
Subject: ODBC + CrystalReports 10 == :(
Next
From: Tom Lane
Date:
Subject: Re: relation %s does not exist ??? It actually does.