From: | Junk Mail <sean6907(at)nowisit(dot)net> |
---|---|
To: | postgresql(at)nowisit(dot)net, pgsql-docs(at)lists(dot)postgresql(dot)org |
Subject: | Re: Error in sample on doc page |
Date: | 2021-11-15 10:27:18 |
Message-ID: | 9c82e84e-6ae4-1f11-db47-41a7d7a04212@nowisit.net |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-docs |
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
From | Date | Subject | |
---|---|---|---|
Next Message | Laurenz Albe | 2021-11-15 15:25:33 | Re: Error in sample on doc page |
Previous Message | PG Doc comments form | 2021-11-15 05:52:21 | Error in sample on doc page |