Re: BUG #17730: Trigger Issue

Поиск
Список
Период
Сортировка
От David G. Johnston
Тема Re: BUG #17730: Trigger Issue
Дата
Msg-id CAKFQuwYWOavq2sVdcdYXafyWYTrH4t_NafryJjsEb6=46K7ZWw@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #17730: Trigger Issue  (PG Bug reporting form <noreply@postgresql.org>)
Список pgsql-bugs
Дерево обсуждения
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.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #17730: Trigger Issue
Следующее
От: PG Bug reporting form
Дата:
Сообщение: BUG #17731: Server doesn't start after abnormal shutdown while creating unlogged tables