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

  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