PG Bug reporting form <noreply@postgresql.org> writes:
> I have cloned a trigger from another table by inserting new rows into the
> pg_catalog.pg_triggers but the trigger is not working and the following
> querry -
> select pg_get_triggerdef(t.oid)
> from pg_catalog.pg_trigger t
> returns the error
> cache lookup failed for attribute 7 of relation 1682781.
It's highly unlikely that this is a Postgres bug.
It sounds more like you fat-fingered your manual catalog changes.
(Why didn't you use CREATE TRIGGER instead? Manual mucking
about in the catalogs is not for the inexpert.)
> Is there something else I need to change ?
[ shrug... ] When you have not shown us exactly what you did,
that's an unanswerable question.
regards, tom lane
