Re: missing data

Dave Perkins writes:

> >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?

Either you update relowner to match an existing user, or you update an
existing user's usesysid to match relowner. Note that the first option is
more labor if you also have functions and other objects that seem
"missing".

--
Peter Eisentraut peter_e(at)gmx(dot)net http://yi.org/peter-e/