Re: "too many trigger records found for relation xyz" - Mailing list pgsql-general
| From | Mikko Partio |
|---|---|
| Subject | Re: "too many trigger records found for relation xyz" |
| Date | |
| Msg-id | 2ca799770804080337g2e196d36k470970a9118bdd49@mail.gmail.com Whole thread Raw |
| In response to | Re: "too many trigger records found for relation xyz" (Zdenek Kotala <Zdenek.Kotala@Sun.COM>) |
| Responses |
Re: "too many trigger records found for relation xyz"
(Zdenek Kotala <Zdenek.Kotala@Sun.COM>)
|
| List | pgsql-general |
On Tue, Apr 8, 2008 at 1:19 PM, Zdenek Kotala <Zdenek.Kotala@sun.com> wrote:
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
Mikko Partio napsal(a):Could you check if pg_attribute is doubled for this relation?
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)
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
pgsql-general by date: