Home > mailing lists

Mailing lists [pgsql-general]

1 November

09:42 Re: What to do with a PAAS-pg server Bruce Momjian
12:07 Re: What to do with a PAAS-pg server Ian Lawrence Barwick
12:40 Re: pg_wal folder high disk usage Muhammad Usman Khan
14:41 Re: Plans for partitioning of inheriting tables thiemo@gelassene-pferde.biz
19:10 Re: pg_wal folder high disk usage Greg Sabino Mullane
20:35 Re: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed user
21:15 Re: Plans for partitioning of inheriting tables Achilleas Mantzios - cloud
22:47 Re: Plans for partitioning of inheriting tables Adrian Klaver
23:21 Re: Plans for partitioning of inheriting tables thiemo@gelassene-pferde.biz

2 November

00:01 Re: Plans for partitioning of inheriting tables Adrian Klaver
00:43 Re: Plans for partitioning of inheriting tables Torsten Förtsch
01:14 Re: Plans for partitioning of inheriting tables thiemo@gelassene-pferde.biz
01:16 Re: Plans for partitioning of inheriting tables thiemo@gelassene-pferde.biz
01:38 Re: Plans for partitioning of inheriting tables Adrian Klaver
02:47 Re: Plans for partitioning of inheriting tables Thiemo Kellner
02:57 Re: Plans for partitioning of inheriting tables Adrian Klaver
05:10 Re: Plans for partitioning of inheriting tables thiemo@gelassene-pferde.biz
05:53 Re: Plans for partitioning of inheriting tables Adrian Klaver
13:13 Re: Plans for partitioning of inheriting tables Thiemo Kellner
13:19 Re: Random memory related errors on live postgres 14.13 instance on Ubuntu 22.04 LTS Ian J Cottee

3 November

19:59 Re: pg_wal folder high disk usage Koen De Groote

4 November

03:27 Re: Random memory related errors on live postgres 14.13 instance on Ubuntu 22.04 LTS Vijaykumar Jain
15:52 Why not do distinct before SetOp ma lz
17:09 Re: Why not do distinct before SetOp David Rowley
17:53 Re: pg_wal folder high disk usage Paul Brindusa
19:35 Re: Used memory calculation in containers - docker stats and file cache Costa Alexoglou
21:18 Re: Why not do distinct before SetOp Tom Lane

5 November

02:02 Column name beginning with underscore ("_")? Jim Rosenberg
02:10 Re: Column name beginning with underscore ("_")? Tom Lane
02:33 Re: Column name beginning with underscore ("_")? Adrian Klaver
05:17 nth_value out of more than n values returns null Guyren Howe
05:36 Re: nth_value out of more than n values returns null Adrian Klaver
05:36 Re: nth_value out of more than n values returns null Erik Wienhold
05:38 Re: nth_value out of more than n values returns null Guyren Howe
05:44 Re: nth_value out of more than n values returns null David G. Johnston
05:46 Re: nth_value out of more than n values returns null Guyren Howe
05:53 Re: nth_value out of more than n values returns null David G. Johnston
06:49 Re: nth_value out of more than n values returns null Tom Lane
19:45 Postgres listens on random port Kal
20:11 Re: Postgres listens on random port Greg Sabino Mullane
20:22 Re: Postgres listens on random port Kal
20:26 Re: Postgres listens on random port Saul Perdomo
20:34 Re: Postgres listens on random port Kal
20:40 Re: Postgres listens on random port Ron Johnson
20:43 Re: Postgres listens on random port Erik Wienhold
21:21 Postgres 12.21? Mark Hill
21:25 Re: Postgres listens on random port Saul Perdomo
21:30 Re: Postgres 12.21? David G. Johnston
21:46 Re: Postgres listens on random port Adrian Klaver
23:10 Switching to NOINHERIT user triggers #XX000 error Dominique Devienne
23:42 Re: Switching to NOINHERIT user triggers #XX000 error Tom Lane

6 November

00:21 Re: Switching to NOINHERIT user triggers #XX000 error Dominique Devienne
00:25 Re: Switching to NOINHERIT user triggers #XX000 error Tom Lane
00:29 Re: Switching to NOINHERIT user triggers #XX000 error Dominique Devienne
03:45 adsrc Matt Zagrabelny
04:11 Re: Why not do distinct before SetOp David Rowley
04:22 Re: adsrc Christoph Moench-Tegeder
04:31 Re: adsrc David G. Johnston
04:44 Re: adsrc Ron Johnson
04:47 Re: adsrc Matt Zagrabelny
05:09 Re: Why not do distinct before SetOp Tom Lane
05:38 Re: Why not do distinct before SetOp David Rowley
22:20 About the stability of COPY BINARY data Dominique Devienne

7 November

00:23 Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 Laurenz Albe
00:47 Trouble using pg_rewind to undo standby promotion Craig McIlwee
04:11 Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 David Mullineux
09:41 Re: Index Partition Size Double of its Table Partition? Don Seiler
15:46 Re: Trouble using pg_rewind to undo standby promotion Torsten Förtsch
19:26 Re: Trouble using pg_rewind to undo standby promotion Craig McIlwee
22:37 Re: About the stability of COPY BINARY data Adrian Klaver
23:14 Re: About the stability of COPY BINARY data Dominique Devienne
23:39 Re: About the stability of COPY BINARY data Daniel Verite
23:55 Re: About the stability of COPY BINARY data Dominique Devienne

8 November

00:04 Re: About the stability of COPY BINARY data Adrian Klaver
00:10 Re: About the stability of COPY BINARY data Dominique Devienne
01:42 Re: Trouble using pg_rewind to undo standby promotion Craig McIlwee
03:06 Advice on cluster architecture for two related, but distinct, use cases Matthias Leisi
05:49 Re: Advice on cluster architecture for two related, but distinct, use cases Zahid Rahman
09:07 Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 ravi k
13:58 Why plpython functions increase transaction counter much more then plpgsql functions? Michał Albrycht
19:39 Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 David Mullineux
20:03 Re: Why plpython functions increase transaction counter much more then plpgsql functions? Ron Johnson
20:39 Re: Why plpython functions increase transaction counter much more then plpgsql functions? Tom Lane
23:44 Re: Why plpython functions increase transaction counter much more then plpgsql functions? Michał Albrycht

9 November

00:12 Can we directly upgrade postgresql from 13 to 15.4 jayesh thakare
00:16 Re: Can we directly upgrade postgresql from 13 to 15.4 Christophe Pettus
02:23 Re: Can we directly upgrade postgresql from 13 to 15.4 Adrian Klaver
09:45 Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 ravi k
10:40 pgsql_tmp consuming most of the space. jayesh thakare
11:04 Re: pgsql_tmp consuming most of the space. Ron Johnson
11:46 Re: Can we directly upgrade postgresql from 13 to 15.4 Achilleas Mantzios
16:10 Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 David Mullineux
18:02 Re: Performance Issue with Hash Partition Query Execution in PostgreSQL 16 ravi k
23:41 Bash function from psql (v14) Murthy Nunna

10 November

00:02 Re: Bash function from psql (v14) Efrain J. Berdecia
00:22 Re: Bash function from psql (v14) Vijaykumar Jain
19:18 Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed user
20:55 Re: Bash function from psql (v14) Greg Sabino Mullane
21:21 RE: Bash function from psql (v14) Murthy Nunna
22:34 Re: adsrc Greg Sabino Mullane

11 November

