pgsql-general - April 2023

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

April 1, 2023

Thread Author Time
​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account jian he 06:02

April 2, 2023

Thread Author Time
Support logical replication of DDLs Phil Florent 09:55
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 13:21
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Tom Lane 15:23
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 15:40
Re: PostgreSQL Joseph Kennedy 21:21
Very slow queries followed by checkpointer process killed with signal 9 Jason McLaurin 22:25
Re: Very slow queries followed by checkpointer process killed with signal 9 Tom Lane 23:43

April 3, 2023

Thread Author Time
What permissions are needed to drop a column from a table in postgres? Siddharth Jain 00:05
Re: What permissions are needed to drop a column from a table in postgres? David G. Johnston 00:10
Re: Very slow queries followed by checkpointer process killed with signal 9 Jason McLaurin 01:21
Re: Very slow queries followed by checkpointer process killed with signal 9 Tom Lane 01:40
Re: Support logical replication of DDLs Amit Kapila 04:07
Patroni vs pgpool II Inzamam Shafiq 06:33
RE: Cannot terminate backend Arnaud Lesauvage 07:12
Re: PostgreSQL Laurenz Albe 09:45
Re: Question on creating keys on partitioned tables Laurenz Albe 09:53
DEFINER / INVOKER conundrum Dominique Devienne 11:18
Re: Very slow queries followed by checkpointer process killed with signal 9 Joe Conway 12:33
Re: DEFINER / INVOKER conundrum Christoph Moench-Tegeder 12:59
Re: Very slow queries followed by checkpointer process killed with signal 9 Christoph Moench-Tegeder 13:06
Re: Patroni vs pgpool II Ron 13:13
RE: Support logical replication of DDLs Phil Florent 13:25
Re: DEFINER / INVOKER conundrum Erik Wienhold 14:55
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 15:11
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Tom Lane 15:26
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 15:36
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 16:21
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 16:37
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 19:00
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 20:17
Re: Oracle to PostgreSQL Migration Jonny Saxon 20:17
Re: [PATCH] Introduce array_shuffle() and array_sample() Gregory Stark (as CFM) 21:16
Re: [PATCH] Introduce array_shuffle() and array_sample() 📎 Daniel Gustafsson 21:25
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 21:46
Re: [PATCH] Introduce array_shuffle() and array_sample() Daniel Gustafsson 21:52

April 4, 2023

Thread Author Time
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account jian he 01:50
RE: Support logical replication of DDLs 📎 houzj.fnst@fujitsu.com 03:13
RE: Support logical replication of DDLs houzj.fnst@fujitsu.com 03:21
Re: DEFINER / INVOKER conundrum walther 05:55
Re: DEFINER / INVOKER conundrum Erik Wienhold 08:46
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Erik Wienhold 09:01
Re: DEFINER / INVOKER conundrum Dominique Devienne 09:03
Re: Support logical replication of DDLs shveta malik 11:34
Re: Patroni vs pgpool II Jehan-Guillaume de Rorthais 12:25
Re: Patroni vs pgpool II cen 13:40
Re: ​jsonb @@ jsonpath operator doc: ​Only the first item of the result is taken into account Adrian Klaver 15:12
Re: Patroni vs pgpool II Tatsuo Ishii 23:00

April 5, 2023

Thread Author Time
Re: Patroni vs pgpool II Alexander Kukushkin 05:31
Re: Patroni vs pgpool II Tatsuo Ishii 07:38
Re: Patroni vs pgpool II Inzamam Shafiq 07:41
Re: Patroni vs pgpool II Tatsuo Ishii 07:50
PgOutput Replication Message Format - Differentiate between explicit NULL and Omitted Columns during Insert Pranav Hegde 09:09
Possible old and fixed bug in Postgres? Steve Rogerson 09:18
Re: Possible old and fixed bug in Postgres? Erik Wienhold 10:23
Re: Possible old and fixed bug in Postgres? Tom Lane 14:16
Re: PgOutput Replication Message Format - Differentiate between explicit NULL and Omitted Columns during Insert Tom Lane 14:24
Re: Possible old and fixed bug in Postgres? Steve Rogerson 15:02
Re: Possible old and fixed bug in Postgres? Ian Lawrence Barwick 15:04
Re: Possible old and fixed bug in Postgres? Tom Lane 15:07

April 6, 2023

Thread Author Time
UPSERT in Postgres Louis Tian 06:21
Proposal: Shared Work Mem Area Marco Fortina 10:51
Re: Proposal: Shared Work Mem Area Stephen Frost 12:43
R: Proposal: Shared Work Mem Area Marco Fortina 13:18
Re: Proposal: Shared Work Mem Area Marco Fortina 13:37
Re: R: Proposal: Shared Work Mem Area Stephen Frost 14:34
Re: Patroni vs pgpool II Jehan-Guillaume de Rorthais 15:41
"PANIC: could not open critical system index 2662" - twice Evgeny Morozov 16:41
PostgreSQL Mailing list public archives : search not working ... Imre Samu 17:45
Re: PostgreSQL Mailing list public archives : search not working ... Tom Lane 20:04
Re: UPSERT in Postgres Peter Geoghegan 20:58
Re: UPSERT in Postgres Adrian Klaver 21:00
Re: UPSERT in Postgres Benedict Holland 21:42
Re: PostgreSQL Mailing list public archives : search not working ... Imre Samu 22:27
Re: PostgreSQL Mailing list public archives : search not working ... Stephen Frost 23:47

April 7, 2023

Thread Author Time
Backup schema without data Atul Kumar 00:40
Re: [EXTERNAL]: Re: UPSERT in Postgres Louis Tian 00:49
Re: Backup schema without data Michael Loftis 00:53
Re: Backup schema without data Tom Lane 00:54
Re: Backup schema without data Brent Wood 00:59
Re: [EXTERNAL]: Re: UPSERT in Postgres Louis Tian 01:27
RE: Support logical replication of DDLs 📎 houzj.fnst@fujitsu.com 03:12
RE: Support logical replication of DDLs 📎 houzj.fnst@fujitsu.com 03:22
Re: Patroni vs pgpool II Tatsuo Ishii 04:16
Re: Patroni vs pgpool II Ron 05:15
Re: Patroni vs pgpool II Nikolay Samokhvalov 05:41
Re: Patroni vs pgpool II Tatsuo Ishii 06:13
Re: Patroni vs pgpool II Nikolay Samokhvalov 06:44
Re: Patroni vs pgpool II Tatsuo Ishii 07:17
Re: Patroni vs pgpool II Jehan-Guillaume de Rorthais 07:45
Re: Patroni vs pgpool II Tatsuo Ishii 09:04
Re: Patroni vs pgpool II Jehan-Guillaume de Rorthais 10:46
Re: "PANIC: could not open critical system index 2662" - twice Laurenz Albe 11:04
Re: Patroni vs pgpool II Ron 11:12
Re: "PANIC: could not open critical system index 2662" - twice Michael Paquier 11:31
Re: Patroni vs pgpool II Tatsuo Ishii 12:10
Re: Patroni vs pgpool II Tatsuo Ishii 12:16
Re: "PANIC: could not open critical system index 2662" - twice Peter J. Holzer 14:10
Re: Patroni vs pgpool II Jehan-Guillaume de Rorthais 14:33
Re: [PATCH] Introduce array_shuffle() and array_sample() Tom Lane 15:47
Re: [PATCH] Introduce array_shuffle() and array_sample() Daniel Gustafsson 16:01
Re: [EXTERNAL]: Re: UPSERT in Postgres Adrian Klaver 20:43
Re: [EXTERNAL]: Re: UPSERT in Postgres Adrian Klaver 20:52
pg_ctlcluster is not stopping cluster Telium Technical Support 22:27
Re: pg_ctlcluster is not stopping cluster Boris Epstein 22:45
Re: pg_ctlcluster is not stopping cluster Adrian Klaver 22:47
RE: pg_ctlcluster is not stopping cluster Telium Technical Support 22:48
Re: pg_ctlcluster is not stopping cluster Thorsten Glaser 22:49
RE: pg_ctlcluster is not stopping cluster Thorsten Glaser 22:50
RE: pg_ctlcluster is not stopping cluster Telium Technical Support 22:51
RE: pg_ctlcluster is not stopping cluster Telium Technical Support 23:00
Re: pg_ctlcluster is not stopping cluster Adrian Klaver 23:01

April 8, 2023

Thread Author Time
Re: pg_ctlcluster is not stopping cluster Jerry Sievers 04:27
doc sql-grant.html Synopsis error? jian he 12:58
Re: doc sql-grant.html Synopsis error? Achilleas Mantzios 13:07
Re: doc sql-grant.html Synopsis error? Adrian Klaver 15:18
Re: [EXTERNAL]: Re: UPSERT in Postgres Israel Brewster 17:09
Re: [EXTERNAL]: Re: UPSERT in Postgres Adrian Klaver 21:51
Re: [EXTERNAL]: Re: UPSERT in Postgres Benedict Holland 22:05

April 9, 2023

Thread Author Time
Postgresql Upgrade from 10 to 14 thayanban thay 01:03
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Louis Tian 01:42
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Louis Tian 02:46
Re: [EXTERNAL]: Re: UPSERT in Postgres Alban Hertroys 09:26
Re: [EXTERNAL]: Re: UPSERT in Postgres Francisco Olarte 09:32
Replicate data from one standby server to another standby Atul Kumar 10:14
Re: Replicate data from one standby server to another standby Inzamam Shafiq 10:39
Re: Postgresql Upgrade from 10 to 14 Adrian Klaver 17:23
Re: Postgresql Upgrade from 10 to 14 Tom Lane 17:32

April 10, 2023

Thread Author Time
RE: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Louis Tian 01:05
RE: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Louis Tian 01:55
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Rob Sargent 02:16
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Adrian Klaver 04:30
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Francisco Olarte 07:37
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Francisco Olarte 07:41
Re: Patroni vs pgpool II Allan Nielsen 09:07
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Karsten Hilbert 09:39
RE: Support logical replication of DDLs Zhijie Hou (Fujitsu) 09:46
Re: Support logical replication of DDLs Amit Kapila 11:20
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Francisco Olarte 11:33
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Karsten Hilbert 12:35
Re: [EXTERNAL]: Re: [EXTERNAL]: Re: UPSERT in Postgres Peter J. Holzer 14:43

April 11, 2023

Thread Author Time
FW: Error! 📎 Arquimedes Aguirre 00:55
RE: Support logical replication of DDLs Yu Shi (Fujitsu) 04:05
RE: Support logical replication of DDLs Wei Wang (Fujitsu) 04:19
Re: Support logical replication of DDLs Amit Kapila 09:02
Performance issue after migration from 9.4 to 15 Christian Schröder 10:58
RE: Performance issue after migration from 9.4 to 15 Christian Schröder 12:24
Re: Performance issue after migration from 9.4 to 15 David Rowley 13:13
Re: Performance issue after migration from 9.4 to 15 Tom Lane 14:08
RE: Performance issue after migration from 9.4 to 15 Christian Schröder 14:41
Re: "PANIC: could not open critical system index 2662" - twice Evgeny Morozov 16:44
TEXT column > 1Gb Joe Carlson 17:41
Re: TEXT column > 1Gb Rob Sargent 17:51
Re: TEXT column > 1Gb Pavel Stehule 17:58
Guidance on INSERT RETURNING order Federico 19:47
Re: Guidance on INSERT RETURNING order Adrian Klaver 20:00
Re: Guidance on INSERT RETURNING order Adrian Klaver 20:06
Re: Guidance on INSERT RETURNING order Achilleas Mantzios 20:17
Re: Guidance on INSERT RETURNING order Tom Lane 20:22
Re: Guidance on INSERT RETURNING order Federico 20:37
Re: Guidance on INSERT RETURNING order Thorsten Glaser 20:57
Re: Guidance on INSERT RETURNING order Mike Bayer 21:07
Re: Guidance on INSERT RETURNING order Federico 21:07
Re: Guidance on INSERT RETURNING order Thorsten Glaser 21:17
Re: Guidance on INSERT RETURNING order Rob Sargent 21:17
Re: Guidance on INSERT RETURNING order Federico 21:30
Re: Guidance on INSERT RETURNING order Federico 21:38
Re: Guidance on INSERT RETURNING order Thorsten Glaser 21:39
Re: Guidance on INSERT RETURNING order Rob Sargent 21:45
Re: Guidance on INSERT RETURNING order Federico 21:55
Re: Guidance on INSERT RETURNING order Federico 22:02
Re: Guidance on INSERT RETURNING order Thorsten Glaser 22:20
Re: Guidance on INSERT RETURNING order Mike Bayer 23:05
Transaction Rollback errors Siddharth Jain 23:31

April 12, 2023

Thread Author Time
parallel aggregation Alexander Saydakov 00:34
Re: "PANIC: could not open critical system index 2662" - twice Michael Paquier 00:35
Re: Transaction Rollback errors Tom Lane 02:23
pg_basebackup / recovery Fabrice Chapuis 09:32
Re: Guidance on INSERT RETURNING order Federico 09:51
Re: parallel aggregation David Rowley 10:38
Re: pg_basebackup / recovery Achilleas Mantzios - cloud 10:45
Re: Guidance on INSERT RETURNING order John Howroyd 10:50
Re: lippq client library and openssl initialization: PQinitOpenSSL() 📎 Daniel Gustafsson 10:59
Re: Support logical replication of DDLs Amit Kapila 11:23
Re: lippq client library and openssl initialization: PQinitOpenSSL() Tom Lane 12:04
subscribe Mike Bayer 14:00
Re: FW: Error! Ron 14:13
Re: subscribe Adrian Klaver 14:52
Re: TEXT column > 1Gb Joe Carlson 14:59
Re: Performance issue after migration from 9.4 to 15 Adrian Klaver 15:03
Re: FW: Error! Adrian Klaver 15:27
Re: TEXT column > 1Gb Rob Sargent 16:36
Re: TEXT column > 1Gb Mark Dilger 17:04
Re: TEXT column > 1Gb Joe Carlson 17:19
Re: TEXT column > 1Gb Benedict Holland 17:24
Re: TEXT column > 1Gb Rob Sargent 17:37
Re: TEXT column > 1Gb Ron 19:02
Re: TEXT column > 1Gb Rob Sargent 19:21
Re: TEXT column > 1Gb Benedict Holland 20:28
Re: TEXT column > 1Gb Ron 20:29

Browse Archives

Prev | Next