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 PAA36829 for ; Fri, 25 Jun 1999 15:05:27 -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 OAA11025 for ; Fri, 25 Jun 1999 14:53:03 -0400 Message-ID: <001901bebf3d$b7b07e20$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:05:39 -0400 MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_NextPart_000_0016_01BEBF1C.2F9B29C0" 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_0016_01BEBF1C.2F9B29C0 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable 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 -----=20 From: Byron Nikolaidis=20 To: Chay Wesley=20 Cc: pgsql-interfaces@postgreSQL.org=20 Sent: Friday, June 25, 1999 2:36 PM Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 =3D Can't browse = tables The log shows that 0 rows are coming back. Are you sure you have any = tables?=20 Try running the exact query above in the psql monitor and see what = happens.=20 Byron=20 ------=_NextPart_000_0016_01BEBF1C.2F9B29C0 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable
If I do a 'Select * from pg_class;', I = get 58 rows=20 returned, 2 of which are names of tables that I expect to see from the = ODBC=20 end.
However, if I do a 'Select * from = pg_user;', I get=20 0 rows returned.
 
How do entries make it into = pg_user? =20 I previously ran 'createuser' from the command line, and have also=20 'granted' permissions on the tables.
 
Chay Wesley
 
 
----- Original Message -----
From:=20 Byron=20 Nikolaidis
To: Chay=20 Wesley
Cc: pgsql-interfaces@postgreSQL.org=20
Sent: Friday, June 25, 1999 = 2:36 PM
Subject: Re: [INTERFACES] ODBC = 6.4 +=20 PostgreSQL 6.5 =3D Can't browse tables

 

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

Byron

------=_NextPart_000_0016_01BEBF1C.2F9B29C0--