Re: BUG #16139: Assertion fails on INSERT into a postgres_fdw' tablewith two AFTER INSERT triggers

Поиск
Список
Период
Сортировка
От Etsuro Fujita
Тема Re: BUG #16139: Assertion fails on INSERT into a postgres_fdw' tablewith two AFTER INSERT triggers
Дата
Msg-id CAPmGK15ceMM69qh3==qh6-sZzwxPnBsJdNUqUR82PGbUUEjctg@mail.gmail.com
обсуждение исходный текст
Ответ на BUG #16139: Assertion fails on INSERT into a postgres_fdw' table with two AFTER INSERT triggers  (PG Bug reporting form <noreply@postgresql.org>)
Ответы Re: BUG #16139: Assertion fails on INSERT into a postgres_fdw' tablewith two AFTER INSERT triggers  (Etsuro Fujita <etsuro.fujita@gmail.com>)
Список pgsql-bugs
On Wed, Nov 27, 2019 at 4:21 PM PG Bug reporting form
<noreply@postgresql.org> wrote:
> The following script:
> CREATE EXTENSION postgres_fdw;
> CREATE SERVER loopback FOREIGN DATA WRAPPER postgres_fdw OPTIONS (dbname
> 'postgres');
> CREATE USER MAPPING FOR CURRENT_USER SERVER loopback;
> CREATE TABLE loc2 (f1 int);
> CREATE FOREIGN TABLE rem2 (f1 int) SERVER loopback OPTIONS(table_name
> 'loc2');
> CREATE OR REPLACE FUNCTION trigger_data() RETURNS trigger
> LANGUAGE plpgsql AS 'begin return NEW; end;';
>
> CREATE TRIGGER trigger1 AFTER INSERT ON rem2 FOR EACH ROW EXECUTE PROCEDURE
> trigger_data();
> CREATE TRIGGER trigger2 AFTER INSERT ON rem2 FOR EACH ROW EXECUTE PROCEDURE
> trigger_data();
> INSERT INTO rem2 VALUES(1);
>
> raises the assertion:

Reproduced.  Will look into this.

Best regards,
Etsuro Fujita



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

Предыдущее
От: PG Bug reporting form
Дата:
Сообщение: BUG #16139: Assertion fails on INSERT into a postgres_fdw' table with two AFTER INSERT triggers
Следующее
От: Dean Rasheed
Дата:
Сообщение: Re: Failed assertion clauses != NIL