Mailing lists [pgsql-general]

1 March

• 01:39   Re: Can "on delete cascade" dependency be used in pgdump or similar ? Ron Johnson
• 03:37   Re: Where the info is stored Igor Korot
• 04:02   Re: Where the info is stored David G. Johnston
• 04:05   Re: Where the info is stored Igor Korot
• 04:34   Re: Where the info is stored Igor Korot
• 04:35   Re: Where the info is stored David G. Johnston
• 04:42   Re: Where the info is stored David G. Johnston
• 08:34   Re: Where the info is stored Igor Korot
• 08:49   Re: Where the info is stored David G. Johnston
• 10:50   Re: Where the info is stored Igor Korot
• 10:58   Re: Where the info is stored Igor Korot
• 13:33   Re: Where the info is stored Laurenz Albe
• 15:22   Re: Can "on delete cascade" dependency be used in pgdump or similar ? Justin Swanhart

2 March

• 04:38   Documentation weirdness Igor Korot
• 04:52   Re: Documentation weirdness Adrian Klaver
• 05:08   Re: Documentation weirdness David G. Johnston
• 05:49   Re: Documentation weirdness Igor Korot
• 21:29   Re: Documentation weirdness Peter J. Holzer
• 21:36   Re: Documentation weirdness David G. Johnston
• 21:42   Re: Documentation weirdness Tom Lane

3 March

• 02:27   Re: Documentation weirdness David G. Johnston
• 02:32   Re: Documentation weirdness David G. Johnston
• 13:10   Re: Timezone handling with timestamp without time zone columns Nandish Bhuva
• 15:30   Re: Timezone handling with timestamp without time zone columns Laurenz Albe
• 17:21   PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup loganathan P
• 17:48   Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Laurenz Albe
• 18:53   Re: Timezone handling with timestamp without time zone columns Adrian Klaver

4 March

• 09:57   Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Ron Johnson
• 11:32   R: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup Gianfranco Cocco

5 March

• 10:00   Heavy load on DB Cluster KK CHN
• 11:18   Re: Heavy load on DB Cluster Laurenz Albe
• 16:18   Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup loganathan P
• 16:23   RE: Index (primary key) corrupt? Wim Rouquart
• 19:04   Re: Index (primary key) corrupt? Adrian Klaver

6 March

• 13:31   RE: Index (primary key) corrupt? Wim Rouquart
• 19:03   Re: Index (primary key) corrupt? Adrian Klaver
• 21:41   Sort and limit push down Adrien Nayrat

7 March

• 10:30   How to properly use TRIM()? Igor Korot
• 10:41   Re: How to properly use TRIM()? David G. Johnston
• 11:11   Re: How to properly use TRIM()? Igor Korot
• 12:24   Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
• 14:45   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Tom Lane
• 17:29   Re: How to properly use TRIM()? David G. Johnston
• 18:44   Re: How to properly use TRIM()? Adrian Klaver
• 22:13   Re: How to properly use TRIM()? Igor Korot
• 22:15   Re: How to properly use TRIM()? Igor Korot
• 22:58   Re: How to properly use TRIM()? Igor Korot
• 23:03   Re: How to properly use TRIM()? David G. Johnston
• 23:46   Re: How to properly use TRIM()? Igor Korot

8 March

• 00:29   Re: How to properly use TRIM()? Adrian Klaver
• 00:46   Re: How to properly use TRIM()? Igor Korot
• 01:26   Re: How to properly use TRIM()? David G. Johnston
• 02:08   Re: How to properly use TRIM()? Igor Korot
• 18:15   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() felix.quintgz@yahoo.com
• 19:19   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
• 21:03   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Laurenz Albe
• 21:23   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() felix.quintgz@yahoo.com

9 March

