Re: "too many trigger records found for relation xyz"
| От | Mikko Partio |
|---|---|
| Тема | Re: "too many trigger records found for relation xyz" |
| Дата | |
| Msg-id | 2ca799770804080405l10083a7dpd34d3a96f8e6657f@mail.gmail.com обсуждение исходный текст |
| Ответ на | Re: "too many trigger records found for relation xyz" (Zdenek Kotala <Zdenek.Kotala@Sun.COM>) |
| Ответы |
Re: "too many trigger records found for relation xyz"
|
| Список | pgsql-general |
On Tue, Apr 8, 2008 at 1:45 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote:
# select oid, ctid, xmin, xmax, cmin, cmax, relname from pg_class where oid = 294397;
oid | ctid | xmin | xmax | cmin | cmax | relname
--------+-----------+------------+------------+------+------+--------------
294397 | (1125,36) | 3944654557 | 0 | 35 | 35 | abc
294397 | (1124,55) | 3943984380 | 3943984642 | 3 | 3 | abc
(2 rows)
Which one should I remove? What is the worst case scenario for the delete? The database is 1,5TB so I would rather not restore it from backups :-)
Regards
Mikko
Mikko Partio napsal(a):Try it with caution. You should use ctid column to refer to exact row.Should I try remove one of the duplicate rows from pg_class?
Try before:
select oid, ctid, xmin, xmax, cmin, cmax, relname from pg_class where oid = 294397;
If both row are identical or not.
# select oid, ctid, xmin, xmax, cmin, cmax, relname from pg_class where oid = 294397;
oid | ctid | xmin | xmax | cmin | cmax | relname
--------+-----------+------------+------------+------+------+--------------
294397 | (1125,36) | 3944654557 | 0 | 35 | 35 | abc
294397 | (1124,55) | 3943984380 | 3943984642 | 3 | 3 | abc
(2 rows)
Which one should I remove? What is the worst case scenario for the delete? The database is 1,5TB so I would rather not restore it from backups :-)
Regards
Mikko
В списке pgsql-general по дате отправления: