Bug reference: 17730 Logged by: n d Email address: nigel@oscsales.com PostgreSQL version: Unsupported/Unknown Operating system: Windows Description:
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. Is there something else I need to change ?
This is not a valid bug report - if you decide to forgo using CREATE TRIGGER to create a valid trigger in your database the problems that you cause are not bugs and you probably shouldn't expect others to take an interest in unbreaking your system. In any case you should seek any desired assistance on the -general mailing list. Or, better yet, undo what you did and go and do things correctly instead and hope that is sufficient.