pgsql-general - September 2025

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. 1, 2025

Thread Author Time
Re: In-order pg_dump (or in-order COPY TO) 📎 Adrian Klaver 17:24
Re: In-order pg_dump (or in-order COPY TO) Tom Lane 17:54
Re: In-order pg_dump (or in-order COPY TO) Adrian Klaver 19:02

Sept. 3, 2025

Thread Author Time
Q: limit the length of log file entries? Albrecht Dreß 15:40
Re: Q: limit the length of log file entries? Adrian Klaver 15:56
Re: Q: limit the length of log file entries? Tom Lane 19:07

Sept. 4, 2025

Thread Author Time
Re: In-order pg_dump (or in-order COPY TO) Álvaro Herrera 12:02
Re: In-order pg_dump (or in-order COPY TO) Adrian Klaver 14:49
Latest patches break one of our unit-test, related to RLS Dominique Devienne 15:03
Re: Latest patches break one of our unit-test, related to RLS Adrian Klaver 15:12
Re: Latest patches break one of our unit-test, related to RLS Laurenz Albe 15:18
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 15:28
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 15:31
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 15:45
Re: Q: limit the length of log file entries? Albrecht Dreß 15:48
Re: Q: limit the length of log file entries? Albrecht Dreß 15:48
Re: Q: limit the length of log file entries? Adrian Klaver 15:54
Re: In-order pg_dump (or in-order COPY TO) Dimitrios Apostolou 16:08
Debugging query performance in postgres veem v 16:57
Re: In-order pg_dump (or in-order COPY TO) Achilleas Mantzios 16:59
Re: Debugging query performance in postgres Adrian Klaver 17:49
Re: Q: limit the length of log file entries? Adrian Klaver 18:21
Re: Q: limit the length of log file entries? Albrecht Dreß 19:43
Re: Q: limit the length of log file entries? Adrian Klaver 20:16
Re: Debugging query performance in postgres veem v 20:32
Re: Debugging query performance in postgres Adrian Klaver 21:20
Re: Debugging query performance in postgres Ron Johnson 23:21

Sept. 5, 2025

Thread Author Time
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 08:19
Re: Latest patches break one of our unit-test, related to RLS Laurenz Albe 12:19
Re: Latest patches break one of our unit-test, related to RLS Laurenz Albe 12:19
PostgreSQL include directive in plpgsql language PL/pgSQL PALAYRET Jacques 13:13
Re: PostgreSQL include directive in plpgsql language PL/pgSQL David G. Johnston 13:21
Re: PostgreSQL include directive in plpgsql language PL/pgSQL Tom Lane 13:56
Re: PostgreSQL include directive in plpgsql language PL/pgSQL Merlin Moncure 16:21
Re: PostgreSQL include directive in plpgsql language PL/pgSQL Ron Johnson 16:36
LWLock SerializableFinishedList Alec Cozens 17:02
Re: LWLock SerializableFinishedList Justin 18:00

Sept. 8, 2025

Thread Author Time
Re: PostgreSQL include directive in plpgsql language PL/pgSQL PALAYRET Jacques 09:37
RE: LWLock SerializableFinishedList 📎 Alec Cozens 10:27
Re: PostgreSQL include directive in plpgsql language PL/pgSQL Greg Sabino Mullane 13:13
Fast switchover legrand legrand 15:03
RE: LWLock SerializableFinishedList Alec Cozens 16:04
Re: Fast switchover Ron Johnson 16:10
Re: PostgreSQL include directive in plpgsql language PL/pgSQL Merlin Moncure 16:31
RE: Fast switchover Klaus Darilion 16:37
Re: Fast switchover Ron Johnson 16:48
Re: Fast switchover Laurenz Albe 19:54
RE: Fast switchover Klaus Darilion 20:31

Sept. 9, 2025

Thread Author Time
Re : Fast switchover legrand legrand 05:07
Re: Re : Fast switchover Laurenz Albe 05:22
MVCC and all that... Ellen Allhatatlan 16:27
Re: MVCC and all that... Rob Sargent 16:40
Re: MVCC and all that... Merlin Moncure 17:10
Re: MVCC and all that... Ellen Allhatatlan 17:31
Re: MVCC and all that... Ellen Allhatatlan 17:57
Re: LWLock SerializableFinishedList Justin 19:31
Re: LWLock SerializableFinishedList Justin 19:42
Re: MVCC and all that... Merlin Moncure 22:55

Sept. 10, 2025

Thread Author Time
Re: MVCC and all that... Justin 00:41
Re: MVCC and all that... Ron Johnson 01:11
Re: MVCC and all that... Justin 01:36
Re: MVCC and all that... Ellen Allhatatlan 07:41
Re: MVCC and all that... Adrian Klaver 14:46
Re: MVCC and all that... Ellen Allhatatlan 15:08
Re: MVCC and all that... Ron Johnson 15:11
Re: MVCC and all that... Adrian Klaver 15:15
Re: MVCC and all that... Justin 15:29
Re: MVCC and all that... Ron Johnson 15:55
Re: MVCC and all that... Álvaro Herrera 17:28
Re: MVCC and all that... Merlin Moncure 18:54
Re: MVCC and all that... Nico Williams 21:28
Re: MVCC and all that... Justin 22:20
Re: MVCC and all that... Nico Williams 23:07

