Re: missing data

Поиск
Список
Период
Сортировка
От Dave Perkins
Тема Re: missing data
Дата
Msg-id 4.3.1.20010329143237.00aa8b20@shell.shore.net
обсуждение исходный текст
Ответ на Re: missing data  (Peter Eisentraut <peter_e@gmx.net>)
Ответы Re: missing data
Re: missing data
Re: missing data
Список 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 по дате отправления:

Предыдущее
От: Peter Eisentraut
Дата:
Сообщение: Re: missing data
Следующее
От: "Stoppel, Brett W"
Дата:
Сообщение: ORDER BY and ignoring the , a , and an