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

["Mikko Partio" <mpartio@xxxxxxxxx>]

On Tue, Apr 8, 2008 at 1:19 PM, Zdenek Kotala <Zdenek.Kotala@xxxxxxx> 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