From: | Ivan Petrov <ipp(at)mail(dot)bg> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | pgsql-odbc(at)postgresql(dot)org |
Subject: | Re: relation %s does not exist ??? It actually does. |
Date: | 2005-03-15 19:50:58 |
Message-ID: | 1110916258.16cf32ea6f287@mail.bg |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-odbc |
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(at)sss(dot)pgh(dot)pa(dot)us>:
> Ivan Petrov <ipp(at)mail(dot)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(at)postgresql(dot)org)
>
--------------------------------------
Това писмо е изпратено от www.mail.bg
Безплатната поща в mail.bg предлага:
- Силна защита срещу СПАМ/рекламни писма
- 30MB безплатно (SMS от 2лв=3GB!)
- 30MB макс. размер на прикачен файл
- SMS за ново писмо (всички оператори)
- WAP достъп от GSM и без компютър
- Безплатен POP3 достъп
- 24 часов телефон за помощ/поддръжка
______________________________________
БЕЗ ИЗЛИШНИ ВЪПРОСИ РЕГИСТРИРАЙТЕ СВОЙ
БЕЗПЛАТЕН АДРЕС НА http://www.mail.bg
From | Date | Subject | |
---|---|---|---|
Next Message | Elford,Andrew [Ontario] | 2005-03-15 19:57:15 | something is corrupting the data |
Previous Message | Tom Lane | 2005-03-15 14:50:42 | Re: relation %s does not exist ??? It actually does. |