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

From Chay Wesley
Subject Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Date
Msg-id 003d01bebf41$852e8330$6301a8c0@ci.danville.ky.us
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
Upon further investigation:
 
If, in the following query that is being passed to Postgresql from the ODBC driver, the table named 'pg_user' were to be replaced the table named 'pg_shadow', then the query would work, returning 72 rows.
 
query='select relname, usename, relhasrules from pg_class, pg_user where relkind = 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)order by relname'
    [ fetched 0 rows ]
 
Where to go from here.....??
 
Perhaps I'm overlooking an ODBC configuration problem.
 
 
Chay Wesley

pgsql-interfaces by date:

Previous
From: "Chay Wesley"
Date:
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Next
From: Byron Nikolaidis
Date:
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables