Re: Limitation relates to memory allocation

2024-10-16 Thread Peter Eisentraut
On 14.10.24 08:03, Ekaterina Kiryanova wrote: We encountered an issue related to internal memory allocation limit: ERROR: invalid memory alloc request size In the documentation on limits: https://www.postgresql.org/docs/17/ limits.html the description suggests that only a single field is limite

Re: missing command?

2024-10-16 Thread Daniel Gustafsson
> On 15 Oct 2024, at 00:57, PG Doc comments form wrote: > In this list of commands: > https://www.postgresql.org/docs/current/reference-client.html > Should this one be included? --> pg_ctl pg_ctl is a server application, it is included here: https://www.postgresql.org/docs/devel/reference-se

missing command?

2024-10-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/reference-client.html Description: Hi, In this list of commands: https://www.postgresql.org/docs/current/reference-client.html Should this one be included? --> pg_ctl Saludos. Jose

CLUSTER command

2024-10-16 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/17/sql-cluster.html Description: The documentation does not say what happens if you do "CLUSTER tablename" and omit the USING clause, which is shown as optional in the BNF, if I'm reading it

Re: CLUSTER command

2024-10-16 Thread Alvaro Herrera
Hello, On 2024-Oct-15, PG Doc comments form wrote: > The documentation does not say what happens if you do "CLUSTER tablename" > and omit the USING clause, which is shown as optional in the BNF, if I'm > reading it right. Does CLUSTER use the PRIMARY KEY in that case? What if > no PRIMARY KEY i

Re: CLUSTER command

2024-10-16 Thread Richard Hipp
That makes perfect sense, now that you have explained it. I just didn't pick up on that from the text as written. -- D. Richard Hipp d...@sqlite.org On Wednesday, October 16th, 2024 at 9:22 AM, Alvaro Herrera wrote: > Hello, > > On 2024-Oct-15, PG Doc comments form wrote: > > > The docume

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-10-16 Thread David Rowley
On Thu, 17 Oct 2024 at 11:19, Bruce Momjian wrote: > Where are we on this? I still see "#". I was hoping for some voting for or against my patch or the general idea of it. Also, my web skills in this area amount to trial and error, so it would also be good to have someone who knows what they're

Re: Limitation relates to memory allocation

2024-10-16 Thread David Rowley
On Mon, 14 Oct 2024 at 19:03, Ekaterina Kiryanova wrote: > Our research showed that the limit is imposed by the palloc() function, > regardless of whether it is a tuple or not, and if the data is > serialized or dumped, the effective limit can be even lower, typically > around 512MB per row. So fo

Re: Connection Info

2024-10-16 Thread Bruce Momjian
On Mon, May 6, 2024 at 04:15:24PM +0200, Laurenz Albe wrote: > On Sun, 2024-05-05 at 20:25 +, PG Doc comments form wrote: > > On this page: > > https://www.postgresql.org/docs/14/server-start.html#CLIENT-CONNECTION-PROBLEMS > > > > It notes: " A common mistake is to forget to configure th

Re: Documentation of .pgpass for Unix is incomplete

2024-10-16 Thread Bruce Momjian
On Mon, Aug 19, 2024 at 05:42:33PM -0700, David G. Johnston wrote: > On Mon, Aug 19, 2024 at 5:06 PM Bruce Momjian wrote: > Well, it is more complicated than checking just HOME because it calls > getpwuid_r() if HOME is not set: > >         https://doxygen.postgresql.org/fe-connect_8c

Re: Undocumented optionality of handler_statements

2024-10-16 Thread Bruce Momjian
On Wed, Sep 11, 2024 at 03:37:17PM +0900, Michael Paquier wrote: > On Tue, Jul 23, 2024 at 01:25:39PM +0200, Philipp Salvisberg wrote: > > read "optional" as "mandatory". > > They're optional, like in empty being optional. If not specified, the > block goes to its END. > > > Therefore, I suggest

Re: A minor bug in doc. Hovering over heading shows # besides it.

2024-10-16 Thread Bruce Momjian
Where are we on this? I still see "#". --- On Mon, Aug 12, 2024 at 02:19:06PM +1200, David Rowley wrote: > On Fri, 19 Jul 2024 at 06:03, Jonathan S. Katz wrote: > > > > On 7/18/24 1:59 PM, Daniel Gustafsson wrote: > > > L

A minor bug in doc. Hovering over heading shows # besides it.

2024-10-16 Thread David G. Johnston
On Wednesday, October 16, 2024, Bruce Momjian wrote: > > Where are we on this? I still see "#". > > We should document what we are doing in Conventions. The hover stuff is a nice usability add, if a bit limited on mobile. My +1 as well to matching Python with the pilcrow symbol. David J.

Re: incorrect (incomplete) description for "alter domain"

2024-10-16 Thread Bruce Momjian
On Mon, Jul 29, 2024 at 11:17:41AM -0400, Tom Lane wrote: > I wrote: > > I think the page is technically correct, but I'm inclined to duplicate > > this text from the CREATE DOMAIN page: > > > where domain_constraint is: > > [ CONSTRAINT constraint_name ] > > { NOT NULL | NULL | CHECK

Re: Undocumented optionality of handler_statements

2024-10-16 Thread David G. Johnston
On Wednesday, October 16, 2024, Bruce Momjian wrote: > On Wed, Sep 11, 2024 at 03:37:17PM +0900, Michael Paquier wrote: > > On Tue, Jul 23, 2024 at 01:25:39PM +0200, Philipp Salvisberg wrote: > > > read "optional" as "mandatory". > > > > They're optional, like in empty being optional. If not spe

Re: Logical replication - initial data synchronization

2024-10-16 Thread Bruce Momjian
On Sat, May 18, 2024 at 09:02:11PM +, PG Doc comments form wrote: > The following documentation comment has been logged on the website: > > Page: https://www.postgresql.org/docs/16/logical-replication-subscription.html > Description: > > I'm reading up on Logical Replication and have been rea