01:07 Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed Adrian Klaver
01:52 Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed user
04:16 Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed Adrian Klaver
05:44 Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed Tom Lane
11:40 Duplicate key error yudhi s
14:06 CREATE SCHEMA ... CREATE M.V. support Kirill Reshke
14:27 Re: Duplicate key error Achilleas Mantzios - cloud
16:09 Re: CREATE SCHEMA ... CREATE M.V. support Alvaro Herrera
17:23 Question About Native Support for SQL:2011 Temporal Tables in PostgreSQL David Lynam
20:27 Re: Advice on cluster architecture for two related, but distinct, use cases Greg Sabino Mullane
20:46 Re: Advice on cluster architecture for two related, but distinct, use cases sunyucong@gmail.com
22:18 Re: postgresql-17.0-1 Application - silent installation Issue Adrian Klaver

12 November

00:50 Re: Duplicate key error yudhi s
02:04 Re: Duplicate key error Peter Geoghegan
05:10 create policy statement USING clause Mark Phillips
12:09 RE: postgresql-17.0-1 Application - silent installation Issue JOLAPARA Urvi (SAFRAN)
14:48 Re: create policy statement USING clause Laurenz Albe
16:46 PostgreSQL logical replication Jayadevan M
18:43 BitmapOr node not used in plan for ANY/IN but is for sequence of ORs ... Jim Vanns
20:16 Re: PostgreSQL logical replication Ron Johnson
22:35 Re: postgresql-17.0-1 Application - silent installation Issue Adrian Klaver

13 November

00:54 Re: create policy statement USING clause Mark Phillips
02:38 Re: Duplicate key error yudhi s
02:43 Re: Duplicate key error Peter Geoghegan
12:45 A million users Kaare Rasmussen
13:13 Fwd: A million users Vijaykumar Jain
14:45 Re: PostgreSQL logical replication Jayadevan M
16:29 Re: Fwd: A million users Alvaro Herrera
16:52 Re: Fwd: A million users Dominique Devienne
17:12 Re: Fwd: A million users Achilleas Mantzios - cloud
17:30 Re: Fwd: A million users Vijaykumar Jain
17:40 Re: Fwd: A million users Vijaykumar Jain
17:49 Re: Fwd: Fwd: Postgres attach partition: AccessExclusive lock set on different tables depending on how attaching is performed Alvaro Herrera
18:41 Re: Fwd: A million users Kaare Rasmussen
19:40 Re: Fwd: A million users Alvaro Herrera
20:58 Extract values from XML content celati Laurent
22:15 DB wal file disabled --_Query jayakumar s
22:21 Re: DB wal file disabled --_Query David G. Johnston
22:24 Re: DB wal file disabled --_Query Adrian Klaver

14 November

00:01 Re: Fwd: A million users walther@technowledgy.de
00:13 Re: Extract values from XML content David G. Johnston
00:50 Help with restoring database from old version of PostgreSQL Catherine Frock
01:09 work_mem RAM Accounting in PostgreSQL Alexandru Lazarev
01:47 Re: Help with restoring database from old version of PostgreSQL Ron Johnson
02:07 Re: Extract values from XML content shammat@gmx.net
02:42 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver
07:33 Row level security policy Mark Phillips
07:36 Re: Row level security policy David G. Johnston
11:05 Re: Row level security policy Mark Phillips
14:42 Retrieve filename within a script Patrick FICHE
14:58 Re: question on audit columns Johannes Lochmann
15:05 RE: postgresql-17.0-1 Application - silent installation Issue JOLAPARA Urvi (SAFRAN)
15:14 Re: DB wal file disabled --_Query jayakumar s
15:57 Re: Row level security policy Laurenz Albe
18:04 Re: Row level security policy Mark Phillips
20:02 Re: DB wal file disabled --_Query David G. Johnston
20:40 Re: work_mem RAM Accounting in PostgreSQL Laurenz Albe
21:20 Re: postgresql-17.0-1 Application - silent installation Issue Rob Sargent
21:38 Re: Help with restoring database from old version of PostgreSQL Ron Johnson
22:32 Re: question on audit columns Greg Sabino Mullane
22:45 Re: postgresql-17.0-1 Application - silent installation Issue Adrian Klaver
23:02 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver

15 November

03:33 Validating check constraints without a table scan? Philip Couling
14:44 Re: Validating check constraints without a table scan? Laurenz Albe
20:27 DB Files Andy Hartman
21:28 Re: Validating check constraints without a table scan? Torsten Förtsch
21:47 Re: DB Files Adrian Klaver
21:48 Re: Retrieve filename within a script Adrian Klaver
21:49 Re: DB Files Torsten Förtsch
21:49 Re: DB Files Andy Hartman
22:29 Re: Retrieve filename within a script Vincent Veyron

16 November

01:46 Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) Bharani SV-forum
01:56 Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) David G. Johnston
03:13 Re: Need exact SQL query to find List of Detach Partitioned Tables (Yet to be Dropped) Adrian Klaver
17:15 Re: Getting error 42P02, despite query parameter being sent Achilleas Mantzios
17:25 Re: Validating check constraints without a table scan? Philip Couling
22:09 Re: Getting error 42P02, despite query parameter being sent Adrian Klaver
22:51 Re: Getting error 42P02, despite query parameter being sent Tom Lane

17 November

16:09 Re: Getting error 42P02, despite query parameter being sent Max Ulidtko
23:05 Re: Getting error 42P02, despite query parameter being sent Adrian Klaver
23:18 Re: Getting error 42P02, despite query parameter being sent David G. Johnston

18 November

01:44 Re: Getting error 42P02, despite query parameter being sent Achilleas Mantzios
04:02 Re: Getting error 42P02, despite query parameter being sent Adrian Klaver
15:03 Re : Credcheck extension 張宸瑋
15:36 Re: Re : Credcheck extension Julien Rouhaud
20:37 Functions and Indexes Moreno Andreo
20:43 Re: Functions and Indexes Gianni Ceccarelli
21:15 Re: Re : Credcheck extension Adrian Klaver
22:11 Re: work_mem RAM Accounting in PostgreSQL Alexandru Lazarev
23:22 Postgres service not starting on windows after install if not installed into standard locations Thomas Schweikle
23:48 Re: Postgres service not starting on windows after install if not installed into standard locations Adrian Klaver

19 November

00:43 Re: Postgres service not starting on windows after install if not installed into standard locations Laurenz Albe
00:57 Re: work_mem RAM Accounting in PostgreSQL Laurenz Albe
01:05 Re: Functions and Indexes Laurenz Albe
03:24 Default session role broken in PostgreSQL 14.14? Maxime Legault-Venne
03:27 Re: Default session role broken in PostgreSQL 14.14? David G. Johnston
14:40 Re: Re : Credcheck extension 張宸瑋
14:42 Re: Functions and Indexes Moreno Andreo
16:53 Re: Functions and Indexes Moreno Andreo
17:34 Re: Functions and Indexes Laurenz Albe
19:30 Re: Functions and Indexes Moreno Andreo
21:47 Specifying columns returned by a function, when the function is in a SELECT column list? Ron Johnson
21:55 Re: Specifying columns returned by a function, when the function is in a SELECT column list? David G. Johnston
22:11 PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Paul Foerster
22:17 Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Adrian Klaver
22:25 Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Tom Lane
22:25 Re: Re : Credcheck extension Adrian Klaver
22:34 Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Alvaro Herrera
23:44 Re: Functions and Indexes Laurenz Albe

20 November

