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

From: Ivan Petrov <ipp(at)mail(dot)bg>
To: pgsql-odbc(at)postgresql(dot)org
Subject: relation %s does not exist ??? It actually does.
Date: 2005-03-15 09:32:33
Message-ID: 1110879153.aef3c71a275f0@mail.bg
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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 ...</br>-----------------------------</br>
<a target='_blank' href="http://mail.bg/ads/adclick.php?bannerid=2218&amp;zoneid=13&amp;source=&amp;dest=http%3A%2F%2Fwww.newfilms-bg.com%2F&amp;ismap=">
“Убийствен пъзел” – вълнуващ като “Седем” и “Мълчанието на агнетата”.</br>
В кината от 11 март.</br>
http://www.newfilms-bg.com/</a><div id="beacon_2218" style="position: absolute; left: 0px; top: 0px; visibility: hidden;"><img src='http://mail.bg/ads/adlog.php?bannerid=2218&amp;clientid=1596&amp;zoneid=13&amp;source=&amp;block=0&amp;capping=0&amp;cb=9f382604dff181d16d107d000f5828ed' width='0' height='0' alt='' style='width: 0px; height: 0px;'></div>

Responses

Browse pgsql-odbc by date

  From Date Subject
Next Message Tom Lane 2005-03-15 14:50:42 Re: relation %s does not exist ??? It actually does.
Previous Message Dave Held 2005-03-14 18:28:35 ODBC + CrystalReports 10 == :(