Skip site navigation (1) Skip section navigation (2)

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 (view raw or flat)
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

pgsql-interfaces by date

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

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group