From: finzelj@gmail.com
To: pgsql-docs@postgresql.org
Subject: pg_logical_slot_get_changes needs clarification
Date: Mon, 05 Dec 2016 18:14:30 +0000
Message-ID: <20161205181430.4377.21615@wrigleys.postgresql.org> (raw)
List-Unsubscribe: <mailto:majordomo@postgresql.org?body=unsub%20pgsql-docs>
The following documentation comment has been logged on the website:
Page: https://www.postgresql.org/docs/9.4/static/functions-admin.html
Description:
It is not obvious from reading the description for function
pg_logical_slot_get_changes that it is a "destructive" function, and this
bit me. I was not clearly aware that this function consumes the replication
stream such that it's no longer available if I use it to look at the logical
stream, i.e., I MUST use the peek function for that purpose.
This is more clear in the full examples of logical decoding. Also, it says
in the "peek" function that
the peek function does not consume changes like the get function - but that
should be stated clearly in the get function description.
The name of the function itself is part of the problem: "get" does not
normally indicate "destroy" as well....
Thanks!
BecauseThere should b
--
Sent via pgsql-docs mailing list (pgsql-docs@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-docs
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-docs@postgresql.org
Cc: finzelj@gmail.com
Subject: Re: pg_logical_slot_get_changes needs clarification
In-Reply-To: <20161205181430.4377.21615@wrigleys.postgresql.org>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
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