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:32:49
Message-ID: 003d01bebf41$852e8330$6301a8c0@ci.danville.ky.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Browse pgsql-interfaces by date

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