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