On Mon, 2021-11-15 at 05:52 +0000, PG Doc comments form wrote: > Two issues here: > 1) The CREATE EVENT TRIGGER command in the sample code does not execute (see > output below)
It works just fine for me. > 2) When executed in an anonymous do block, there is no error. The CREATE > EVENT TRIGGER executed outside the do block should have given an error > saying already exists. Instead it gives the error: "ERROR: syntax error at > end of input". > > ae_lake.cdc> do $docbug$ > BEGIN > RAISE INFO 'Executing sample from PG docs: > https://www.postgresql.org/docs/13/functions-event-triggers.html...'; > > CREATE FUNCTION test_event_trigger_table_rewrite_oid() > RETURNS event_trigger > LANGUAGE plpgsql AS > $$ > BEGIN > RAISE NOTICE 'rewriting table % for reason %', > > pg_event_trigger_table_rewrite_oid()::regclass, > pg_event_trigger_table_rewrite_reason(); > END; > $$; > > CREATE EVENT TRIGGER test_table_rewrite_oid > ON table_rewrite > EXECUTE FUNCTION test_event_trigger_table_rewrite_oid(); > > END; > $docbug$ > [2021-11-14 22:47:49] [00000] Executing sample from PG docs: > https://www.postgresql.org/docs/13/functions-event-triggers.html... > [2021-11-14 22:47:49] completed in 109 ms > ae_lake.cdc> CREATE EVENT TRIGGER test_table_rewrite_oid > ON table_rewrite > [2021-11-14 22:48:09] [42601] ERROR: syntax error at end of input > [2021-11-14 22:48:09] Position: 79 I don't get that error. Perhaps you inadvertently were on a continuation line in psql. Yours, Laurenz Albe
