Received: from mis.ci.danville.ky.us (mis.ci.danville.ky.us [206.28.39.170]) by hub.org (8.9.3/8.9.3) with ESMTP id PAA40673 for ; Fri, 25 Jun 1999 15:32:40 -0400 (EDT) (envelope-from chay@ci.danville.ky.us) Received: from chaywesley (chaywesley.ci.danville.ky.us [192.168.1.99]) by mis.ci.danville.ky.us (8.9.1/8.9.1) with SMTP id PAA13727 for ; Fri, 25 Jun 1999 15:20:12 -0400 Message-ID: <003d01bebf41$852e8330$6301a8c0@ci.danville.ky.us> From: "Chay Wesley" To: References: <004801bebf14$36a5cfc0$6301a8c0@ci.danville.ky.us> <3773CC36.F2848A72@solipsys.com> Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables Date: Fri, 25 Jun 1999 15:32:49 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_003A_01BEBF1F.FB458040" X-Priority: 3 X-MSMail-Priority: Normal X-Mailer: Microsoft Outlook Express 5.00.2314.1300 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300 This is a multi-part message in MIME format. ------=_NextPart_000_003A_01BEBF1F.FB458040 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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=3D'select relname, usename, relhasrules from pg_class, pg_user = where relkind =3D 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = =3D int4out(relowner)order by relname'=20 [ fetched 0 rows ]=20 Where to go from here.....?? Perhaps I'm overlooking an ODBC configuration problem. Chay Wesley ------=_NextPart_000_003A_01BEBF1F.FB458040 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable

Upon further=20 investigation:

If, in the following query that is = being passed to=20 Postgresql from the ODBC driver, the table named 'pg_user' were to be = replaced=20 the table named 'pg_shadow', then the query would work, returning 72=20 rows.

query=3D'select=20 relname, usename, relhasrules from pg_class, pg_user where relkind =3D = 'r' and=20 relname !~ '^xinv[0-9]+' and int4out(usesysid) =3D = int4out(relowner)order by=20 relname'
[=20 fetched 0 rows ]

Where to go from = here.....??

Perhaps I'm overlooking an ODBC = configuration=20 problem.

Chay Wesley

------=_NextPart_000_003A_01BEBF1F.FB458040--