pg.ddx.io pgsql-bugs@postgresql.org mailing list archive
help / color / mirror / Atom feedBUG #17730: Trigger Issue
3+ messages / 3 participants
[nested] [flat]
* BUG #17730: Trigger Issue
@ 2022-12-23 17:09 PG Bug reporting form <noreply@postgresql.org>
2022-12-23 18:45 ` Re: BUG #17730: Trigger Issue Tom Lane <tgl@sss.pgh.pa.us>
2022-12-23 18:45 ` Re: BUG #17730: Trigger Issue David G. Johnston <david.g.johnston@gmail.com>
0 siblings, 2 replies; 3+ messages in thread
From: PG Bug reporting form @ 2022-12-23 17:09 UTC (permalink / raw)
To: pgsql-bugs@lists.postgresql.org; +Cc: nigel@oscsales.com
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 ?
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17730: Trigger Issue
2022-12-23 17:09 BUG #17730: Trigger Issue PG Bug reporting form <noreply@postgresql.org>
@ 2022-12-23 18:45 ` Tom Lane <tgl@sss.pgh.pa.us>
1 sibling, 0 replies; 3+ messages in thread
From: Tom Lane @ 2022-12-23 18:45 UTC (permalink / raw)
To: nigel@oscsales.com; +Cc: pgsql-bugs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 3+ messages in thread
* Re: BUG #17730: Trigger Issue
2022-12-23 17:09 BUG #17730: Trigger Issue PG Bug reporting form <noreply@postgresql.org>
@ 2022-12-23 18:45 ` David G. Johnston <david.g.johnston@gmail.com>
1 sibling, 0 replies; 3+ messages in thread
From: David G. Johnston @ 2022-12-23 18:45 UTC (permalink / raw)
To: nigel@oscsales.com; pgsql-bugs@lists.postgresql.org
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.
^ permalink raw reply [nested|flat] 3+ messages in thread
end of thread, other threads:[~2022-12-23 18:45 UTC | newest]
Thread overview: 3+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2022-12-23 17:09 BUG #17730: Trigger Issue PG Bug reporting form <noreply@postgresql.org>
2022-12-23 18:45 ` Tom Lane <tgl@sss.pgh.pa.us>
2022-12-23 18:45 ` David G. Johnston <david.g.johnston@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox