Postgres Pro
Downloads
Home   >   mailing lists

Re: Possible Example Error in Documentation - Mailing list pgsql-docs

From John Burgoon
Subject Re: Possible Example Error in Documentation
Date
Msg-id CADGUs4ytORQsnGPL+HYhREa2-dFYUg5dMM0ZqAHte=Z+B+YCgQ@mail.gmail.com
Whole thread Raw
In response to Re: Possible Example Error in Documentation  ("Jonathan S. Katz" <jkatz@postgresql.org>)
List pgsql-docs
Tree view
Thanks, everyone.

This morning when I opened the file and ran it, everything worked fine.  Beats me what was happening, but the overnight reboot took care of it.

I should know by now to try turning it off and back on again...  ;)

Thanks so much.

On Fri, Nov 6, 2020 at 8:51 AM Jonathan S. Katz <jkatz@postgresql.org> wrote:
On 11/5/20 7:37 PM, Tom Lane wrote:
> PG Doc comments form <noreply@postgresql.org> writes:
>> The following documentation comment has been logged on the website:
>> Page: https://www.postgresql.org/docs/12/plpgsql-transactions.html
>> Description:
>
>> We are using Postgres 12. When I use the example given for
>> transaction_test1() from the documentation here:
>> https://www.postgresql.org/account/comments/new/12/plpgsql-transactions.html/,
>> the procedure is created without incident.  However, when I attempt "CALL
>> transaction_test1();", I receive the "invalid transaction termination"
>> error.
>
> Hmm, it works for me.

Ditto.

I did get that error message if I put a "BEGIN;" statement before
executing the CALL statement.

Jonathan


--
By morning, there was no evidence of what had happened between us, or not happened. How everything depends.
The sound of bees beginning to stir a last time all over again in the walls of a house left wintering. -- Carl Philips


pgsql-docs by date:

Previous
From: "Jonathan S. Katz"
Date:
Subject: Re: Possible Example Error in Documentation
Next
From: PG Doc comments form
Date:
Subject: Make it clear that the default values are already set/available when triggers are being evaluated