Re: BUG #17730: Trigger Issue

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