Re: Race condition in TransactionIdIsInProgress

2022-06-26 Thread Heikki Linnakangas
On 25/06/2022 13:10, Simon Riggs wrote: On Sat, 25 Jun 2022 at 10:18, Heikki Linnakangas wrote: On 24/06/2022 04:43, Andres Freund wrote: On 2022-06-23 22:03:27 +0300, Heikki Linnakangas wrote: In summary, I think we should: - commit and backpatch Simon's

RE: PG15 beta1 fix pg_stats_ext/pg_stats_ext_exprs view manual

2022-06-26 Thread Shinoda, Noriyoshi (PN Japan FSIP)
Thanks for your comment. sorry for the late reply. I hope it will be fixed during the period of PostgreSQL 15 Beta. Regards, Noriyoshi Shinoda -Original Message- From: Justin Pryzby Sent: Tuesday, June 14, 2022 11:30 PM To: Shinoda, Noriyoshi (PN Japan FSIP) Cc:

Re: Postgres do not allow to create many tables with more than 63-symbols prefix

2022-06-26 Thread Andrey Lepikhov
On 6/27/22 06:38, Masahiko Sawada wrote: On Fri, Jun 24, 2022 at 2:12 PM Andrey Lepikhov wrote: On 6/23/22 07:03, Masahiko Sawada wrote: > On Sat, Jun 4, 2022 at 4:03 AM Andrey Lepikhov > wrote: >> It is very corner case, of course. But solution is easy and short. So, >> why not to

Re: Postgres do not allow to create many tables with more than 63-symbols prefix

2022-06-26 Thread Masahiko Sawada
On Fri, Jun 24, 2022 at 2:12 PM Andrey Lepikhov wrote: > > Moved from the pgsql-bugs mailing list [1]. > > On 6/23/22 07:03, Masahiko Sawada wrote: > > Hi, > > > > On Sat, Jun 4, 2022 at 4:03 AM Andrey Lepikhov > > wrote: > >> > >> According to subj you can try to create many tables

Re: pg15b1: FailedAssertion("val > base", File: "...src/include/utils/relptr.h", Line: 67, PID: 30485)

2022-06-26 Thread Thomas Munro
On Thu, Jun 23, 2022 at 2:09 AM Robert Haas wrote: > On Wed, Jun 22, 2022 at 12:34 AM Thomas Munro wrote: > > > For the record, the third idea proposed was to use 1 for the first > > > byte, so that 0 is reserved for NULL and works with memset(0). Here's > > > an attempt at that. > > > > ...

Re: Support logical replication of DDLs

2022-06-26 Thread Alvaro Herrera
On 2022-Jun-22, vignesh C wrote: > 1) Creation of temporary table fails infinitely in the subscriber. > CREATE TEMPORARY TABLE temp1 (a int primary key); > > The above statement is converted to the below format: > CREATE TEMPORARY TABLE pg_temp.temp1 (a pg_catalog.int4 , > CONSTRAINT

Re: doc: Clarify Savepoint Behavior

2022-06-26 Thread David G. Johnston
Thank you for the review. On Thu, Jun 23, 2022 at 5:35 AM Simon Riggs wrote: > On Thu, 9 Jun 2022 at 16:41, David G. Johnston > wrote: > > "The name to give to the new savepoint. The name may already exist, > + in which case a rollback or release to the same name will use the > +

Re: Add LZ4 compression in pg_dump

2022-06-26 Thread Justin Pryzby
Hi, Will you be able to send a rebased patch for the next CF ? If you update for the review comments I sent in March, I'll plan to do another round of review. On Sat, Mar 26, 2022 at 11:21:56AM -0500, Justin Pryzby wrote: > LZ4F_HEADER_SIZE_MAX isn't defined in old LZ4. > > I ran into that on

JSON/SQL: jsonpath: incomprehensible error message

2022-06-26 Thread Erik Rijkers
JSON/SQL jsonpath For example, a jsonpath string with deliberate typo 'like_regexp' (instead of 'like_regex'): select js from (values (jsonb '{}')) as f(js) where js @? '$ ? (@ like_regexp "^xxx")'; ERROR: syntax error, unexpected IDENT_P at or near " " of jsonpath input LINE 1: ...s from

Re: Core dump in range_table_mutator()

2022-06-26 Thread Tom Lane
Dean Rasheed writes: > On Sat, 25 Jun 2022 at 04:39, Tom Lane wrote: >> Well, if we want to clean this up a bit rather than just doing the >> minimum safe fix ... I spent some time why we were bothering with the >> FLATCOPY step at all, rather than just mutating the Query* pointer. >> I think

Re: ICU for global collation

2022-06-26 Thread Michael Paquier
On Sun, Jun 26, 2022 at 11:51:24AM +0800, Julien Rouhaud wrote: > On Sat, Jun 25, 2022 at 10:19:30AM -0500, Justin Pryzby wrote: >>> + if (GET_MAJOR_VERSION(old_cluster.major_version) <= 1500) >>> + snprintf(query + strlen(query), sizeof(query) - strlen(query), >>> +