Sept. 11, 2025

Thread Author Time
Re: MVCC and all that... Ron Johnson 00:11
Re: MVCC and all that... Ellen Allhatatlan 11:38
[Announcement] ​A Bitemporal Solution for PostgreSQL (Beta) Lorusso Domenico 15:08
Re: [Announcement] ​A Bitemporal Solution for PostgreSQL (Beta) Lorusso Domenico 15:09
Re: MVCC and all that... Merlin Moncure 16:52
Re: MVCC and all that... Pavel Stehule 17:55

Sept. 12, 2025

Thread Author Time
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 12:22
Re: Latest patches break one of our unit-test, related to RLS Laurenz Albe 12:45
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 13:11
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 13:24
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 13:29
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 13:34
Re: Latest patches break one of our unit-test, related to RLS jian he 13:53
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 13:57
Re: Latest patches break one of our unit-test, related to RLS Tom Lane 14:07
Re: Latest patches break one of our unit-test, related to RLS Dominique Devienne 14:28
Re: Latest patches break one of our unit-test, related to RLS Álvaro Herrera 16:32
Re: MVCC and all that... Ellen Allhatatlan 19:16
Re: Latest patches break one of our unit-test, related to RLS 📎 Laurenz Albe 23:34

Sept. 13, 2025

Thread Author Time
Re: Latest patches break one of our unit-test, related to RLS Tom Lane 00:12
Re: Latest patches break one of our unit-test, related to RLS Laurenz Albe 01:17
Re: Latest patches break one of our unit-test, related to RLS Tom Lane 01:53
Re: MVCC and all that... Justin 01:54
Re: Latest patches break one of our unit-test, related to RLS 📎 Laurenz Albe 09:11
Re: Latest patches break one of our unit-test, related to RLS Tom Lane 21:00
Re: Latest patches break one of our unit-test, related to RLS Laurenz Albe 22:38

Sept. 14, 2025

Thread Author Time
Silent data corruption in PostgreSQL 17 - how to detect it proactively? Pawel Kudzia 08:30
Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively? Laurenz Albe 10:35
Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively? Pawel Kudzia 12:47
Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively? Laurenz Albe 13:40

Sept. 15, 2025

Thread Author Time
How to use \restrict or \unrestirct in python ma lz 07:16
Re: How to use \restrict or \unrestirct in python David G. Johnston 12:32
Re: How to use \restrict or \unrestirct in python Adrian Klaver 14:17
Re: Latest patches break one of our unit-test, related to RLS Michael Paquier 23:59

Sept. 16, 2025

Thread Author Time
EDB Windows Installer on Windows Server 2025 Daniel Westermann (DWE) 09:09
encoding problem while inictial copy in logical replication Jaime Casanova 11:01
Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively? Vladlen Popolitov 13:25
Re: EDB Windows Installer on Windows Server 2025 Adrian Klaver 15:14
Re: Silent data corruption in PostgreSQL 17 - how to detect it proactively? Merlin Moncure 16:41
Re: encoding problem while inictial copy in logical replication Adrian Klaver 17:44
Re: EDB Windows Installer on Windows Server 2025 Adrian Klaver 17:55
Re: EDB Windows Installer on Windows Server 2025 Ron Johnson 19:01
pg_restore scan R Wahyudi 22:25
Re: pg_restore scan Adrian Klaver 22:36

Sept. 17, 2025

Thread Author Time
Re: pg_restore scan R Wahyudi 00:54
Re: pg_restore scan Ron Johnson 01:02
Re: pg_restore scan Adrian Klaver 02:25
Re: pg_restore scan R Wahyudi 02:50
Re: pg_restore scan Ron Johnson 03:47
Re: EDB Windows Installer on Windows Server 2025 Daniel Westermann (DWE) 05:46

Sept. 18, 2025

Thread Author Time
How do I specify the NetworkService user to the postgres installer. HORDER Philip 09:58
Index (primary key) corrupt? Wim Rouquart 12:25
Re: pg_restore scan R Wahyudi 12:58
Re: pg_restore scan Ron Johnson 14:09
Re: Index (primary key) corrupt? Ron Johnson 15:50
Re: pg_restore scan Adrian Klaver 15:54
Re: Index (primary key) corrupt? Adrian Klaver 16:01
Re: How do I specify the NetworkService user to the postgres installer. Adrian Klaver 16:08
Re: pg_restore scan R Wahyudi 21:36
Re: pg_restore scan Adrian Klaver 21:45
Re: pg_restore scan R Wahyudi 23:45

Sept. 19, 2025

Thread Author Time
PostgreSQL Account and Object Timestamp Logging 張宸瑋 02:55
Re: PostgreSQL Account and Object Timestamp Logging David G. Johnston 03:07
Re: pg_restore scan Ron Johnson 04:06
Re: PostgreSQL Account and Object Timestamp Logging Dominique Devienne 08:13
RE: Index (primary key) corrupt? Wim Rouquart 09:29
RE: Index (primary key) corrupt? Wim Rouquart 09:40
Client/server certificates verification support on Android platform Mathieu Pellerin 10:18
Re: Client/server certificates verification support on Android platform Daniel Gustafsson 10:44
Re: Index (primary key) corrupt? Adrian Klaver 13:04
RE: Index (primary key) corrupt? Wim Rouquart 13:23
Re: Index (primary key) corrupt? Adrian Klaver 15:50

Sept. 20, 2025

Thread Author Time
Re: Index (primary key) corrupt? Adrian Klaver 15:00
Re: Index (primary key) corrupt? David G. Johnston 15:23
Re: Index (primary key) corrupt? Rob Sargent 16:26
Re: Index (primary key) corrupt? Adrian Klaver 16:58
Re: Index (primary key) corrupt? Rob Sargent 20:16

Sept. 21, 2025

Thread Author Time
OAuth validator Adrian Klaver 20:27

Sept. 23, 2025

Thread Author Time
Quick questions about postgres name? Dan Mahoney (Gushi) 04:06
Re: Quick questions about postgres name? Pavel Stehule 04:16
Re: Quick questions about postgres name? Tom Lane 04:17
Re: Quick questions about postgres name? Adrian Klaver 04:19
Re: Quick questions about postgres name? Álvaro Herrera 10:30
executing Linux commands from the PostgreSQL server Matthias Apitz 11:55
Re: executing Linux commands from the PostgreSQL server hubert depesz lubaczewski 13:05
Re: Quick questions about postgres name? Achilleas Mantzios 14:03
Re: executing Linux commands from the PostgreSQL server Juan Rodrigo Alejandro Burgos Mella 19:01
How do I upsert depending on a second table? Samuel Marks 20:36
Re: How do I upsert depending on a second table? Adrian Klaver 20:52
Re: How do I upsert depending on a second table? Samuel Marks 20:56
Re: How do I upsert depending on a second table? Adrian Klaver 20:57
Re: How do I upsert depending on a second table? Adrian Klaver 21:00
Re: How do I upsert depending on a second table? Samuel Marks 21:02
Re: How do I upsert depending on a second table? David G. Johnston 21:31

Sept. 24, 2025

Thread Author Time
Re: How do I upsert depending on a second table? Juan Rodrigo Alejandro Burgos Mella 00:25
Re: How do I upsert depending on a second table? Samuel Marks 04:19
Re: How do I upsert depending on a second table? Adrian Klaver 04:31
Re: How do I upsert depending on a second table? Juan Rodrigo Alejandro Burgos Mella 06:44
Query on Patch and Upgrade History in PostgreSQL loganathan P 08:17
Re: Query on Patch and Upgrade History in PostgreSQL Laurenz Albe 10:37
Re: Query on Patch and Upgrade History in PostgreSQL Ron Johnson 13:11
Re: Query on Patch and Upgrade History in PostgreSQL Adrian Klaver 15:06
Re: How do I upsert depending on a second table? Adrian Klaver 15:13
Re: Clarification on Role Access Rights to Table Indexes 📎 Nathan Bossart 15:58
Re: Clarification on Role Access Rights to Table Indexes Tom Lane 16:13
Re: How do I upsert depending on a second table? David G. Johnston 16:51
Re: Clarification on Role Access Rights to Table Indexes 📎 Nathan Bossart 16:52
Re: How do I upsert depending on a second table? Samuel Marks 17:02
Re: How do I upsert depending on a second table? Adrian Klaver 18:28
Index rebuilding strategy Siraj G 20:42
Re: Index rebuilding strategy Alban Hertroys 20:50
Re: Index rebuilding strategy Laurenz Albe 21:52
Re: How do I upsert depending on a second table? Adrian Klaver 23:03
Re: Index rebuilding strategy Ron Johnson 23:34

Sept. 25, 2025

Thread Author Time
Enquiry about Percona TDE performance issues Ashish Mukherjee 11:36
Compatibility Informations Roberto Gallesio 15:38
Additional options for COPY from Bryan Sayer 18:49
Re: Enquiry about Percona TDE performance issues Adrian Klaver 19:10
Re: Compatibility Informations Adrian Klaver 19:13
Re: Additional options for COPY from Ron Johnson 20:08
Re: Additional options for COPY from Brent Wood 20:10
Re: Additional options for COPY from David G. Johnston 20:18
Re: Additional options for COPY from Adrian Klaver 20:21

Sept. 26, 2025

Thread Author Time
Re: Enquiry about Percona TDE performance issues Ashish Mukherjee 03:57
Re: Compatibility Informations Laurenz Albe 05:25
Correct query for monitor veem v 10:23
pgpass file in postresql.auto.conf? Dan Mahoney (Gushi) 12:05

Browse Archives

Prev | Next