Re: ERROR: failed to find conversion function from key_vals_nn to record[]

2022-06-15 Thread David G. Johnston
On Wed, Jun 15, 2022 at 11:07 PM Bryn Llewellyn wrote: > This is what the doc promises. But how can you see it as anything but a > bug? The subquery evaluates to "null", and only then is the attempt made to > create a new row which self-evidently violates the domain's constraint. How > is it any

Re: ERROR: failed to find conversion function from key_vals_nn to record[]

2022-06-15 Thread Bryn Llewellyn
> david.g.johns...@gmail.com wrote: > >> b...@yugabyte.com wrote: >> >> I’ve copied a self-contained testcase below. Is the error that the "as >> intended" test causes due to a known limitation—or even a semantic dilemma >> that I'm failing to spot? Or might it be due to a bug? > > I read the

Re: ERROR: failed to find conversion function from key_vals_nn to record[]

2022-06-15 Thread David G. Johnston
On Wednesday, June 15, 2022, Bryn Llewellyn wrote: > I’ve copied a self-contained testcase below. Is the error that the "as > intended" test causes due to a known limitation—or even a semantic dilemma > that I'm failing to spot? Or might it be due to a bug? > I read the note in create domain as

ERROR: failed to find conversion function from key_vals_nn to record[]

2022-06-15 Thread Bryn Llewellyn
I’ve copied a self-contained testcase below. Is the error that the "as intended" test causes due to a known limitation—or even a semantic dilemma that I'm failing to spot? Or might it be due to a bug? If you're interested, the testcase rests on this thinking: Many SQL experts claim that the RDB

Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Imre Samu
> According to the apt list for PostgreSQL there is nothing for the s390 system for version 13 and 14. Multiple postgres docker images exist for "OS/ARCH=linux/s390x" - "postgres:14.3-bullseye"( debian ) - "postgres:15beta1-bullseye" ( debian ) - "postgres:15beta1-alpine3.16" ( alpine ) -

Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Adrian Klaver
On 6/15/22 03:58, Ian Dauncey wrote: According to the apt list for PostgreSQL there is nothing for the s390 system for version 13 and 14. But for version 12 there is # sudo apt list postgresql-12 -a Listing... Done postgresql-12/focal-updates,focal-security,now 12.11-0ubuntu0.20.04.1 s39

Re: Recent 11.16 release change

2022-06-15 Thread Daniel Brinzila
Tom, Thanks very much for the clarification, i was just going over the regression tests and now makes sense. However, is this the only function (row_to_json) or are there more of them affected by this change? Regards, Daniel On Tue, Jun 14, 2022 at 5:23 PM Tom Lane < tgl_at_sss_pgh_pa_us_5s59

Re: Automatic autovacuum to prevent wraparound - PG13.5

2022-06-15 Thread Laurenz Albe
On Wed, 2022-06-15 at 12:13 +0100, Mauro Farracha wrote: > Have recently upgraded from PG10 to PG13.5 and would like to understand the > reason why we > are seeing triggered autovacuum to prevent the wraparound while all the  > metrics are still > far off from the multixact/freeze max ages defined

Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Tom Lane
Ian Dauncey writes: > Currently we are running PostgreSQL 12.2 on Ubuntu 20.04.1 LTS (Kernel: Linux > 5.4.0-42-generic - Architecture: s390x). > We are looking at upgrading to a later version of PostgreSQL > My question is :- What is the latest available version of PostgreSQL that > will run on

Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Ray O'Donnell
On 15/06/2022 11:58, Ian Dauncey wrote: According to the apt list for PostgreSQL there is nothing for the s390 system for version 13 and 14. That is more than likely your answer, so I'm not knowledgable on these things, but perhaps the packagers will be able to say more. I'd be guided by

Automatic autovacuum to prevent wraparound - PG13.5

2022-06-15 Thread Mauro Farracha
Hello guys, Have recently upgraded from PG10 to PG13.5 and would like to understand the reason why we are seeing triggered autovacuum to prevent the wraparound while all the metrics are still far off from the multixact/freeze max ages defined. And inclusive there was one time where it was triggere

RE: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Ian Dauncey
According to the apt list for PostgreSQL there is nothing for the s390 system for version 13 and 14. # sudo apt list postgresql-14 -a Listing... Done # sudo apt list postgresql-13 -a Listing... Done But for version 12 there is # sudo apt list postgresql-12 -a Listing... Done postgresql-12/foca

Re: PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Ray O'Donnell
On 15 June 2022 08:31:42 Ian Dauncey wrote: Morning all Currently we are running PostgreSQL 12.2 on Ubuntu 20.04.1 LTS (Kernel: Linux 5.4.0-42-generic - Architecture: s390x). We are looking at upgrading to a later version of PostgreSQL My question is :- What is the latest available ve

PostgreSQL 12.2 on Linux ubuntu 20.4 / s390

2022-06-15 Thread Ian Dauncey
Morning all Currently we are running PostgreSQL 12.2 on Ubuntu 20.04.1 LTS (Kernel: Linux 5.4.0-42-generic - Architecture: s390x). We are looking at upgrading to a later version of PostgreSQL My question is :- What is the latest available version of PostgreSQL that will run on the above Archit