Re: Error in sample on doc page

2021-11-15 Thread Junk Mail
Disregard. This was an IDE issue. On 11/14/21 10:52 PM, PG Doc comments form wrote: The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-event-triggers.html Description: https://www.postgresql.org/docs/13/functions-event-trigger

Re: Query size limitation missing in documentation

2021-11-15 Thread Tom Lane
=?UTF-8?B?TWFydMOtbiBNYXJxdcOpcw==?= writes: > I was looking at https://www.postgresql.org/docs/current/limits.html > (was brought up by a customer) and found we are missing the limitation > of the string of the SQL to be executed (it's 1GB which is the longest > string postgres can hold) I kind

Query size limitation missing in documentation

2021-11-15 Thread Martín Marqués
Hello, I was looking at https://www.postgresql.org/docs/current/limits.html (was brought up by a customer) and found we are missing the limitation of the string of the SQL to be executed (it's 1GB which is the longest string postgres can hold) ``` /* It's possible we could use a different value f

Re: Error in sample on doc page

2021-11-15 Thread Laurenz Albe
On Mon, 2021-11-15 at 05:52 +, PG Doc comments form wrote: > Two issues here: > 1) The CREATE EVENT TRIGGER command in the sample code does not execute (see > output below) It works just fine for me. > 2) When executed in an anonymous do block, there is no error. The CREATE > EVENT TRIGGER e

Error in sample on doc page

2021-11-15 Thread PG Doc comments form
The following documentation comment has been logged on the website: Page: https://www.postgresql.org/docs/13/functions-event-triggers.html Description: https://www.postgresql.org/docs/13/functions-event-triggers.html Two issues here: 1) The CREATE EVENT TRIGGER command in the sample code does n

RE: Ltree pattern matching

2021-11-15 Thread Terry Gilbert
So, when it says "* prefix matching matches each word separately" it means foo_bar* will match a label with the first word beginning with foo and a second word beginning with bar? Hmmm I'll think about it, maybe I can suggest helpful wording. Thank you for clarifying! Terry -Original Messag