pgsql-general since 2022-09-15 00:00

General discussion area for users. Apart from compile, acceptance test, and bug problems, most new users will probably only be interested in this mailing list (unless they want to contribute to development or documentation). All non-bug related questions regarding PostgreSQL's version of SQL, and all installation related questions that do not involve bugs or failed compiles, should be restricted to this area. Please note that many of the developers monitor this area.

Search the Archives

(enter a message-id to go directly to that message)

Browse Archives

Prev | Next

Sept. 15, 2022

Thread Author Time
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Mladen Gogala 01:57
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Mladen Gogala 02:27
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 03:27
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 03:40
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Bryn Llewellyn 04:07
Re[2]: CVE-2022-2625 misha1966 misha1966 04:24
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Tom Lane 04:38
Re: Mysterious performance degradation in exceptional cases Matthias Apitz 05:33
Re: Re[2]: CVE-2022-2625 Laurenz Albe 08:22
Re: Resolving host to IP address Sebastien Flaesch 08:42
Re: CVE-2022-2625 Ron 08:54
Re[2]: CVE-2022-2625 misha1966 misha1966 10:23
Re: Support logical replication of DDLs 📎 Ajin Cherian 12:38
Re[2]: CVE-2022-2625 misha1966 misha1966 14:52
Re: Re[2]: CVE-2022-2625 Guillaume Lelarge 14:58
Re: CVE-2022-2625 Ron 15:05
Re: Re[2]: CVE-2022-2625 Tom Lane 15:19
Re: CVE-2022-2625 Ron 15:38
Re: Mysterious performance degradation in exceptional cases Adrian Klaver 15:40
Re: get user info on log Adrian Klaver 15:59
Re: Is it possible to stop sessions killing eachother when they all authorize as the same role? Mladen Gogala 23:59

Sept. 16, 2022

Thread Author Time
Re: Re[2]: CVE-2022-2625 Laurenz Albe 05:51
Re: Re[2]: CVE-2022-2625 Tom Lane 06:14
Re: get user info on log Marcos Pegoraro 13:00
New message in PostgreSQL log regarding socket for statistics collector Hilbert, Karin 18:40
RE: Bind Parameter is Too Big Kluzak, Matthew C. 18:42
Re: New message in PostgreSQL log regarding socket for statistics collector Christoph Moench-Tegeder 19:43
Re: New message in PostgreSQL log regarding socket for statistics collector Hilbert, Karin 20:01
Extension rpath issues on MacOS Christophe Pettus 21:06
Re: Extension rpath issues on MacOS Tom Lane 21:20
Re: Extension rpath issues on MacOS Christophe Pettus 21:23

Sept. 17, 2022

Thread Author Time
Re: get user info on log Ganesh Korde 02:22
Re: Query Performance [email protected] 05:28
Re: Query Performance Ron 08:48
Re: Query Performance Peter J. Holzer 10:03
Re: Query Performance [email protected] 11:32
Re: get user info on log Adrian Klaver 21:40
Re: get user info on log Adrian Klaver 21:41

Sept. 18, 2022

Thread Author Time
Logical Replication - Give One Subscription Priority Over Other Subscriptions Avi Weinberg 07:08
Re: Mysterious performance degradation in exceptional cases Matthias Apitz 09:30
Re: Mysterious performance degradation in exceptional cases Adrian Klaver 14:47
Suggest using boolean index with (bflag is true) condition for the query with (bflag = true) clause Евгений Плискин 15:24
Re: Mysterious performance degradation in exceptional cases Matthias Apitz 16:36
Re: Mysterious performance degradation in exceptional cases Adrian Klaver 17:05
Fwd: Postgresql/Postgis: Trigger for historization/versioning celati Laurent 19:26
Where's the doc for "array()" — as in "select array(values (17), (42))" Bryn Llewellyn 20:25
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" Adrian Klaver 20:29
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" Adrian Klaver 21:29

Sept. 19, 2022

Thread Author Time
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" David G. Johnston 00:00
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" Bryn Llewellyn 04:20
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" David G. Johnston 04:24
Re: Re: Where's the doc for "array()" — as in "select array(values (17), (42))" Tom Lane 04:31
Re[4]: CVE-2022-2625 misha1966 misha1966 04:35
Re: Re[4]: CVE-2022-2625 Laurenz Albe 05:55
What ist the standard setting of FETCH_COUNT? Tiaswin 08:19
pg RLS suggestions needed Laura Smith 09:04
Re: What ist the standard setting of FETCH_COUNT? Pavel Stehule 09:12
Re: Suggest using boolean index with (bflag is true) condition for the query with (bflag = true) clause Laurenz Albe 11:50
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" Adrian Klaver 14:29
Re: Suggest using boolean index with (bflag is true) condition for the query with (bflag = true) clause Tom Lane 14:33
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" Bryn Llewellyn 16:23
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" Bryn Llewellyn 16:43
Re: Where's the doc for "array()" — as in "select array(values (17), (42))" David G. Johnston 17:04
Re: Re: Where's the doc for "array()" — as in "select array(values (17), (42))" Tom Lane 17:05
I slipped up so that no existing role allows connection. Is rescue possible? Bryn Llewellyn 22:06
Re: I slipped up so that no existing role allows connection. Is rescue possible? Tom Lane 22:15
Re: I slipped up so that no existing role allows connection. Is rescue possible? David G. Johnston 22:18
GIST combo index condition chosen for users queries is different from table owner's query 📎 Dennis White 22:47
Re: I slipped up so that no existing role allows connection. Is rescue possible? Bryn Llewellyn 23:15
Re: GIST combo index condition chosen for users queries is different from table owner's query Tom Lane 23:28

Sept. 20, 2022

Thread Author Time
Re: I slipped up so that no existing role allows connection. Is rescue possible? Adrian Klaver 00:02
Re[4]: CVE-2022-2625 misha1966 misha1966 00:31
Re: I slipped up so that no existing role allows connection. Is rescue possible? Bryn Llewellyn 01:13
Aw: Re: I slipped up so that no existing role allows connection. Is rescue possible? Karsten Hilbert 08:48
PCI-DSS Requirements Inzamam Shafiq 09:27
Re: GIST combo index condition chosen for users queries is different from table owner's query Dennis White 12:50
Re: Support logical replication of DDLs 📎 Ajin Cherian 14:57
Re: PCI-DSS Requirements Ron 17:44
tcp settings Rob Sargent 20:05
Experience with Dell SRM/SRDF? Ron 21:08
Re: I slipped up so that no existing role allows connection. Is rescue possible? Mladen Gogala 22:29
Re: I slipped up so that no existing role allows connection. Is rescue possible? Theodore M Rolle, Jr. 22:54
Re: tcp settings Tom Lane 23:21

Sept. 21, 2022

Thread Author Time
Re: tcp settings Rob Sargent 00:46
Re: I slipped up so that no existing role allows connection. Is rescue possible? Rob Sargent 00:54
PostgreSQL Rule does not work with deferred constraint. Louis Tian 01:19
Re: tcp settings Tom Lane 04:03
Re: PostgreSQL Rule does not work with deferred constraint. Laurenz Albe 09:26
Re: I slipped up so that no existing role allows connection. Is rescue possible? Mladen Gogala 12:37
10.22 Windows binaries download? (zip "invalid" on Enterprisedb) Thomas, Richard 13:34
Re: 10.22 Windows binaries download? (zip "invalid" on Enterprisedb) Hillary Masha 13:43
Re: 10.22 Windows binaries download? (zip "invalid" on Enterprisedb) Erik Wienhold 13:43
pg_stat_activity.backend_xmin Dirschel, Steve 14:11
Re: pg_stat_activity.backend_xmin Laurenz Albe 14:36
Re: PostgreSQL Rule does not work with deferred constraint. Tom Lane 15:12
RE: 10.22 Windows binaries download? (zip "invalid" on Enterprisedb) Thomas, Richard 15:27
RE: [EXT] Re: pg_stat_activity.backend_xmin Dirschel, Steve 15:32
Re: [EXT] pg_stat_activity.backend_xmin Rob Sargent 15:39
Re: tcp settings Rob Sargent 15:44
Re: 10.22 Windows binaries download? (zip "invalid" on Enterprisedb) JITEN KUMAR SHAH 15:55
RE: [EXT] pg_stat_activity.backend_xmin Dirschel, Steve 16:22
Re: Support logical replication of DDLs 📎 Zheng Li 16:55

Sept. 22, 2022

Thread Author Time
pgbackrest Help Required Inzamam Shafiq 06:08
Re: PCI-DSS Requirements Inzamam Shafiq 06:16
ECCN for PostgreSQL YangYuping (杨瑜萍) 06:43
Re: PCI-DSS Requirements Laurenz Albe 07:46
Re: ECCN for PostgreSQL Laurenz Albe 07:51
Re: ECCN for PostgreSQL Junwang Zhao 07:53
Re: [EXT] pg_stat_activity.backend_xmin Laurenz Albe 07:59
Patroni question Zwettler Markus (OIZ) 11:04
Re: PCI-DSS Requirements Ron 11:18
Database Horizon Goti 14:00
pg_dump failed with error code 255, but I don't see why Ron 14:19
Re: pg_dump failed with error code 255, but I don't see why Tom Lane 14:34
Re: pg_dump failed with error code 255, but I don't see why Ron 14:56
Validate the internal consistency of pg_dump output? Ron 15:16
Re: [PATCH] Introduce array_shuffle() and array_sample() Andres Freund 15:23
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 15:40

Sept. 23, 2022

Thread Author Time
Re: Database Horizon Laurenz Albe 02:55
Re: pg_dump failed with error code 255, but I don't see why Jerry Sievers 04:02
How to handle logical replication 12->14, when our max_replication_slots gets overrun by inactive sync workers hubert depesz lubaczewski 14:38
Re: i added Arabic Dictionary but how I know i'm using it Mohammed falih 20:34
problem with on conflict / do update using psql 14.4 Barry Kimelman 21:28
Re: problem with on conflict / do update using psql 14.4 Steve Baldwin 21:42
Re: problem with on conflict / do update using psql 14.4 David G. Johnston 21:43
Re: problem with on conflict / do update using psql 14.4 Barry Kimelman 22:07

Sept. 24, 2022

Thread Author Time
Re: problem with on conflict / do update using psql 14.4 Barry Kimelman 14:29
Re: problem with on conflict / do update using psql 14.4 Christophe Pettus 14:46
Re: problem with on conflict / do update using psql 14.4 Barry Kimelman 15:29
Re: problem with on conflict / do update using psql 14.4 Christophe Pettus 15:43
Re: problem with on conflict / do update using psql 14.4 Barry Kimelman 15:49
Re: problem with on conflict / do update using psql 14.4 Christophe Pettus 15:56
Re: problem with on conflict / do update using psql 14.4 Barry Kimelman 16:04
Re: problem with on conflict / do update using psql 14.4 Christophe Pettus 16:40
Re: problem with on conflict / do update using psql 14.4 David G. Johnston 17:34
Re: problem with on conflict / do update using psql 14.4 Adrian Klaver 17:35
Order by in a sub query when aggregating the main query Federico 21:38
Re: Order by in a sub query when aggregating the main query Tom Lane 22:20
Re: Order by in a sub query when aggregating the main query Federico 22:30

Sept. 25, 2022

Thread Author Time
Support functions for range types 📎 Kim Johan Andersson 09:35
Re: Support functions for range types Tom Lane 14:43

Sept. 26, 2022

Thread Author Time
Re: Support functions for range types Kim Johan Andersson 04:57
Re: Support logical replication of DDLs 📎 vignesh C 10:26
Re: Support functions for range types Laurenz Albe 10:49
Findout long unused tables in database Andreas Fröde 12:05
Limiting the operations that client-side code can perform upon its database backend's artifacts Bryn Llewellyn 18:18
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 20:16

Sept. 27, 2022

Thread Author Time
Re: Findout long unused tables in database Laurenz Albe 04:25
Re: Findout long unused tables in database Andreas Fröde 05:35
Re: Findout long unused tables in database Andreas Kretschmer 06:35
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Julien Rouhaud 06:58
Re: Findout long unused tables in database Andreas Fröde 12:12
Re: pgbackrest Help Required Stephen Frost 15:39
Re: Findout long unused tables in database Laurenz Albe 15:59
Re: Order by in a sub query when aggregating the main query Federico 21:11
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Peter J. Holzer 22:26

Sept. 28, 2022

Thread Author Time
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Bryn Llewellyn 00:11
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Bryn Llewellyn 00:27
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Julien Rouhaud 01:13
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Bryn Llewellyn 02:29
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Julien Rouhaud 02:54
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Bryn Llewellyn 03:47
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Tom Lane 04:00
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Julien Rouhaud 04:06
Re: pgbackrest Help Required Inzamam Shafiq 06:52
is there still a memory leak with hash joins in PG 12.11 ? Zwettler Markus (OIZ) 08:29
Streaming wal from primiry terminating Lahnov, Igor 08:50
Re: [PATCH] Introduce array_shuffle() and array_sample() Martin Kalcher 10:40
Re: is there still a memory leak with hash joins in PG 12.11 ? Alvaro Herrera 11:13
Re: [PATCH] Introduce array_shuffle() and array_sample() Fabien COELHO 13:07
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 14:18
table inheritance and privileges Ted Toth 19:17
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Peter J. Holzer 19:43
Re: table inheritance and privileges Tom Lane 19:49
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Peter J. Holzer 20:03
Re: table inheritance and privileges Ted Toth 21:42

Sept. 29, 2022

Thread Author Time
Re: Streaming wal from primiry terminating Kyotaro Horiguchi 03:02
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Martin Kalcher 09:39
RE: Streaming wal from primiry terminating Lahnov, Igor 13:04
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 19:33

Sept. 30, 2022

Thread Author Time
Re: Streaming wal from primiry terminating Michael Paquier 00:18
Postgresql database and application server compatibility Rickson Marshall 01:36
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Bryn Llewellyn 03:24
RE: Streaming wal from primiry terminating Lahnov, Igor 06:17
Re: Support logical replication of DDLs 📎 vignesh C 07:47
[BeginnerQuestion]Why I compile lex.yy.c failed? Wen Yi 08:42
Re: [BeginnerQuestion]Why I compile lex.yy.c failed? Tom Lane 13:43
Is there Postgres ODBC binary for OSX? Igor Korot 15:36
Re: Is there Postgres ODBC binary for OSX? Daniel Gustafsson 15:41
NULL values and Java JDBC Matthias Apitz 15:46
Re: NULL values and Java JDBC Rob Sargent 15:56
Re: NULL values and Java JDBC Matthias Apitz 16:25
Re: Postgresql database and application server compatibility Ron 16:39
Re: Postgresql database and application server compatibility Laurenz Albe 17:53
RE: Postgresql database and application server compatibility Rickson Marshall 17:58
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Peter J. Holzer 18:45
Re: Is there Postgres ODBC binary for OSX? Igor Korot 22:18

Oct. 1, 2022

Thread Author Time
Re: Limiting the operations that client-side code can perform upon its database backend's artifacts Bryn Llewellyn 00:59
Singleton SELECT inside cursor loop Ron 06:29
Example code Re: Singleton SELECT inside cursor loop 📎 Ron 07:22

Browse Archives

Prev | Next