Message-ID: <9c82e84e-6ae4-1f11-db47-41a7d7a04212@nowisit.net>
Date: Mon, 15 Nov 2021 03:27:18 -0700
MIME-Version: 1.0
User-Agent: Mozilla/5.0 (Macintosh; Intel Mac OS X 10.15; rv:91.0)
 Gecko/20100101 Thunderbird/91.3.0
Subject: Re: Error in sample on doc page
Content-Language: en-US
To: postgresql@nowisit.net, pgsql-docs@lists.postgresql.org
References: <163695554137.11069.14314706306790865461@wrigleys.postgresql.org>
From: Junk Mail <sean6907@nowisit.net>
In-Reply-To: <163695554137.11069.14314706306790865461@wrigleys.postgresql.org>
Content-Type: text/plain; charset=UTF-8; format=flowed
Content-Transfer-Encoding: 7bit
Archived-At: 
 <https://www.postgresql.org/message-id/9c82e84e-6ae4-1f11-db47-41a7d7a04212%40nowisit.net>
Precedence: bulk

Disregard. This was an IDE issue.

On 11/14/21 10:52 PM, PG Doc comments form wrote:
> The following documentation comment has been logged on the website:
>
> Page: https://www.postgresql.org/docs/13/functions-event-triggers.html
> Description:
>
> https://www.postgresql.org/docs/13/functions-event-triggers.html
>
> Two issues here:
> 1) The CREATE EVENT TRIGGER command in the sample code does not execute (see
> output below)
> 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