Обсуждение: relation %s does not exist ??? It actually does.

  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/

Ivan Petrov <ipp@mail.bg> writes:
>   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=3D#   select user_id
> auto-#   from sec_users
> auto-#   where user_name =3D 'postgres'
> auto-#     and is_locked =3D false
> auto-#     and passwd =3D 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 ...

Sure you're connecting to the same database in both cases?  As the same
user?  (If they are different users, maybe one has a different schema
search_path set by default?)

            regards, tom lane

  The same database, same user, same table. The only
difference is that in the first case I am connected through
ODBC, the second - through psql console application. When I
tried with PostgresDAC from microolap.com - it works fine.
It seems it is something with the ODBC driver...




Цитат на писмо от Tom Lane <tgl@sss.pgh.pa.us>:

> Ivan Petrov <ipp@mail.bg> writes:
> >   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=3D#   select user_id
> > auto-#   from sec_users
> > auto-#   where user_name =3D 'postgres'
> > auto-#     and is_locked =3D false
> > auto-#     and passwd =3D 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 ...
>
> Sure you're connecting to the same database in both
> cases?  As the same
> user?  (If they are different users, maybe one has a
> different schema
> search_path set by default?)
>
>             regards, tom lane
>
> ---------------------------(end of
> broadcast)---------------------------
> TIP 2: you can get off all lists at once with the
> unregister command
>     (send "unregister YourEmailAddressHere" to
> majordomo@postgresql.org)
>






--------------------------------------
Това писмо е изпратено от  www.mail.bg

Безплатната поща в mail.bg предлага:
- Силна защита срещу СПАМ/рекламни писма
- 30MB безплатно (SMS от 2лв=3GB!)
- 30MB макс. размер на прикачен файл
- SMS за ново писмо (всички оператори)
- WAP достъп от GSM и без компютър
- Безплатен POP3 достъп
- 24 часов телефон за помощ/поддръжка
______________________________________
БЕЗ ИЗЛИШНИ ВЪПРОСИ РЕГИСТРИРАЙТЕ СВОЙ
БЕЗПЛАТЕН АДРЕС НА  http://www.mail.bg