On Tue, Apr 8, 2008 at 1:19 PM, Zdenek Kotala <[EMAIL PROTECTED]> 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
