Alvaro, thanks for your response. My comments below... > From: Alvaro Herrera [mailto:alvhe...@commandprompt.com] > Sent: Wednesday, August 04, 2010 11:30 PM > There probably is. What kind of relation are the ones unable to truncate? > Please see in pg_class where relfilenode = '41274' in this > case: > [HiteshB] the relation is called pmoinstance_idx_pmotypeid. This is an index on a table created by our product. The definition for this index is: CREATE INDEX pmoinstance_idx_pmotypeid ON pmoinstances USING btree (pmotype_id);
Regards, Hitesh -- Sent via pgsql-bugs mailing list (pgsql-bugs@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-bugs
