Re: Is the PL/pgSQL refcursor useful in a modern three-tier app?

2023-03-23 Thread Bryn Llewellyn
> laurenz.a...@cybertec.at wrote: > >> b...@yugabyte.com wrote: >> >>> laurenz.a...@cybertec.at wrote: >>> >>> I recently used cursor scrollability, so I can show you a use case: >>> >>> github.com/cybertec-postgresql/db_migrator/blob/master/db_migrator--1.0.0.sql#L49 >> >> However, source cod

Re: Logical replication fails when adding multiple replicas

2023-03-23 Thread Will Roper
OK, that makes sense. I think something that is unique to subscribers is sensible, postmaster startup time sounds reasonable! Thanks for looking at it. On Thu, Mar 23, 2023 at 8:17 AM Kyotaro Horiguchi wrote: > At Wed, 22 Mar 2023 09:25:37 +, Will Roper < > will.ro...@democracyclub.org.uk> w

Re: How to install vacuumlo on a client?

2023-03-23 Thread Adrian Klaver
On 3/23/23 09:54, Zwettler Markus (OIZ) wrote: I want to install vacuumlo on a client. I would install client + contrib + libs package: yum install postgresql15 postgresql15-contrib postgresql15-libs Is this enough or are there some other rpm / libs needed? That should cover it. To test at

How to install vacuumlo on a client?

2023-03-23 Thread Zwettler Markus (OIZ)
I want to install vacuumlo on a client. I would install client + contrib + libs package: yum install postgresql15 postgresql15-contrib postgresql15-libs Is this enough or are there some other rpm / libs needed?

Re: Convert pg_constraint.conkey array to same-order array of column names

2023-03-23 Thread Adrian Klaver
On 3/23/23 04:12, Dominique Devienne wrote: We have a query returning 1 row per constraint column, which until recently we didn't realize wasn't preserving order of the columns. A colleague fixed that, with something like below: SELECT ... FROM pg_catalog.pg_constraint cnstr ... CROSS JOIN LA

Re: Postgresql professional certification

2023-03-23 Thread Magnus Hagander
On Thu, Mar 23, 2023 at 1:46 PM MS A wrote: > Hi Team, > > My name is Sabjar Ali working for one of the MNC companies, I am planning > to do Postgresql professional certification. Regarding the same i don't > find any link in postgresql.org site. > > Please help me how i can approach to do my Pos

Postgresql professional certification

2023-03-23 Thread MS A
Hi Team, My name is Sabjar Ali working for one of the MNC companies, I am planning to do Postgresql professional certification. Regarding the same i don't find any link in postgresql.org site. Please help me how i can approach to do my Postgresql professional certification. Thanks Sabjar Ali

Convert pg_constraint.conkey array to same-order array of column names

2023-03-23 Thread Dominique Devienne
We have a query returning 1 row per constraint column, which until recently we didn't realize wasn't preserving order of the columns. A colleague fixed that, with something like below: SELECT ... FROM pg_catalog.pg_constraint cnstr ... CROSS JOIN LATERAL UNNEST(cnstr.conkey) WITH ORDINALITY AS co

Re: Logical replication fails when adding multiple replicas

2023-03-23 Thread Kyotaro Horiguchi
At Wed, 22 Mar 2023 09:25:37 +, Will Roper wrote in > Thanks for the response Hou, > > I've had a look and when the tablesync workers are spinning up there are > some errors of the form: > > "2023-03-17 18:37:06.900 UTC [4071] LOG: logical replication table > synchronization worker for su