01:08 Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Paul Foerster
01:12 Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Paul Foerster
01:16 Re: PostgreSQL 15.9 Update: Partitioned tables with foreign key constraints Paul Foerster
04:16 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver
04:22 Running docker in postgres, SHM size of the docker container in postgres 16 Koen De Groote
05:00 Re: Help with restoring database from old version of PostgreSQL Adrian Klaver
05:37 Re: Running docker in postgres, SHM size of the docker container in postgres 16 Thomas Munro
09:01 Re: Re : Credcheck extension 張宸瑋
10:04 Re: Re : Credcheck extension Adrian Klaver
12:44 Re: Re : Credcheck extension 張宸瑋
14:54 Clarification on CVE-2024-10979 and PostgreSQL Upgrade Necessity Without PL/Perl Usage Subhash Udata
15:45 Re: Validating check constraints without a table scan? jian he
15:53 Re: Fwd: Error when opening pgAdmin Lucía Rotger
16:10 Re: Postgres service not starting on windows after install if not installed into standard locations Thomas Schweikle
16:50 Suddenly all queries moved to seq scan Sreejith P
17:06 Re: Running docker in postgres, SHM size of the docker container in postgres 16 Koen De Groote
17:16 Memory settings when running postgres in a docker container Koen De Groote
17:16 Re: Validating check constraints without a table scan? Philip Couling
18:56 Re: Suddenly all queries moved to seq scan Achilleas Mantzios - cloud
19:02 Re: Suddenly all queries moved to seq scan Daniel Gustafsson
19:21 Re: Suddenly all queries moved to seq scan Efrain J. Berdecia
19:26 Re: Postgres service not starting on windows after install if not installed into standard locations Thomas Schweikle
20:06 Re: Running docker in postgres, SHM size of the docker container in postgres 16 felix.quintgz@yahoo.com
20:08 Re: Suddenly all queries moved to seq scan Sreejith P
20:26 Update to postgresql 14.14 Levente Birta
22:05 Re: Fwd: Error when opening pgAdmin Adrian Klaver
22:12 Re: Clarification on CVE-2024-10979 and PostgreSQL Upgrade Necessity Without PL/Perl Usage Adrian Klaver
22:15 Re: Update to postgresql 14.14 Adrian Klaver
23:15 Re: Postgres service not starting on windows after install if not installed into standard locations Adrian Klaver
23:28 Re: Suddenly all queries moved to seq scan Justin

21 November

00:04 A table lock inside a transaction depends on query protocol being used? Istvan Soos
00:38 Re: Fwd: Error when opening pgAdmin Adrian Klaver
00:57 Re: A table lock inside a transaction depends on query protocol being used? Tom Lane
01:39 Re: A table lock inside a transaction depends on query protocol being used? Istvan Soos
04:10 Re: Memory settings when running postgres in a docker container David Mullineux
12:44 CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 김주연
12:54 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Adrian Klaver
13:14 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 김주연
20:10 Re: Postgres service not starting on windows after install if not installed into standard locations Thomas Schweikle
20:22 Re: Update to postgresql 14.14 Levente Birta
22:45 Re: Postgres service not starting on windows after install if not installed into standard locations Adrian Klaver
23:29 Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
23:54 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Adrian Klaver

22 November

02:48 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Adrian Klaver
02:57 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
03:12 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Adrian Klaver
03:29 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Ron Johnson
03:31 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
03:33 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
04:32 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Adrian Klaver
05:50 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
09:57 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Subhash Udata
10:09 CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 David G. Johnston
10:31 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Subhash Udata
10:35 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Tom Lane
10:38 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Adrian Klaver
10:39 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Ron Johnson
10:44 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Adrian Klaver
10:51 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 David G. Johnston
10:52 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Laurenz Albe
10:53 CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 David G. Johnston
11:02 PostgreSQL Log Info Jethish Jethish
11:19 Re: PostgreSQL Log Info David G. Johnston
11:21 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Adrian Klaver
11:40 License question prashant sinha
12:20 Re: Fwd: A million users Kaare Rasmussen
13:32 Re: PostgreSQL Log Info Jethish Jethish
14:00 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Matthias Apitz
15:01 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Achilleas Mantzios - cloud
15:07 Re: PostgreSQL Log Info Ron Johnson
15:10 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Matthias Apitz
15:18 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Ron Johnson
17:25 Re: PostgreSQL Log Info hubert depesz lubaczewski
17:35 Re: PostgreSQL Log Info Karsten Hilbert
18:24 Re: Fwd: A million users Eric Hanson
18:57 Re: Fwd: A million users walther@technowledgy.de
19:43 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 David G. Johnston
21:52 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Laurenz Albe
22:02 Re: PostgreSQL Log Info Adrian Klaver
22:15 Re: PostgreSQL Log Info David G. Johnston
22:26 Re: PostgreSQL Log Info Jethish Jethish
22:32 Re: PostgreSQL Log Info Adrian Klaver
22:34 Re: PostgreSQL Log Info David G. Johnston
23:18 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Adrian Klaver

