Re: pass open cursor via USING in execute staement

2023-06-06 Thread Kirk Wolak
On Thu, Jun 1, 2023 at 9:32 AM PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/15/plpgsql-statements.html > Description: > > Should be documented if this statement is allowed or not (if not, maybe set > as

Re: bpchar datatype is not equal to character(1) data type

2023-06-06 Thread David G. Johnston
On Tue, Jun 6, 2023 at 7:31 AM yanliang lei wrote: > > Based on the above description, there is a deduction as follows: > bpchar datatype is equal to character(1) data type > Nope, bpchar is not equal to any user-facing data type by virtue of it being an internal implementation-only data type.

Re: bpchar datatype is not equal to character(1) data type

2023-06-06 Thread Laurenz Albe
On Tue, 2023-06-06 at 22:30 +0800, yanliang lei wrote: > in the documents > (https://www.postgresql.org/docs/current/typeconv-query.html),there is the > following descrition: > “blank-padded char”, the internal name of the character data type. > ===>>so bpchar datatype is equal to character data

bpchar datatype is not equal to character(1) data type

2023-06-06 Thread yanliang lei
in the documents (https://www.postgresql.org/docs/current/typeconv-query.html),there is the following descrition: “blank-padded char”, the internal name of the character data type. ===>>so bpchar datatype is equal to character data type in the documents (https://www.postgresql.org/docs/

clarifying trigger/rule behavior on logical replication subscribers

2023-06-06 Thread Jonathan S. Katz
Hi, While answering a question on "do triggers fire on a logical replication subscriber by default?" I tried to look up a reference to this behavior in the docs. There wasn't a clear reference point, but on the architecture page[1], I found this line that was closest to the answer: "The appl

pg_class.relpages documentation does not mention relpages corner case

2023-06-06 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/14/catalog-pg-class.html Description: In the pg_class documentation [1], the relpages column is described as >Size of the on-disk representation of this table in pages (of size BLCKSZ). This

Re: confusing positioning of notes in connection settings

2023-06-06 Thread Daniel Gustafsson
> On 5 Jun 2023, at 19:10, Jonathan S. Katz wrote: > "It is only supported on systems where TCP_USER_TIMEOUT is available; on > other systems, it has no effect." > > If this is really only unsupported / has different settings on Windows, I > think it's OK to call that out. The original gripe w