Re: missing data

From: Dave Perkins <drp(at)shore(dot)net>
To: Peter Eisentraut <peter_e(at)gmx(dot)net>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: missing data
Date: 2001-03-29 20:37:31
Message-ID: 4.3.1.20010329143237.00aa8b20@shell.shore.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

In response to

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Dave Perkins 2001-03-29 21:00:36 Re: missing data
Previous Message Tom Lane 2001-03-29 20:30:08 Re: missing data