23 November

02:07 Wired behaviour from SELECT Arbol One
02:12 Re: Wired behaviour from SELECT David G. Johnston
02:36 Re: Wired behaviour from SELECT Ron Johnson
02:59 Re: Memory settings when running postgres in a docker container Koen De Groote
05:23 Re: Fwd: A million users Eric Hanson
05:55 Re: Wired behaviour from SELECT David Mullineux
15:47 Re: Wired behaviour from SELECT Arbol One
15:49 Re: Wired behaviour from SELECT Arbol One
19:06 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
19:09 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Ray O'Donnell
19:16 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
21:01 PQexecParams and "SET TIME ZONE $1" gets 'syntax error at or near "$1" at character 15'
21:57 Re: PQexecParams and "SET TIME ZONE $1" gets 'syntax error at or near "$1" at character 15' Pavel Stehule
22:19 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Adrian Klaver
23:35 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Adrian Klaver
23:49 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Greg Sabino Mullane

24 November

00:10 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Bruce Momjian
00:22 Re: Question About Native Support for SQL:2011 Temporal Tables in PostgreSQL Greg Sabino Mullane
00:30 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Greg Sabino Mullane
00:57 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Bruce Momjian
01:14 Re: Question About Native Support for SQL:2011 Temporal Tables in PostgreSQL Tom Lane
01:19 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Adrian Klaver
01:50 Version upgrades and replication Gianni Ceccarelli
02:24 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Ron Johnson
03:39 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Bruce Momjian
06:20 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
06:28 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Adrian Klaver
08:04 Re: CVE-2024-10979 Vulnerability Impact on PostgreSQL 11.10 Ron Johnson
22:05 Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Subhash Udata
22:18 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Adrian Klaver
22:36 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Subhash Udata
22:41 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Adrian Klaver
22:47 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Ron Johnson
22:49 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Ron Johnson
22:51 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Subhash Udata
22:57 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Ron Johnson
23:03 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Subhash Udata
23:04 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Christophe Pettus
23:06 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Christophe Pettus
23:15 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Ron Johnson
23:16 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Subhash Udata

25 November

01:54 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Christophe Pettus
03:00 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Ron Johnson
03:58 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Adrian Klaver
04:15 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Ron Johnson
08:15 JDBC using REFERENCES Arbol One
08:15 JDBC using REFERENCES Arbol One
08:19 Re: JDBC using REFERENCES David G. Johnston
08:21 Re: JDBC using REFERENCES Rob Sargent
08:22 Re: JDBC using REFERENCES David G. Johnston
11:39 Pg_basebackup failed or completed? jayesh thakare
12:08 Error creating materialized view Shaun Robinson
12:30 Unique key constraint Issue shashidhar Reddy
13:51 Re: Unique key constraint Issue ajit wangkhem
14:08 Re: Pg_basebackup failed or completed? ajit wangkhem
14:44 Re: Unique key constraint Issue shashidhar Reddy
14:57 Re: Unique key constraint Issue ajit wangkhem
14:58 Re: Error creating materialized view David Mullineux
15:36 Re: Error creating materialized view Shaun Robinson
15:48 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Ilya Anfimov
18:54 Re: Error creating materialized view Laurenz Albe
22:00 Re: Unique key constraint Issue Adrian Klaver
22:02 Re: Unique key constraint Issue Tom Lane