• 01:08   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Greg Sabino Mullane
• 01:10   CREATE TABLE fails Igor Korot
• 01:29   Re: CREATE TABLE fails Christoph Moench-Tegeder
• 01:29   Re: CREATE TABLE fails Ron Johnson
• 01:32   Re: CREATE TABLE fails Ron Johnson
• 01:40   Re: CREATE TABLE fails Sahul Hameed
• 02:18   Re: CREATE TABLE fails Igor Korot
• 02:28   Re: CREATE TABLE fails Igor Korot
• 02:30   Re: CREATE TABLE fails Igor Korot
• 02:32   Re: CREATE TABLE fails Igor Korot
• 02:37   Re: CREATE TABLE fails David G. Johnston
• 02:38   Re: CREATE TABLE fails Igor Korot
• 02:41   Re: CREATE TABLE fails Igor Korot
• 02:48   Re: CREATE TABLE fails Ron Johnson
• 02:49   CREATE TABLE fails David G. Johnston
• 02:55   Re: CREATE TABLE fails Igor Korot
• 02:58   Re: CREATE TABLE fails Igor Korot
• 03:04   Re: CREATE TABLE fails David G. Johnston
• 04:08   Re: CREATE TABLE fails Igor Korot
• 04:13   Re: CREATE TABLE fails David G. Johnston
• 04:22   Re: CREATE TABLE fails Adrian Klaver
• 10:18   Re: CREATE TABLE fails Christoph Moench-Tegeder
• 12:55   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
• 16:06   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Greg Sabino Mullane
• 17:12   RE: Index (primary key) corrupt? Wim Rouquart
• 17:52   Re: Index (primary key) corrupt? Adrian Klaver
• 18:24   Re: Index (primary key) corrupt? Greg Sabino Mullane
• 18:37   Re: Index (primary key) corrupt? Adrian Klaver
• 20:21   Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update() Shaheed Haque
• 20:53   Re: Index (primary key) corrupt? Greg Sabino Mullane
• 22:52   Re: Index (primary key) corrupt? Adrian Klaver
• 23:21   LISTAGG à la Oracle in PostgreSQL Pierre Forstmann

10 March

• 01:05   Re: LISTAGG à la Oracle in PostgreSQL Paul A Jungwirth
• 11:45   Re: LISTAGG à la Oracle in PostgreSQL Juan Rodrigo Alejandro Burgos Mella
• 17:15   Re: Index (primary key) corrupt? Greg Sabino Mullane
• 17:24   RE: Index (primary key) corrupt? Wim Rouquart
• 17:43   Re: Index (primary key) corrupt? Greg Sabino Mullane
• 18:09   Re: Index (primary key) corrupt? Adrian Klaver
• 21:53   Re: LISTAGG à la Oracle in PostgreSQL Pierre Forstmann
• 22:57   Re: LISTAGG à la Oracle in PostgreSQL Juan Rodrigo Alejandro Burgos Mella
• 23:15   Re: LISTAGG à la Oracle in PostgreSQL Isaac Morland
• 23:23   Re: LISTAGG à la Oracle in PostgreSQL Pavel Stehule

11 March

• 00:46   Re: LISTAGG à la Oracle in PostgreSQL Pavel Stehule
• 11:19   Guidance on PgSql Upgrade from 17.3 to 18.2 Pratibha Shende
• 16:04   Re: Guidance on PgSql Upgrade from 17.3 to 18.2 Ron Johnson
• 16:45   Question about heap_inplace_update and VACUUM behavior Shiju Sivadazz
• 16:55   Re: LISTAGG à la Oracle in PostgreSQL Peter Eisentraut
• 18:53   Re: LISTAGG à la Oracle in PostgreSQL pierre.forstmann@gmail.com
• 18:53   Re: LISTAGG à la Oracle in PostgreSQL pierre.forstmann@gmail.com

12 March

• 23:04   Re: POprepare fails Laurenz Albe
• 23:16   Re: POprepare fails Igor Korot

13 March

