Re: "too many trigger records found for relation xyz"

On Tue, Apr 8, 2008 at 1:19 PM, Zdenek Kotala <Zdenek(dot)Kotala(at)sun(dot)com> wrote:

> Mikko Partio napsal(a):
>
> >
> >
> > I little investigation showed that there is duplicate row in pg_class:
> >
> > # select oid from pg_class group by oid having count(*) > 1 ;
> > oid
> > --------
> > 294397
> > (1 row)
> >
>
> Could you check if pg_attribute is doubled for this relation?

It looks like pg_attribute has only a single value:

# select * from pg_attribute where attrelid = 294397 ;
attrelid | attname | atttypid | attstattarget | attlen | attnum | attndims
| attcacheoff | atttypmod | attbyval | attstorage | attalign | attnotnull |
atthasdef | attisdropped | attislocal | attinhcount
----------+----------+----------+---------------+--------+--------+----------+-------------+-----------+----------+------------+----------+------------+-----------+--------------+------------+-------------
294397 | tableoid | 26 | 0 | 4 | -7 | 0
| -1 | -1 | t | p | i | t |
f | f | t | 0
294397 | cmax | 29 | 0 | 4 | -6 | 0
| -1 | -1 | t | p | i | t |
f | f | t | 0
294397 | xmax | 28 | 0 | 4 | -5 | 0
| -1 | -1 | t | p | i | t |
f | f | t | 0
294397 | cmin | 29 | 0 | 4 | -4 | 0
| -1 | -1 | t | p | i | t |
f | f | t | 0
294397 | xmin | 28 | 0 | 4 | -3 | 0
| -1 | -1 | t | p | i | t |
f | f | t | 0
294397 | ctid | 27 | 0 | 6 | -1 | 0
| -1 | -1 | f | p | s | t |
f | f | t | 0
294397 | id | 21 | -1 | 2 | 1 | 0
| -1 | -1 | t | p | s | t |
f | f | t | 0
294397 | name | 1043 | -1 | -1 | 2 | 0
| -1 | 16 | f | x | i | t |
f | f | t | 0
294397 | desc_fi | 25 | -1 | -1 | 3 | 0
| -1 | -1 | f | x | i | t |
f | f | t | 0
294397 | desc_en | 25 | -1 | -1 | 4 | 0
| -1 | -1 | f | x | i | t |
f | f | t | 0
(10 rows)

Should I try remove one of the duplicate rows from pg_class?

Regards

Mikko