Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables - Mailing list pgsql-interfaces

From Byron Nikolaidis
Subject Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Date
Msg-id 3773D989.2AF75304@solipsys.com
Whole thread Raw
In response to ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables  ("Chay Wesley" <chay@ci.danville.ky.us>)
List pgsql-interfaces
  <p>Chay Wesley wrote: <blockquote type="CITE"><style></style><font face="Arial"><font size="-1">If I do a 'Select *
frompg_class;', I get 58 rows returned, 2 of which are names of tables that I expect to see from the ODBC
end.</font></font><fontface="Arial"><font size="-1">However, if I do a 'Select * from pg_user;', I get 0 rows
returned.</font></font> <fontface="Arial"><font size="-1">How do entries make it into pg_user?  I previously ran
'createuser'from the command line, and have also 'granted' permissions on the tables.</font></font> <font
face="Arial"><fontsize="-1">Chay Wesley</font></font> </blockquote><p><br />Don't do a select * from pg_class.... Do
theexact entire query that you see in the logfile  (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  

pgsql-interfaces by date:

Previous
From: "Chay Wesley"
Date:
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Next
From: PostgreSQL Admin
Date:
Subject: libpq, Large Objects, Type lo