relation %s does not exist ??? It actually does.

Поиск
Список
Период
Сортировка
От Ivan Petrov
Тема relation %s does not exist ??? It actually does.
Дата
Msg-id 1110879153.aef3c71a275f0@mail.bg
обсуждение исходный текст
Ответы Re: relation %s does not exist ??? It actually does.  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: "Dave Held"
Дата:
Сообщение: ODBC + CrystalReports 10 == :(
Следующее
От: Tom Lane
Дата:
Сообщение: Re: relation %s does not exist ??? It actually does.