Thread: BUG #17730: Trigger Issue

BUG #17730: Trigger Issue

From
PG Bug reporting form
Date:
The following bug has been logged on the website:

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 ?


Re: BUG #17730: Trigger Issue

From
Tom Lane
Date:
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



Re: BUG #17730: Trigger Issue

From
"David G. Johnston"
Date:
On Fri, Dec 23, 2022 at 10:13 AM PG Bug reporting form <noreply@postgresql.org> wrote:
The following bug has been logged on the website:

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.

David J.