pg.ddx.io pgsql-general@postgresql.org mailing list archive
help / color / mirror / Atom feedcorrect formula for calculating distance t transaction and distance to snapshot
2026-03-13 09:33 UTC Ishan joshi <ishanjoshi@live.com>
(PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
2026-03-12 21:02 UTC Martin Goodson <kaemaril@googlemail.com>
` Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
2026-03-12 21:43 UTC Justin Swanhart <greenlion@gmail.com>
` Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
2026-03-13 02:00 UTC Michael Paquier <michael@paquier.xyz>
` Re: (PostgreSQL 17) View usage resulting in 'ERROR: unrecognized node type: 2'
2026-03-13 02:22 UTC Tom Lane <tgl@sss.pgh.pa.us>
[4+ messages in thread]
Re: POprepare fails
2026-03-12 20:04 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: POprepare fails
2026-03-12 20:16 UTC Igor Korot <ikorot01@gmail.com>
` POprepare fails
2026-03-13 01:16 UTC Igor Korot <ikorot01@gmail.com>
[3+ messages in thread]
libq API question
2026-03-12 22:35 UTC Igor Korot <ikorot01@gmail.com>
` Re: libq API question
2026-03-12 22:39 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
LISTAGG à la Oracle in PostgreSQL
2026-03-09 20:21 UTC Pierre Forstmann <pierre.forstmann@gmail.com>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-09 22:05 UTC Paul A Jungwirth <pj@illuminatedcomputing.com>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-10 08:45 UTC Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-10 18:53 UTC Pierre Forstmann <pierre.forstmann@gmail.com>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-10 19:57 UTC Juan Rodrigo Alejandro Burgos Mella <rodrigoburgosmella@gmail.com>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-10 20:15 UTC Isaac Morland <isaac.morland@gmail.com>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-10 20:23 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-10 21:46 UTC Pavel Stehule <pavel.stehule@gmail.com>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-11 13:55 UTC Peter Eisentraut <peter@eisentraut.org>
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-11 15:53 UTC pierre.forstmann@gmail.com
` Re: LISTAGG à la Oracle in PostgreSQL
2026-03-11 15:53 UTC pierre.forstmann@gmail.com
[11+ messages in thread]
Question about heap_inplace_update and VACUUM behavior
2026-03-11 13:45 UTC Shiju Sivadazz <shijusivadazz86@gmail.com>
Guidance on PgSql Upgrade from 17.3 to 18.2
2026-03-11 08:19 UTC Pratibha Shende <shende.pratibha@gmail.com>
` Re: Guidance on PgSql Upgrade from 17.3 to 18.2
2026-03-11 13:04 UTC Ron Johnson <ronljohnsonjr@gmail.com>
[2+ messages in thread]
Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-07 09:24 UTC Shaheed Haque <shaheedhaque@gmail.com>
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-07 11:45 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-08 15:15 UTC felix.quintgz@yahoo.com
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-08 16:19 UTC Shaheed Haque <shaheedhaque@gmail.com>
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-08 18:03 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-08 18:23 UTC felix.quintgz@yahoo.com
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-08 22:08 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-09 09:55 UTC Shaheed Haque <shaheedhaque@gmail.com>
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-09 13:06 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Unexpected deadlock across two separate rows, using Postgres 17 and Django's select_for_update()
2026-03-09 17:21 UTC Shaheed Haque <shaheedhaque@gmail.com>
[10+ messages in thread]
CREATE TABLE fails
2026-03-08 22:10 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 22:29 UTC Christoph Moench-Tegeder <cmt@burggraben.net>
` Re: CREATE TABLE fails
2026-03-08 22:29 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 22:32 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 22:40 UTC Sahul Hameed <mail2shameed@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:18 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:28 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:30 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:32 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:37 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:38 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:41 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:48 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` CREATE TABLE fails
2026-03-08 23:49 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:55 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-08 23:58 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-09 00:04 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: CREATE TABLE fails
2026-03-09 01:08 UTC Igor Korot <ikorot01@gmail.com>
` Re: CREATE TABLE fails
2026-03-09 01:13 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: CREATE TABLE fails
2026-03-09 01:22 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: CREATE TABLE fails
2026-03-09 07:18 UTC Christoph Moench-Tegeder <cmt@burggraben.net>
[21+ messages in thread]
How to properly use TRIM()?
2026-03-07 07:30 UTC Igor Korot <ikorot01@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 07:41 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 08:11 UTC Igor Korot <ikorot01@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 14:29 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 15:44 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: How to properly use TRIM()?
2026-03-07 19:13 UTC Igor Korot <ikorot01@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 19:15 UTC Igor Korot <ikorot01@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 19:19 UTC Rob Sargent <robjsargent@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 19:58 UTC Igor Korot <ikorot01@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 20:03 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 20:46 UTC Igor Korot <ikorot01@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 21:29 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: How to properly use TRIM()?
2026-03-07 21:46 UTC Igor Korot <ikorot01@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 22:26 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: How to properly use TRIM()?
2026-03-07 23:08 UTC Igor Korot <ikorot01@gmail.com>
[15+ messages in thread]
Sort and limit push down
2026-03-06 18:41 UTC Adrien Nayrat <adrien.nayrat@anayrat.info>
PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup
2026-03-03 14:21 UTC loganathan P <plogandba@gmail.com>
` Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup
2026-03-03 14:48 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup
2026-03-04 06:57 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup
2026-03-05 13:18 UTC loganathan P <plogandba@gmail.com>
[4+ messages in thread]
Heavy load on DB Cluster
2026-03-05 07:00 UTC KK CHN <kkchn.in@gmail.com>
` Re: Heavy load on DB Cluster
2026-03-05 08:18 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[2+ messages in thread]
R: PostgreSQL Archive Log Partition Reaching 95% – Need Automated Cleanup
2026-03-04 08:32 UTC Gianfranco Cocco <Gianfranco.Cocco@vargroup.com>
Timezone handling with timestamp without time zone columns
2026-02-25 08:28 UTC Nandish Bhuva <Nandish.bhuva@srmsoftwareinc.com>
` Re: Timezone handling with timestamp without time zone columns
2026-02-27 15:01 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Timezone handling with timestamp without time zone columns
2026-02-28 12:00 UTC Peter J. Holzer <hjp-pgsql@hjp.at>
` Re: Timezone handling with timestamp without time zone columns
2026-03-03 10:10 UTC Nandish Bhuva <Nandish.bhuva@srmsoftwareinc.com>
` Re: Timezone handling with timestamp without time zone columns
2026-03-03 12:30 UTC Laurenz Albe <laurenz.albe@cybertec.at>
` Re: Timezone handling with timestamp without time zone columns
2026-03-03 15:53 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[6+ messages in thread]
Can "on delete cascade" dependency be used in pgdump or similar ?
2026-02-27 22:39 UTC dfgpostgres <dfgpostgres3@gmail.com>
` Re: Can "on delete cascade" dependency be used in pgdump or similar ?
2026-02-27 22:57 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Can "on delete cascade" dependency be used in pgdump or similar ?
2026-02-27 23:13 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Can "on delete cascade" dependency be used in pgdump or similar ?
2026-02-27 23:15 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Can "on delete cascade" dependency be used in pgdump or similar ?
2026-02-28 22:39 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Can "on delete cascade" dependency be used in pgdump or similar ?
2026-03-01 12:22 UTC Justin Swanhart <greenlion@gmail.com>
[6+ messages in thread]
Where the info is stored
2026-02-17 00:38 UTC Igor Korot <ikorot01@gmail.com>
` Re: Where the info is stored
2026-02-17 00:49 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Where the info is stored
2026-02-17 14:59 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: Where the info is stored
2026-02-27 16:17 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Where the info is stored
2026-03-01 00:37 UTC Igor Korot <ikorot01@gmail.com>
` Re: Where the info is stored
2026-03-01 01:02 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Where the info is stored
2026-03-01 01:05 UTC Igor Korot <ikorot01@gmail.com>
` Re: Where the info is stored
2026-03-01 01:34 UTC Igor Korot <ikorot01@gmail.com>
` Re: Where the info is stored
2026-03-01 01:35 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Where the info is stored
2026-03-01 01:42 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Where the info is stored
2026-03-01 05:34 UTC Igor Korot <ikorot01@gmail.com>
` Re: Where the info is stored
2026-03-01 05:49 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Where the info is stored
2026-03-01 07:50 UTC Igor Korot <ikorot01@gmail.com>
` Re: Where the info is stored
2026-03-01 07:58 UTC Igor Korot <ikorot01@gmail.com>
` Re: Where the info is stored
2026-03-01 10:33 UTC Laurenz Albe <laurenz.albe@cybertec.at>
[15+ messages in thread]
Default values in the docs
2026-02-27 06:43 UTC Igor Korot <ikorot01@gmail.com>
` Re: Default values in the docs
2026-02-27 14:00 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: Default values in the docs
2026-02-27 15:47 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Default values in the docs
2026-02-27 15:58 UTC David G. Johnston <david.g.johnston@gmail.com>
[4+ messages in thread]
Change WAL directory via conf
2026-02-27 13:50 UTC Thomas Butz <tbutz@optitool.de>
` Re: Change WAL directory via conf
2026-02-27 14:36 UTC David G. Johnston <david.g.johnston@gmail.com>
[2+ messages in thread]
Issue with refreshing materialized view from another system
2026-02-26 21:59 UTC Michael Nolan <htfoot@gmail.com>
` Re: Issue with refreshing materialized view from another system
2026-02-26 22:11 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Issue with refreshing materialized view from another system
2026-02-26 23:37 UTC Michael Nolan <htfoot@gmail.com>
` Re: Issue with refreshing materialized view from another system
2026-02-26 23:45 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Issue with refreshing materialized view from another system
2026-02-26 23:48 UTC Michael Nolan <htfoot@gmail.com>
` Re: Issue with refreshing materialized view from another system
2026-02-27 00:01 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Issue with refreshing materialized view from another system
2026-02-27 00:09 UTC Michael Nolan <htfoot@gmail.com>
` Re: Issue with refreshing materialized view from another system
2026-02-27 00:13 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Issue with refreshing materialized view from another system
2026-02-27 00:25 UTC Adrian Klaver <adrian.klaver@aklaver.com>
[9+ messages in thread]
PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query
2026-02-25 11:14 UTC PALAYRET Jacques <jacques.palayret@meteo.fr>
` Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query
2026-02-25 16:00 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query
2026-02-25 16:00 UTC PALAYRET Jacques <jacques.palayret@meteo.fr>
` Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query
2026-02-25 16:20 UTC David G. Johnston <david.g.johnston@gmail.com>
` Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query
2026-02-25 16:42 UTC PALAYRET Jacques <jacques.palayret@meteo.fr>
` Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query
2026-02-25 17:33 UTC Tom Lane <tgl@sss.pgh.pa.us>
` Re: PostgreSQL query with FULL OUTER JOIN and subquery using column of GROUP BY expression ERROR: subquery uses ungrouped column from outer query
2026-02-25 22:44 UTC Tom Lane <tgl@sss.pgh.pa.us>
[7+ messages in thread]
Recovery Verification
2026-02-23 22:07 UTC dolan@directdemocracysolutions.com
` Re: Recovery Verification
2026-02-24 13:40 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Recovery Verification
2026-02-24 15:50 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Recovery Verification
2026-02-24 19:16 UTC Ron Johnson <ronljohnsonjr@gmail.com>
` Re: Recovery Verification
2026-02-25 18:03 UTC dmurvihill@gmail.com
[5+ messages in thread]
pgbackrest after a network outage unable to perform backup [fails always]
2026-02-24 10:25 UTC KK CHN <kkchn.in@gmail.com>
` Re: pgbackrest after a network outage unable to perform backup [fails always]
2026-02-24 15:49 UTC Greg Sabino Mullane <htamfids@gmail.com>
` Re: pgbackrest after a network outage unable to perform backup [fails always]
2026-02-25 07:26 UTC KK CHN <kkchn.in@gmail.com>
[3+ messages in thread]
Using COPY via pg_background extension
2026-02-24 16:13 UTC Oleg Dushin <oleg.dushin@pbs-software.com>
` Re: Using COPY via pg_background extension
2026-02-24 16:28 UTC Adrian Klaver <adrian.klaver@aklaver.com>
` Re: Using COPY via pg_background extension
2026-02-24 19:21 UTC Ron Johnson <ronljohnsonjr@gmail.com>
[3+ messages in thread]
Postgres Patch Review Workshop: March 2026
2026-02-24 16:57 UTC Paul A Jungwirth <pj@illuminatedcomputing.com>
[next (older)]
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox