postgres catalog files problem

From: "Josh Harrison" <joshques(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: postgres catalog files problem
Date: 2007-09-17 12:35:48
Message-ID: 8d89ea1d0709170535r74dd37b4r1a00e9b7e2e97101@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi,
I noticed that I have too many records in my pg_ catalog files with the same
name. For example
if I give this query, which checks for the triggers that do not have
corresponding tables in the pg_class

select * from pg_trigger where tgrelid not in (select relfilenode from
pg_class),

I get set of records like this (omitted some fields)

tgrelid tgname tgfoid
tgtype tgconstrname
629324 RI_ConstraintTrigger_654082 1644 5
payment_fk_id ...

629324 RI_ConstraintTrigger_654083 1645 17
payment_fk_id ...
........

That is there are records in my pg_trigger that has no corresponding tgrelid
in pg_class. Why is that? Is it okay to manually delete these records from
the catalog files?

So Im getting this errorthis error when I try to update some tables
' could not open relation with oid'

Thanks for your help
josh

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Tom Lane 2007-09-17 13:39:05 Re: postgres catalog files problem
Previous Message Albe Laurenz 2007-09-17 07:01:50 Re: count (*)