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
|
Список | 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 по дате отправления: