Received: from bastion.solipsys.com (bastion.solipsys.com [209.117.190.2])
	by hub.org (8.9.3/8.9.3) with ESMTP id PAA40732
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 25 Jun 1999 15:33:06 -0400 (EDT)
	(envelope-from byronn@solipsys.com)
Received: from solipsys.com ([209.117.190.166])
	by bastion.solipsys.com (8.9.1a/8.9.1) with ESMTP id PAA05691;
	Fri, 25 Jun 1999 15:32:05 -0400 (EDT)
Message-ID: <3773D989.2AF75304@solipsys.com>
Date: Fri, 25 Jun 1999 15:33:29 -0400
From: Byron Nikolaidis <byronn@solipsys.com>
X-Mailer: Mozilla 4.51 [en] (WinNT; I)
X-Accept-Language: en
MIME-Version: 1.0
To: Chay Wesley <chay@ci.danville.ky.us>
CC: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
References: <004801bebf14$36a5cfc0$6301a8c0@ci.danville.ky.us>
	<3773CC36.F2848A72@solipsys.com>
	<001901bebf3d$b7b07e20$6301a8c0@ci.danville.ky.us>
Content-Type: multipart/alternative;
	boundary="------------290E0045151128295972369A"


--------------290E0045151128295972369A
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit



Chay Wesley wrote:

> If I do a 'Select * from pg_class;', I get 58 rows returned, 2 of
> which are names of tables that I expect to see from the ODBC
> end.However, if I do a 'Select * from pg_user;', I get 0 rows
> returned. How do entries make it into pg_user?  I previously ran
> 'createuser' from the command line, and have also 'granted'
> permissions on the tables. Chay Wesley

Don't do a select * from pg_class.... Do the exact entire query that you
see in the logfile  (select relname, usename .... where relkind ....)
and see what you get.

Also, if you do a "\d" in the monitor, what do you get?

Byron

--------------290E0045151128295972369A
Content-Type: text/html; charset=us-ascii
Content-Transfer-Encoding: 7bit

<!doctype html public "-//w3c//dtd html 4.0 transitional//en">
<html>
<body bgcolor="#FFFFFF">
&nbsp;
<p>Chay Wesley wrote:
<blockquote TYPE=CITE><style></style>
<font face="Arial"><font size=-1>If
I do a 'Select * from pg_class;', I get 58 rows returned, 2 of which are
names of tables that I expect to see from the ODBC end.</font></font><font face="Arial"><font size=-1>However,
if I do a 'Select * from pg_user;', I get 0 rows returned.</font></font>&nbsp;<font face="Arial"><font size=-1>How
do entries make it into pg_user?&nbsp; I previously ran 'createuser' from
the command line, and have also 'granted' permissions on the tables.</font></font>&nbsp;<font face="Arial"><font size=-1>Chay
Wesley</font></font>&nbsp;</blockquote>

<p><br>Don't do a select * from pg_class.... Do the exact entire query
that you see in the logfile&nbsp; (select relname, usename .... where relkind
....) and see what you get.
<p>Also, if you do a "\d" in the monitor, what do you get?
<p>Byron
</body>
</html>

--------------290E0045151128295972369A--