Message-ID: <053cb818710e43efa2e2098793014e5271dfdb55.camel@cybertec.at>
Subject: Re: Error in sample on doc page
From: Laurenz Albe <laurenz.albe@cybertec.at>
To: postgresql@nowisit.net, pgsql-docs@lists.postgresql.org
Date: Mon, 15 Nov 2021 16:25:33 +0100
In-Reply-To: <163695554137.11069.14314706306790865461@wrigleys.postgresql.org>
References: 
	<163695554137.11069.14314706306790865461@wrigleys.postgresql.org>
Content-Type: text/plain; charset="UTF-8"
User-Agent: Evolution 3.40.4 (3.40.4-2.fc34) 
MIME-Version: 1.0
Content-Transfer-Encoding: 8bit
Archived-At: 
 <https://www.postgresql.org/message-id/053cb818710e43efa2e2098793014e5271dfdb55.camel%40cybertec.at>
Precedence: bulk

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