Re: No xmin in pg_database
| От | Tom Lane |
|---|---|
| Тема | Re: No xmin in pg_database |
| Дата | |
| Msg-id | 2241619.1630579303@sss.pgh.pa.us обсуждение |
| Ответ на | No xmin in pg_database (Alexander Kass <alexander.kass@jetbrains.com>) |
| Ответы |
Re: No xmin in pg_database
|
| Список | pgsql-general |
Laurenz Albe <laurenz.albe@cybertec.at> writes:
> On Thu, 2021-09-02 at 08:50 +0300, Alexander Kass wrote:
>> We have a small number of users that do not have xmin in pg_database
>> (we've asked them to try `select xmin from pg_database` and got
>> `column xmin does not exist`).
> All PostgreSQL tables have "xmin", and all catalog tables do as well.
Indeed. This seems to be evidence of corruption in the pg_attribute
catalog. If you're really lucky, reindexing pg_attribute might fix
it, though I wonder what other problems there are. (It's odd though
that identical corruption would happen to different installations.)
regards, tom lane
В списке pgsql-general по дате отправления: