pgsql-hackers before 2024-06-28 00:00

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

(enter a message-id to go directly to that message)

Advanced Search

Browse Archives

Prev | Next

June 26, 2024

Thread	Author	Time
psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..	André Verwijs	00:35
Re: improve predefined roles documentation	David G. Johnston	00:38
Re: speed up a logical replica setup	Euler Taveira	00:50
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..	Tom Lane	00:52
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..	David G. Johnston	00:52
Re: [PATCH] Add ACL (Access Control List) acronym	David G. Johnston	00:59
Re: [PATCH] Add ACL (Access Control List) acronym	David G. Johnston	01:16
Re: Should we document how column DEFAULT expressions work?	David G. Johnston	01:30
Re: New standby_slot_names GUC in PG 17	Masahiko Sawada	01:39
Re: speed up a logical replica setup	Euler Taveira	01:51
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..	Bruce Momjian	01:54
Re: Injection point locking 📎	Michael Paquier	01:56
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	02:36
RE: Conflict detection and logging in logical replication 📎	Zhijie Hou (Fujitsu)	02:57
Re: Improve the connection failure error messages	Peter Smith	03:45
Re: CI, macports, darwin version problems 📎	Thomas Munro	03:58
Re: speed up a logical replica setup	Amit Kapila	03:58
Re: CI, macports, darwin version problems	Tom Lane	04:04
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..	Tom Lane	04:06
RE: New standby_slot_names GUC in PG 17 📎	Zhijie Hou (Fujitsu)	04:17
Re: New standby_slot_names GUC in PG 17	Bertrand Drouvot	04:49
Re: Should we document how column DEFAULT expressions work?	David Rowley	04:50
Reg: Alternate way of hashing database role passwords	M, Anbazhagan	05:00
Re: Should we document how column DEFAULT expressions work?	Tom Lane	05:12
Re: Should we document how column DEFAULT expressions work?	David G. Johnston	05:35
Re: cost delay brainstorming	Andy Fan	05:39
Re: Fix possible overflow of pg_stat DSA's refcnt	Michael Paquier	05:39
Re: Addressing SECURITY DEFINER Function Vulnerabilities in PostgreSQL Extensions	Ashutosh Sharma	05:49
Re: Should we document how column DEFAULT expressions work?	David G. Johnston	06:00
RE: speed up a logical replica setup 📎	Hayato Kuroda (Fujitsu)	06:04
Re: Improve the connection failure error messages	Daniel Gustafsson	06:05
Re: New standby_slot_names GUC in PG 17	Amit Kapila	06:09
Re: New standby_slot_names GUC in PG 17	Michael Paquier	06:24
Re: New standby_slot_names GUC in PG 17	Bertrand Drouvot	06:42
RE: Improve EXPLAIN output for multicolumn B-Tree Index	Masahiro.Ikeda	06:45
Re: Fix possible overflow of pg_stat DSA's refcnt	Anthonin Bonnefoy	06:48
RE: Improve EXPLAIN output for multicolumn B-Tree Index	Masahiro.Ikeda	06:51
RE: Improve EXPLAIN output for multicolumn B-Tree Index	Masahiro.Ikeda	07:25
Re: Backporting BackgroundPsql	Heikki Linnakangas	07:34
RE: Improve EXPLAIN output for multicolumn B-Tree Index	Masahiro.Ikeda	07:44
Re: pg_createsubscriber: drop pre-existing subscriptions from the converted node	vignesh C	08:42
Re: Proposal: Document ABI Compatibility	Laurenz Albe	08:48
Re: walsender.c comment with no context is hard to understand	vignesh C	09:00
Re: Wrong security context for deferred triggers?	Laurenz Albe	09:02
Re: Conflict Detection and Resolution	Amit Kapila	09:02
Re: Showing applied extended statistics in explain Part 2 📎	Tatsuro Yamada	09:06
Re: Logical Replication of sequences 📎	Peter Smith	09:10
RE: New standby_slot_names GUC in PG 17 📎	Zhijie Hou (Fujitsu)	09:15
Re: RFC: Additional Directory for Extensions	Jelte Fennema-Nio	09:30
Re: RFC: Additional Directory for Extensions	Jelte Fennema-Nio	09:36
RE: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE	Masahiro.Ikeda	10:22
Re: Avoid orphaned objects dependencies, take 3 📎	Bertrand Drouvot	10:24
RE: Parallel Bitmap Heap Scan reports per-worker stats in EXPLAIN ANALYZE	Masahiro.Ikeda	10:27
pgindent exit status if a file encounters an error 📎	Ashutosh Bapat	10:37
Re: remaining sql/json patches	Alexander Lakhin	11:00
Re: pg_createsubscriber: drop pre-existing subscriptions from the converted node	Amit Kapila	11:02
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎	Aleksander Alekseev	11:09
Re: Adding OLD/NEW support to RETURNING 📎	Dean Rasheed	11:18
Re: pgindent exit status if a file encounters an error	Andrew Dunstan	11:23
Re: long-standing data loss bug in initial sync of logical replication	Tomas Vondra	11:27
Re: Buildfarm animal caiman showing a plperl test issue with newer Perl versions	Andrew Dunstan	11:35
Re: Backporting BackgroundPsql	Robert Haas	11:54
Re: ON ERROR in json_query and the like 📎	Amit Langote	12:10
Re: Pgoutput not capturing the generated columns 📎	Shubham Khanna	12:12
Re: Pgoutput not capturing the generated columns	Shubham Khanna	12:16
Re: New standby_slot_names GUC in PG 17	Bertrand Drouvot	12:30
Re: pgsql: Add more SQL/JSON constructor functions	Amit Langote	12:38
Re: New standby_slot_names GUC in PG 17	Amit Kapila	12:51
doc: modify the comment in function libpqrcv_check_conninfo() 📎	ikedarintarof	12:52
Re: pgindent exit status if a file encounters an error 📎	Ashutosh Bapat	13:28
Re: Should we document how column DEFAULT expressions work?	Alvaro Herrera	13:36
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..	Bruce Momjian	13:59
Re: [PATCH] Add ACL (Access Control List) acronym	Nathan Bossart	14:23
Re: doc: modify the comment in function libpqrcv_check_conninfo()	Jelte Fennema-Nio	14:36
Re: Wrong security context for deferred triggers?	David G. Johnston	14:38
Re: improve predefined roles documentation	Robert Haas	14:40
Re: pgsql: Add more SQL/JSON constructor functions	jian he	14:46
Re: [PATCH] Add ACL (Access Control List) acronym	Joel Jacobson	14:52
Re: [PATCH] Add ACL (Access Control List) acronym	David G. Johnston	14:58
Incremental Sort Cost Estimation Instability 📎	Andrei Lepikhov	15:00
Re: pgindent exit status if a file encounters an error	Tom Lane	15:24
Re: [PATCH] Add ACL (Access Control List) acronym	Nathan Bossart	15:47
Re: improve predefined roles documentation	Nathan Bossart	15:48
Re: Wrong security context for deferred triggers?	Laurenz Albe	15:53
Re: Reg: Alternate way of hashing database role passwords	Tom Lane	16:11
Re: libpq: Fix lots of discrepancies in PQtrace	Nathan Bossart	16:28
Re: libpq: Fix lots of discrepancies in PQtrace	Alvaro Herrera	16:36
Re: [PATCH] Add ACL (Access Control List) acronym	David G. Johnston	16:54
Re: Reg: Alternate way of hashing database role passwords	Robert Haas	16:59
Re: Proposal: Document ABI Compatibility	David E. Wheeler	17:12
Re: psql (PostgreSQL) 17beta2 (Debian 17~beta2-1.pgdg+~20240625.1534.g23c5a0e) Failed to retrieve data from the server..	Bruce Momjian	17:14
Re: Reg: Alternate way of hashing database role passwords	Tom Lane	17:39
Re: POC, WIP: OR-clause support for indexes	Nikolay Shaplov	17:41
JIT causes core dump during error recovery	Tom Lane	18:09
Re: Patch bug: Fix jsonpath .* on Arrays 📎	David E. Wheeler	18:16
Re: JIT causes core dump during error recovery	Ranier Vilela	18:28
thread-safety: gmtime_r(), localtime_r() 📎	Peter Eisentraut	18:42
Re: JIT causes core dump during error recovery	Tom Lane	18:42
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15)	Noah Misch	18:58
Re: JIT causes core dump during error recovery 📎	Tom Lane	19:13
Re: Proposal: Document ABI Compatibility 📎	David E. Wheeler	19:14
Adding skip scan (including MDAM style range skip scan) to nbtree 📎	Peter Geoghegan	19:16
Re: Proposal: Document ABI Compatibility	David E. Wheeler	19:20
Re: speed up a logical replica setup	Noah Misch	19:21
Re: Proposal: Document ABI Compatibility 📎	David E. Wheeler	19:23
Re: New standby_slot_names GUC in PG 17	Peter Eisentraut	19:32
Re: JIT causes core dump during error recovery	Tom Lane	20:01
Re: libpq: Fix lots of discrepancies in PQtrace	Jelte Fennema-Nio	20:02
Re: POC, WIP: OR-clause support for indexes	Robert Haas	20:19
Re: Recommended books for admin	Tom Browder	20:39
Re: TruncateMultiXact() bugs	Heikki Linnakangas	20:55
Re: Should we document how column DEFAULT expressions work?	David Rowley	22:58
Re: Should we document how column DEFAULT expressions work?	David G. Johnston	23:14
Re: Should we document how column DEFAULT expressions work?	David Rowley	23:19
Re: Should we document how column DEFAULT expressions work?	Tom Lane	23:38
Re: Should we document how column DEFAULT expressions work?	David Rowley	23:54

June 27, 2024

Thread	Author	Time
Re: Should we document how column DEFAULT expressions work?	Tom Lane	00:11
Re: Should we document how column DEFAULT expressions work?	David Rowley	00:34
Re: Fix possible overflow of pg_stat DSA's refcnt	Michael Paquier	00:48
Re: Add LSN <-> time conversion functionality	Melanie Plageman	01:35
Re: Vacuum statistics	Masahiko Sawada	01:39
Re: New standby_slot_names GUC in PG 17	Masahiko Sawada	01:44
Re: Add LSN <-> time conversion functionality 📎	Melanie Plageman	02:04
Re: Add LSN <-> time conversion functionality	Melanie Plageman	02:18
Re: long-standing data loss bug in initial sync of logical replication	Amit Kapila	03:08
Re: Conflict Detection and Resolution 📎	Nisha Moond	03:14
Re: Document NULL	Yugo NAGATA	03:14
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Yugo NAGATA	03:17
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Yugo NAGATA	04:01
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Michael Paquier	04:04
Re: thread-safety: gmtime_r(), localtime_r()	Stepan Neretin	04:47
Re: Conflict Detection and Resolution	shveta malik	04:50
Re: Patch bug: Fix jsonpath .* on Arrays	Stepan Neretin	04:53
Re: Track the amount of time waiting due to cost_delay	Masahiko Sawada	05:17
Re: Pgoutput not capturing the generated columns 📎	Shubham Khanna	05:29
Adminpack removal	Philippe BEAUDOIN	05:34
Re: libpq: Fix lots of discrepancies in PQtrace	Michael Paquier	05:39
Re: walsender.c comment with no context is hard to understand	Michael Paquier	05:43
Re: thread-safety: gmtime_r(), localtime_r()	Peter Eisentraut	06:09
Re: Adminpack removal	Hannu Krosing	06:12
RE: pg_createsubscriber: drop pre-existing subscriptions from the converted node 📎	Hayato Kuroda (Fujitsu)	06:17
Re: pgsql: Add more SQL/JSON constructor functions	jian he	06:25
Re: CI, macports, darwin version problems 📎	Thomas Munro	06:32
Re: doc: modify the comment in function libpqrcv_check_conninfo() 📎	ikedarintarof	07:09
ClientRead on ROLLABACK	Simone Giusso	07:11
Re: libpq: Fix lots of discrepancies in PQtrace 📎	Jelte Fennema-Nio	08:03
Re: Patch bug: Fix jsonpath .* on Arrays	Michael Paquier	08:17
Re: doc: modify the comment in function libpqrcv_check_conninfo()	Jelte Fennema-Nio	08:18
Re: Adminpack removal	Matthias van de Meent	08:38
Re: [PATCH] Add ACL (Access Control List) acronym 📎	Joel Jacobson	08:42
Re: Vacuum statistics	Andrei Zubkov	08:52
Doc: fix track_io_timing description to mention pg_stat_io 📎	Hajime.Matsunaga	09:06
Re: Doc: fix track_io_timing description to mention pg_stat_io	Kashif Zeeshan	09:08
Re: Pgoutput not capturing the generated columns 📎	Peter Smith	09:10
[PATCH] Fix docs to use canonical links 📎	Joel Jacobson	09:27
Re: Doc: fix track_io_timing description to mention pg_stat_io	Hajime.Matsunaga	09:33
Re: pgsql: Add more SQL/JSON constructor functions 📎	Amit Langote	09:57
Re: doc: modify the comment in function libpqrcv_check_conninfo() 📎	ikedarintarof	10:27
Re: Conflict Detection and Resolution 📎	shveta malik	10:33
Re: Support a wildcard in backtrace_functions 📎	Jelte Fennema-Nio	10:43
Re: XID formatting and SLRU refactorings (was: Add 64-bit XIDs into PostgreSQL 15) 📎	Aleksander Alekseev	10:45
Re: Doc: fix track_io_timing description to mention pg_stat_io	Melanie Plageman	11:29
Re: pgsql: Add more SQL/JSON constructor functions 📎	Amit Langote	11:48
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c)	Ranier Vilela	11:48
Re: Avoid incomplete copy string (src/backend/access/transam/xlog.c) 📎	Ranier Vilela	11:50
Re: Should we document how column DEFAULT expressions work?	Peter Eisentraut	11:57
Re: Doc: fix track_io_timing description to mention pg_stat_io	Nazir Bilal Yavuz	12:00
Re: SQL/JSON query functions context_item doc entry and type requirement 📎	Amit Langote	12:01
Re: SQL Property Graph Queries (SQL/PGQ) 📎	Peter Eisentraut	12:31
Custom type's modifiers	Marthin Laubscher	14:33
Re: Patch bug: Fix jsonpath .* on Arrays	David E. Wheeler	15:05
Re: Custom type's modifiers	Tom Lane	15:06
Re: ClientRead on ROLLABACK	Tom Lane	15:21
Re: ClientRead on ROLLABACK	Jelte Fennema-Nio	15:26
Re: ClientRead on ROLLABACK	Simone G.	15:34
Re: Custom type's modifiers	Marthin Laubscher	15:49
Re: Custom type's modifiers	David G. Johnston	16:12
Re: JIT causes core dump during error recovery 📎	Tom Lane	16:18
Re: Custom type's modifiers	Tom Lane	16:24
Re: JIT causes core dump during error recovery	Ranier Vilela	16:31
Re: Backporting BackgroundPsql	Heikki Linnakangas	16:35
Re: JIT causes core dump during error recovery	Tom Lane	16:59
Re: Custom type's modifiers	Marthin Laubscher	17:01
Re: Custom type's modifiers	Tom Lane	17:05
Re: Visibility bug with prepared transaction with subtransactions on standby	Heikki Linnakangas	18:35
Is missing LOGIN Event on Trigger Firing Matrix ?	Marcos Pegoraro	18:40
Re: Apparent bug in WAL summarizer process (hung state)	Israel Barth Rubio	19:31
Re: Is missing LOGIN Event on Trigger Firing Matrix ?	Andrew Dunstan	19:39
Re: POC, WIP: OR-clause support for indexes	Alena Rybakina	19:56
Re: Is missing LOGIN Event on Trigger Firing Matrix ?	David G. Johnston	20:00
Re: Improve EXPLAIN output for multicolumn B-Tree Index	Peter Geoghegan	20:01
Re: POC, WIP: OR-clause support for indexes	Alena Rybakina	20:06
Re: Improve EXPLAIN output for multicolumn B-Tree Index	Jelte Fennema-Nio	20:46
Re: Proposal: Document ABI Compatibility	Jeremy Schneider	21:48
Re: SQL:2011 application time 📎	Paul Jungwirth	21:56
Inline non-SQL SRFs using SupportRequestSimplify 📎	Paul Jungwirth	22:01
Re: Proposal: Document ABI Compatibility 📎	David E. Wheeler	22:07
Re: Improve EXPLAIN output for multicolumn B-Tree Index	Peter Geoghegan	22:40
Re: walsender.c comment with no context is hard to understand 📎	Peter Smith	23:44

June 28, 2024

Thread	Author	Time
Re: Virtual generated columns	jian he	00:00

Browse Archives

Prev | Next