• 00:02   (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Martin Goodson
• 00:43   Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Justin Swanhart
• 01:35   libq API question Igor Korot
• 01:39   Re: libq API question David G. Johnston
• 04:16   POprepare fails Igor Korot
• 05:00   Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Michael Paquier
• 05:22   Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2' Tom Lane
• 12:33   correct formula for calculating distance t transaction and distance to snapshot Ishan joshi
• 13:41   Replication to standby broke with WAL file corruption Ishan joshi
• 15:08   Index scan with bitmap filter - has this been explored Laurence Newman

14 March

• 07:40   libpq usage from C++ Igor Korot
• 07:47   Re: libpq usage from C++ Ron Johnson
• 07:51   Re: libpq usage from C++ Adrian Klaver
• 10:09   Does included columns part of the PK Igor Korot
• 10:12   Re: Does included columns part of the PK Igor Korot
• 12:27   compatibility between PostgreSQL JDBC driver version 42.7.10 and Java 25 Arbol One
• 18:07   Re: Does included columns part of the PK David G. Johnston
• 18:14   Re: compatibility between PostgreSQL JDBC driver version 42.7.10 and Java 25 Adrian Klaver
• 18:25   Re: Does included columns part of the PK Adrian Klaver
• 18:51   Re: Does included columns part of the PK David G. Johnston
• 19:56   Re: Does included columns part of the PK Igor Korot

15 March

• 02:30   Re: Does included columns part of the PK Adrian Klaver
• 09:24   Re: Does included columns part of the PK Igor Korot
• 10:11   Using \copy to populate a table rob stone
• 10:21   Re: Using \copy to populate a table Brent Wood
• 12:48   Re: Using \copy to populate a table Ron Johnson
• 12:50   Re: Using \copy to populate a table Francisco Olarte
• 18:30   Re: Using \copy to populate a table Adrian Klaver
• 18:34   Re: Does included columns part of the PK Adrian Klaver

16 March

• 02:09   Re: Replication to standby broke with WAL file corruption Tomas Vondra
• 02:38   Re: Index scan with bitmap filter - has this been explored Tomas Vondra
• 02:38   Re: Index scan with bitmap filter - has this been explored Tomas Vondra
• 04:23   Re: Does included columns part of the PK Igor Korot
• 09:04   Re: Replication to standby broke with WAL file corruption Ishan joshi
• 13:25   Re: libpq usage from C++ Dominique Devienne
• 16:53   Re: Does included columns part of the PK Greg Sabino Mullane
• 18:03   Re: Does included columns part of the PK Adrian Klaver
• 21:43   Re: Does included columns part of the PK Igor Korot

17 March

• 00:27   Re: Does included columns part of the PK Adrian Klaver
• 00:30   Re: Does included columns part of the PK Adrian Klaver
• 00:40   Re: Does included columns part of the PK Adrian Klaver
• 00:51   Re: Does included columns part of the PK Igor Korot
• 00:57   Re: Does included columns part of the PK Adrian Klaver
• 02:38   Re: Does included columns part of the PK Igor Korot
• 03:44   Re: Does included columns part of the PK Adrian Klaver
• 04:11   Re: Does included columns part of the PK Igor Korot
• 05:16   Re: Using \copy to populate a table Peter Kleiner
• 15:08   Re: Using \copy to populate a table rob stone
• 16:58   Can I use pg_dump to save a sequence for a table that is not also being saved? Shaheed Haque
• 17:37   Re: Can I use pg_dump to save a sequence for a table that is not also being saved? Adrian Klaver
• 17:55   Re: Can I use pg_dump to save a sequence for a table that is not also being saved? Adrian Klaver
• 20:28   Re: Can I use pg_dump to save a sequence for a table that is not also being saved? Shaheed Haque
• 20:29   help debugging an issue with selectivity Greg Hennessy
• 20:43   Re: Can I use pg_dump to save a sequence for a table that is not also being saved? Adrian Klaver
• 22:31   Trying to understand pg_get_expr() Adrian Klaver
• 23:08   Re: Trying to understand pg_get_expr() Marcos Pegoraro
• 23:19   Re: Trying to understand pg_get_expr() Adrian Klaver
• 23:26   Re: Trying to understand pg_get_expr() Marcos Pegoraro
• 23:36   Re: Trying to understand pg_get_expr() Adrian Klaver
• 23:54   Re: Trying to understand pg_get_expr() Marcos Pegoraro

18 March

• 00:04   Re: Trying to understand pg_get_expr() Tom Lane
• 00:12   Re: Trying to understand pg_get_expr() Marcos Pegoraro
• 03:38   Re: help debugging an issue with selectivity Rob Sargent
• 05:37   Re: help debugging an issue with selectivity Tom Lane
• 18:56   Re: help debugging an issue with selectivity Greg Hennessy

20 March

• 16:43   Re: Index scan with bitmap filter - has this been explored Alexandre Felipe
• 16:43   Re: Index scan with bitmap filter - has this been explored Alexandre Felipe

23 March

• 08:52   Fwd: Extension - multilingual_fuzzy_match : Multilingual phonetic matching extension for PostgreSQL Blessy Thomas
• 13:16   PostGre SQL/ HCL Aayra Singh
• 23:18   Re: PostGre SQL/ HCL Bruce Momjian
• 23:24   Re: PostGre SQL/ HCL Adrian Klaver

24 March

• 05:16   RE: PostGre SQL/ HCL Aayra Singh
• 06:49   Re: PostGre SQL/ HCL Adrian Klaver
• 07:04   Re: PostGre SQL/ HCL Christophe Pettus
• 13:04   Re: PostGre SQL/ HCL Jan Karremans
• 13:31   Re: PostGre SQL/ HCL Juan Rodrigo Alejandro Burgos Mella
• 17:06   Logical replication in PostgreSQL Amount of subscriber vs publisher WALs PALAYRET Jacques
• 17:21   Re: PostGre SQL/ HCL Bruce Momjian

25 March

• 05:46   Recall: PostGre SQL/ HCL Aayra Singh
• 05:58   Re: Recall: PostGre SQL/ HCL David G. Johnston
• 06:05   RE: Recall: PostGre SQL/ HCL Aayra Singh
• 13:48   malformated LSB header in postgres: missing LSB end marker, aborting Matthias Apitz
• 17:35   Re: malformated LSB header in postgres: missing LSB end marker, aborting Adrian Klaver
• 19:15   Re: Logical replication in PostgreSQL Amount of subscriber vs publisher WALs Vacuuming PALAYRET Jacques
• 20:20   Where to store some session based info? Durumdara
• 20:40   Re: Where to store some session based info? Pavel Stehule
• 20:51   Re: Where to store some session based info? Adrian Klaver

26 March

• 16:53   Re: Where to store some session based info? Durumdara

27 March

• 17:34   Lightning Talk Proposal – PostgreSQL & Software Heritage (pgDay Paris Follow-up) Linda Angulo lopez

28 March

• 07:54   Does WITHOUT OVERLAPS boolean stored somewhere? Igor Korot
• 08:04   Re: Does WITHOUT OVERLAPS boolean stored somewhere? Julien Rouhaud
• 08:23   Re: Does WITHOUT OVERLAPS boolean stored somewhere? Igor Korot
• 10:07   slow sql query for big items Hua W Peng
• 10:33   Re: slow sql query for big items Laurenz Albe
• 12:09   Uzbek Hunspell extension for full-text search (Latin + Cyrillic) Abdugani Adikhanov
• 16:21   Re: slow sql query for big items Ron Johnson

29 March

• 09:08   How to escape string in Postgres? Igor Korot
• 09:56   Re: How to escape string in Postgres? Laurenz Albe
• 10:21   Re: How to escape string in Postgres? Igor Korot
• 11:00   Re: How to escape string in Postgres? Pavel Stehule
• 14:54   Re: How to escape string in Postgres? hubert depesz lubaczewski