Re: missing data - Mailing list pgsql-general

From Dave Perkins
Subject Re: missing data
Date
Msg-id 4.3.1.20010329143237.00aa8b20@shell.shore.net
Whole thread Raw
In response to Re: missing data  (Peter Eisentraut <peter_e@gmx.net>)
Responses Re: missing data  (Dave Perkins <drp@shore.net>)
Re: missing data  (Peter Eisentraut <peter_e@gmx.net>)
Re: missing data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general


>Depending on your definition of "no trace", this might work:  Try
>
>select relname, relowner from pg_class;
>
>If this shows table names that sound familiar, then it is likely that the
>user indicated by "relowner" disappeared.  Look into the table pg_shadow
>to make sure some user's usesysid column matches relowner.  (It's safe to
>change these with update commands.)

Thanks for the prompt reply.  I did find tables when running the SELECT you
suggested above and also found an entry in pg_shadow that matches relowner
for those tables.

Any thoughts on where this leaves me?

Thanks,
Dave


pgsql-general by date:

Previous
From: Peter Eisentraut
Date:
Subject: Re: missing data
Next
From: "Stoppel, Brett W"
Date:
Subject: ORDER BY and ignoring the , a , and an