Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables

From: Byron Nikolaidis <byronn(at)solipsys(dot)com>
To: Chay Wesley <chay(at)ci(dot)danville(dot)ky(dot)us>
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Date: 1999-06-25 19:33:29
Message-ID: 3773D989.2AF75304@solipsys.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

In response to

Responses

Browse pgsql-interfaces by date

  From Date Subject
Next Message Chay Wesley 1999-06-25 19:44:23 Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Previous Message Chay Wesley 1999-06-25 19:32:49 Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables