pg.ddx.io pgsql-docs@postgresql.org mailing list archive
help / color / mirror / Atom feedPossible Example Error in Documentation
4+ messages / 4 participants
[nested] [flat]
* Possible Example Error in Documentation
@ 2020-11-05 19:45 PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: PG Doc comments form @ 2020-11-05 19:45 UTC (permalink / raw)
To: pgsql-docs@lists.postgresql.org; +Cc: noogrub@gmail.com
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.
Please correct the documentation if the example is flawed, or add an
explanation on the page if we need to set specific environment variables.
Thank you.
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Possible Example Error in Documentation
@ 2020-11-06 00:37 Tom Lane <tgl@sss.pgh.pa.us>
parent: PG Doc comments form <noreply@postgresql.org>
0 siblings, 1 reply; 4+ messages in thread
From: Tom Lane @ 2020-11-06 00:37 UTC (permalink / raw)
To: noogrub@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
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.
regards, tom lane
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Possible Example Error in Documentation
@ 2020-11-06 13:50 Jonathan S. Katz <jkatz@postgresql.org>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 1 reply; 4+ messages in thread
From: Jonathan S. Katz @ 2020-11-06 13:50 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; noogrub@gmail.com; +Cc: pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
* Re: Possible Example Error in Documentation
@ 2020-11-06 13:53 John Burgoon <noogrub@gmail.com>
parent: Jonathan S. Katz <jkatz@postgresql.org>
0 siblings, 0 replies; 4+ messages in thread
From: John Burgoon @ 2020-11-06 13:53 UTC (permalink / raw)
To: Jonathan S. Katz <jkatz@postgresql.org>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-docs@lists.postgresql.org
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
^ permalink raw reply [nested|flat] 4+ messages in thread
end of thread, other threads:[~2020-11-06 13:53 UTC | newest]
Thread overview: 4+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2020-11-05 19:45 Possible Example Error in Documentation PG Doc comments form <noreply@postgresql.org>
2020-11-06 00:37 ` Tom Lane <tgl@sss.pgh.pa.us>
2020-11-06 13:50 ` Jonathan S. Katz <jkatz@postgresql.org>
2020-11-06 13:53 ` John Burgoon <noogrub@gmail.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox