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