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 по дате отправления: