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

From: "Chay Wesley" <chay(at)ci(dot)danville(dot)ky(dot)us>
To: <pgsql-interfaces(at)postgreSQL(dot)org>
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Date: 1999-06-25 19:05:39
Message-ID: 001901bebf3d$b7b07e20$6301a8c0@ci.danville.ky.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-interfaces

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

----- Original Message -----
From: Byron Nikolaidis
To: Chay Wesley
Cc: pgsql-interfaces(at)postgreSQL(dot)org
Sent: Friday, June 25, 1999 2:36 PM
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables

The log shows that 0 rows are coming back. Are you sure you have any tables?
Try running the exact query above in the psql monitor and see what happens.

Byron

In response to

Responses

Browse pgsql-interfaces by date

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