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 PAA42954
	for <pgsql-interfaces@postgreSQL.org>;
	Fri, 25 Jun 1999 15:44:15 -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 PAA14887;
	Fri, 25 Jun 1999 15:31:46 -0400
Message-ID: <004d01bebf43$226522c0$6301a8c0@ci.danville.ky.us>
From: "Chay Wesley" <chay@ci.danville.ky.us>
To: "Byron Nikolaidis" <byronn@solipsys.com>
Cc: <pgsql-interfaces@postgreSQL.org>
References: <004801bebf14$36a5cfc0$6301a8c0@ci.danville.ky.us>
	<3773CC36.F2848A72@solipsys.com>
	<001901bebf3d$b7b07e20$6301a8c0@ci.danville.ky.us>
	<3773D989.2AF75304@solipsys.com>
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Date: Fri, 25 Jun 1999 15:44:23 -0400
MIME-Version: 1.0
Content-Type: multipart/alternative;
	boundary="----=_NextPart_000_004A_01BEBF21.98FAECC0"
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_004A_01BEBF21.98FAECC0
Content-Type: text/plain;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

  jobshop=3D>=20

  jobshop=3D> select relname, usename, relhasrules from pg_class, =
pg_user where relk
  ind =3D 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) =3D =
int4out(relowner)
  order by relname;
  relname|usename|relhasrules
  -------+-------+-----------
  (0 rows)

  jobshop=3D>

  jobshop=3D> \d
  Couldn't find any tables, sequences or indices!
  jobshop=3D>

  jobshop=3D> \d joblistings   <- The name of one of my tables.

  Table    =3D joblistings
  =
+----------------------------------+----------------------------------+--=
-----+
  |              Field               |              Type                =
| Length|
  =
+----------------------------------+----------------------------------+--=
-----+
  | listingid                        | int4 not null default nextval('j =
|     4 |
  | officeid                         | int4                             =
|     4 |
  | posteddate                       | date                             =
|     4 |
  | enabled                          | bool                             =
|     1 |
  | description                      | text                             =
|   var |
  | numpositions                     | int2                             =
|     2 |
  | locationdescription              | text                             =
|   var |
  | extrahtml                        | text                             =
|   var |
  =
+----------------------------------+----------------------------------+--=
-----+
  Index:    joblistings_listingid_key

  jobshop=3D>=20





  Don't do a select * from pg_class.... Do the exact entire query that =
you see in the logfile  (select relname, usename .... where relkind =
....) and see what you get.=20

  Also, if you do a "\d" in the monitor, what do you get?=20

  Byron=20


------=_NextPart_000_004A_01BEBF21.98FAECC0
Content-Type: text/html;
	charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable

<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META content=3D"text/html; charset=3Diso-8859-1" =
http-equiv=3DContent-Type>
<META content=3D"MSHTML 5.00.2314.1000" name=3DGENERATOR>
<STYLE></STYLE>
</HEAD>
<BODY bgColor=3D#ffffff>
<BLOCKQUOTE=20
style=3D"BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: =
0px; PADDING-LEFT: 5px; PADDING-RIGHT: 0px">
  <P><FONT face=3DArial size=3D2><FONT face=3DCourier =
size=3D2>jobshop=3D&gt;=20
  </FONT></FONT></P>
  <P><FONT face=3DCourier size=3D2>jobshop=3D&gt; select relname, =
usename, relhasrules=20
  from pg_class, pg_user where relk<BR>ind =3D 'r' and relname !~ =
'^xinv[0-9]+'=20
  and int4out(usesysid) =3D int4out(relowner)<BR>order by=20
  =
relname;<BR>relname|usename|relhasrules<BR>-------+-------+-----------<BR=
>(0=20
  rows)</FONT></P>
  <P><FONT face=3DCourier size=3D2>jobshop=3D&gt;</FONT></P>
  <P><FONT face=3DCourier size=3D2>jobshop=3D&gt; \d<BR>Couldn't find =
any tables,=20
  sequences or indices!<BR>jobshop=3D&gt;</FONT></P>
  <P><FONT face=3DCourier size=3D2>jobshop=3D&gt; \d =
joblistings&nbsp;&nbsp; &lt;- The=20
  name of one of my tables.</FONT>
  <P><FONT face=3DCourier size=3D2>Table&nbsp;&nbsp;&nbsp; =3D=20
  =
joblistings<BR>+----------------------------------+----------------------=
------------+-------+<BR>|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  =
Field&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;=20
  =
|&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;=20
  =
Type&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;=20
  |=20
  =
Length|<BR>+----------------------------------+--------------------------=
--------+-------+<BR>|=20
  =
listingid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;=20
  | int4 not null default nextval('j |&nbsp;&nbsp;&nbsp;&nbsp; 4 |<BR>|=20
  =
officeid&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;=20
  |=20
  =
int4&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |&nbsp;&nbsp;&nbsp;&nbsp; 4 |<BR>|=20
  =
posteddate&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |=20
  =
date&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |&nbsp;&nbsp;&nbsp;&nbsp; 4 |<BR>|=20
  =
enabled&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;=20
  |=20
  =
bool&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |&nbsp;&nbsp;&nbsp;&nbsp; 1 |<BR>|=20
  =
description&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&n=
bsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |=20
  =
text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |&nbsp;&nbsp; var |<BR>|=20
  =
numpositions&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&=
nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |=20
  =
int2&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |&nbsp;&nbsp;&nbsp;&nbsp; 2 |<BR>|=20
  =
locationdescription&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;=
&nbsp;&nbsp;&nbsp;&nbsp;=20
  |=20
  =
text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |&nbsp;&nbsp; var |<BR>|=20
  =
extrahtml&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp=
;=20
  |=20
  =
text&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nb=
sp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbs=
p;&nbsp;&nbsp;&nbsp;&nbsp;=20
  |&nbsp;&nbsp; var=20
  =
|<BR>+----------------------------------+--------------------------------=
--+-------+<BR>Index:&nbsp;&nbsp;&nbsp;=20
  joblistings_listingid_key</FONT>
  <P><FONT face=3DArial size=3D2><FONT face=3DCourier =
size=3D2>jobshop=3D&gt;=20
  </FONT></FONT>
  <P>&nbsp;
  <P>&nbsp;
  <P>Don't do a select * from pg_class.... Do the exact entire query =
that you=20
  see in the logfile&nbsp; (select relname, usename .... where relkind =
....) and=20
  see what you get.=20
  <P>Also, if you do a "\d" in the monitor, what do you get?=20
  <P>Byron </P></BLOCKQUOTE></BODY></HTML>

------=_NextPart_000_004A_01BEBF21.98FAECC0--