Re: BUG #17730: Trigger Issue

On Fri, Dec 23, 2022 at 10:13 AM PG Bug reporting form <
noreply(at)postgresql(dot)org> wrote:

> The following bug has been logged on the website:
>
> Bug reference: 17730
> Logged by: n d
> Email address: nigel(at)oscsales(dot)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.

David J.