26 November

01:59 Re: License question Christophe Pettus
04:47 RE: License question Clay Jackson (cjackson)
05:52 Re: License question Adrian Klaver
07:05 Re: License question Ron Johnson
07:20 RE: License question Clay Jackson (cjackson)
07:40 Re: License question Alan Hodgson
07:42 Re: License question Alan Hodgson
08:48 Re: Database stats ( pg_stat_database.stats_reset ) get reset on daily basis - why? Steeve Boulanger
09:07 Re: Unique key constraint Issue shashidhar Reddy
10:08 Re: Questions on Upgrading PostgreSQL from 15.0 to 15.9 and Setting Up Streaming Replication Subhash Udata
11:36 Re: Unique key constraint Issue Adrian Klaver
12:04 Re: License question prashant sinha
12:12 Re: License question Christophe Pettus
12:36 DB Switchover using repmgr--Error jayakumar s
12:46 Re: License question prashant sinha
15:59 PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Paul Foerster
16:10 Re: DB Switchover using repmgr--Error Paul Foerster
17:34 change JSON serialization for BIGINT? Tim McLaughlin
17:36 Re: change JSON serialization for BIGINT? Victor Yegorov
19:07 Re: change JSON serialization for BIGINT? Tim McLaughlin
22:45 Re: License question Bruce Momjian
22:49 Re: License question Adrian Klaver
22:56 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Adrian Klaver

27 November

01:02 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Paul Foerster
03:25 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Tom Lane
08:31 Re: Unique key constraint Issue shashidhar Reddy
08:32 Re: Unique key constraint Issue shashidhar Reddy
12:17 Re: DB Switchover using repmgr--Error jayakumar s
13:22 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Paul Foerster
18:05 Re: Validating check constraints without a table scan? Philip Couling
20:14 Re: Customize psql prompt to show current_role Raphael Salguero Aragón
20:45 Re: Customize psql prompt to show current_role Dominique Devienne

28 November

00:52 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Tom Lane
01:01 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Alvaro Herrera
03:54 uninstalling postgresql 13 on ubuntu 22.04? Richard Welty
04:10 Re: uninstalling postgresql 13 on ubuntu 22.04? Ray O'Donnell
04:51 Re: uninstalling postgresql 13 on ubuntu 22.04? Adrian Klaver
07:13 Re: uninstalling postgresql 13 on ubuntu 22.04? Rob Sargent
12:00 Link error on Release mode Igor Korot
20:35 ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE Bertrand Mamasam
22:15 Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE Tom Lane
23:29 Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE Bertrand Mamasam

29 November

00:25 Delete Query slowdown Slave database. Sreejith P
00:51 Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE Tom Lane
04:35 Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE Tom Lane
05:13 Re: ERROR wrong varnullingrels (b 3) (expected (b)) with LEFT JOIN LATERAL and CTE Bertrand Mamasam
07:31 Find out the version of the server Igor Korot
12:58 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Paul Foerster
22:12 Re: Find out the version of the server Adrian Klaver
23:15 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Alvaro Herrera

30 November

01:24 Re: Find out the version of the server Adrian Klaver
01:57 Re: Find out the version of the server Igor Korot
02:03 Re: Find out the version of the server Tom Lane
02:24 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Paul Foerster
02:46 Re: Find out the version of the server Igor Korot
07:34 Errors when restoring backup created by pg_dumpall PopeRigby
07:44 Re: Errors when restoring backup created by pg_dumpall Ron Johnson
07:47 Re: Errors when restoring backup created by pg_dumpall Adrian Klaver
13:41 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Alvaro Herrera
14:44 Re: PostgreSQL 15.10 update corrective action for ATTACH PARTITION/DETACH PARTITION Paul Foerster
19:18 Regarding logical slots allocation with logical rw Durgamahesh Manne