From: Chay Wesley <chay@ci.danville.ky.us>
To: Byron Nikolaidis <byronn@solipsys.com>
Cc: pgsql-interfaces@postgreSQL.org
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
Date: Fri, 25 Jun 1999 15:44:23 -0400
Message-ID: <004d01bebf43$226522c0$6301a8c0@ci.danville.ky.us> (raw)
References: <004801bebf14$36a5cfc0$6301a8c0@ci.danville.ky.us>
<3773CC36.F2848A72@solipsys.com>
<001901bebf3d$b7b07e20$6301a8c0@ci.danville.ky.us>
<3773D989.2AF75304@solipsys.com>
jobshop=>
jobshop=> select relname, usename, relhasrules from pg_class, pg_user where relk
ind = 'r' and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)
order by relname;
relname|usename|relhasrules
-------+-------+-----------
(0 rows)
jobshop=>
jobshop=> \d
Couldn't find any tables, sequences or indices!
jobshop=>
jobshop=> \d joblistings <- The name of one of my tables.
Table = 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=>
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.
Also, if you do a "\d" in the monitor, what do you get?
Byron
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-interfaces@postgresql.org
Cc: chay@ci.danville.ky.us, byronn@solipsys.com
Subject: Re: [INTERFACES] ODBC 6.4 + PostgreSQL 6.5 = Can't browse tables
In-Reply-To: <004d01bebf43$226522c0$6301a8c0@ci.danville.ky.us>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox