Re: Re[4]: CVE-2022-2625

2022-09-18 Thread Laurenz Albe
On Mon, 2022-09-19 at 07:35 +0300, misha1966 misha1966 wrote: > > Четверг, 15 сентября 2022, 17:22 +09:00 от Laurenz Albe > > : > >   > > On Thu, 2022-09-15 at 07:24 +0300, misha1966 misha1966 wrote: > > > > Четверг, 15 сентября 2022, 1:58 +09:00 от Laurenz Albe > > > > : > > > >   > > > > On Wed

Re[4]: CVE-2022-2625

2022-09-18 Thread misha1966 misha1966
How can I check this vulnerability. Which SQL to execute?   >Четверг, 15 сентября 2022, 17:22 +09:00 от Laurenz Albe >: >  >On Thu, 2022-09-15 at 07:24 +0300, misha1966 misha1966 wrote: >> > Четверг, 15 сентября 2022, 1:58 +09:00 от Laurenz Albe < >> > laurenz.a...@cybertec.at >: >> >   >> > On

Re: Re: Where's the doc for "array()" — as in "select array(values (17), (42))"

2022-09-18 Thread Tom Lane
Bryn Llewellyn writes: > Why is the "array()" constructor not found in "pg_proc"? Because it isn't a function. Yeah, it kind of looks like one, but its argument is a subquery. If SQL had first-class functions and closures, maybe ARRAY() could be implemented as an ordinary function. But I don't

Re: Where's the doc for "array()" — as in "select array(values (17), (42))"

2022-09-18 Thread David G. Johnston
On Sunday, September 18, 2022, Bryn Llewellyn wrote: > > Why is the "array()" constructor not found in "pg_proc"? > Because it isn’t a function. > > After all, section 4.2.12 refers to "array_agg()" as a constructor. And > that *is* found in "pg_proc". > I do not see this 4.2.12 reference you

Re: Where's the doc for "array()" — as in "select array(values (17), (42))"

2022-09-18 Thread Bryn Llewellyn
> adrian.kla...@aklaver.com wrote: > >> b...@yugabyte.com wrote: >> >> I noticed that "array()" is used in the query that implements the "\du" psql >> meta-command. It has some similarity with "array_agg()" thus: >> >> create temporary view x(v) as (values (17), (42)); >> select array_agg(v) fr

Re: Where's the doc for "array()" — as in "select array(values (17), (42))"

2022-09-18 Thread David G. Johnston
On Sunday, September 18, 2022, Adrian Klaver wrote: > On 9/18/22 13:25, Bryn Llewellyn wrote: > >> I noticed that "array()" is used in the query that implements the "\du" >> psql meta-command. It has some similarity with "array_agg()" thus: >> >> create temporary view x(v) as (values (17), (42));

Re: Where's the doc for "array()" — as in "select array(values (17), (42))"

2022-09-18 Thread Adrian Klaver
On 9/18/22 13:25, Bryn Llewellyn wrote: I noticed that "array()" is used in the query that implements the "\du" psql meta-command. It has some similarity with "array_agg()" thus: create temporary view x(v) as (values (17), (42)); select array_agg(v) from x; select array(select v from x); But t

Re: Where's the doc for "array()" — as in "select array(values (17), (42))"

2022-09-18 Thread Adrian Klaver
On 9/18/22 13:25, Bryn Llewellyn wrote: I noticed that "array()" is used in the query that implements the "\du" psql meta-command. It has some similarity with "array_agg()" thus: create temporary view x(v) as (values (17), (42)); select array_agg(v) from x; select array(select v from x); Any

Where's the doc for "array()" — as in "select array(values (17), (42))"

2022-09-18 Thread Bryn Llewellyn
I noticed that "array()" is used in the query that implements the "\du" psql meta-command. It has some similarity with "array_agg()" thus: create temporary view x(v) as (values (17), (42)); select array_agg(v) from x; select array(select v from x); But there are differences. The "array()" functi

Re: Mysterious performance degradation in exceptional cases

2022-09-18 Thread Adrian Klaver
On 9/18/22 09:36, Matthias Apitz wrote: You can load auto_explain per session as shown here: Every connect from the ILL forks a new 'app-server' session which creates a new ESQL/C session, and all this occur randomly when the ILL wants to search for a book title if this is available in that li

Re: Mysterious performance degradation in exceptional cases

2022-09-18 Thread Matthias Apitz
El día domingo, septiembre 18, 2022 a las 07:47:32a. m. -0700, Adrian Klaver escribió: > On 9/18/22 02:30, Matthias Apitz wrote: > > El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver > > escribió: > > > > > On 9/14/22 22:33, Matthias Apitz wrote: > > > > El día miércol

Re: Mysterious performance degradation in exceptional cases

2022-09-18 Thread Adrian Klaver
On 9/18/22 02:30, Matthias Apitz wrote: El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver escribió: On 9/14/22 22:33, Matthias Apitz wrote: El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian Klaver escribió: On 9/14/22 01:31, Matthias Apitz wr

Re: Mysterious performance degradation in exceptional cases

2022-09-18 Thread Matthias Apitz
El día jueves, septiembre 15, 2022 a las 08:40:24a. m. -0700, Adrian Klaver escribió: > On 9/14/22 22:33, Matthias Apitz wrote: > > El día miércoles, septiembre 14, 2022 a las 07:19:31a. m. -0700, Adrian > > Klaver escribió: > > > > > On 9/14/22 01:31, Matthias Apitz wrote: > > > > Where is th

Logical Replication - Give One Subscription Priority Over Other Subscriptions

2022-09-18 Thread Avi Weinberg
Hi all, I use logical replication to synchronize one big table + some small tables. I know that if all tables are part of the same subscription it will be executed in transactional order. In other words, as long as the transaction that updated the big table is not synchronized and executed on t