<blockquote style="BORDER-LEFT: #000000 2px solid; MARGIN-LEFT: 5px; MARGIN-RIGHT: 0px; PADDING-LEFT: 5px;
PADDING-RIGHT:0px"><p><font face="Arial" size="2"><font face="Courier" size="2">jobshop=> </font></font><p><font
face="Courier"size="2">jobshop=> select relname, usename, relhasrules from pg_class, pg_user where relk<br />ind =
'r'and relname !~ '^xinv[0-9]+' and int4out(usesysid) = int4out(relowner)<br />order by relname;<br
/>relname|usename|relhasrules<br/>-------+-------+-----------<br />(0 rows)</font><p><font face="Courier"
size="2">jobshop=></font><p><fontface="Courier" size="2">jobshop=> \d<br />Couldn't find any tables, sequences or
indices!<br/>jobshop=></font><p><font face="Courier" size="2">jobshop=> \d joblistings <- The name of one of
mytables.</font><p><font face="Courier" size="2">Table = joblistings<br
/>+----------------------------------+----------------------------------+-------+<br/>|
Field | Type | Length|<br
/>+----------------------------------+----------------------------------+-------+<br/>|
listingid | int4 not null default nextval('j | 4 |<br />| officeid |
int4 | 4 |<br />| posteddate | date
| 4 |<br />| enabled | bool | 1 |<br />|
description | text | var |<br />| numpositions |
int2 | 2 |<br />| locationdescription | text
| var |<br />| extrahtml | text | var |<br
/>+----------------------------------+----------------------------------+-------+<br/>Index:
joblistings_listingid_key</font><p><fontface="Arial" size="2"><font face="Courier" size="2">jobshop=>
</font></font><p> <p> <p>Don't do a select * from pg_class.... Do the exact entire query that you see in the logfile
(selectrelname, usename .... where relkind ....) and see what you get. <p>Also, if you do a "\d" in the monitor, what
doyou get? <p>Byron </blockquote>
