pgsql-general - February 2023

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)
Advanced Search

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28

Feb. 1, 2023

Thread Author Time
How to create a new operator inpg for spec data type? jacktby@gmail.com 05:40
Re: Best Open Source OS for Postgresql Tony Shelver 06:19
Re: How to create a new operator inpg for spec data type? Erik Wienhold 06:37
Re: Best Open Source OS for Postgresql Brad White 06:39
Re: Best Open Source OS for Postgresql Brent Wood 06:45
invisible commit question for sync replication qihua wu 06:52
Re: invisible commit question for sync replication Julien Rouhaud 07:11
Re: invisible commit question for sync replication David G. Johnston 07:21
Re: invisible commit question for sync replication qihua wu 08:05
Re: How could I elog the tupleTableSlot to the fronted terminal? Kyotaro Horiguchi 08:20
Re: invisible commit question for sync replication Laurenz Albe 08:38
Re: invisible commit question for sync replication qihua wu 09:25
database postgres not found Matthias Apitz 10:33
38.10.6. Composite-Type Arguments C-language function code demo works for int, but not for numeric. jian he 10:36
Re: database postgres not found Erik Wienhold 11:54
moving a database to a new 15.1 server Matthias Apitz 12:24
Re: moving a database to a new 15.1 server Thomas Kellerer 12:35
Re: moving a database to a new 15.1 server Erik Wienhold 12:38
pg_rewind and replication user Wiwwo Staff 14:09
Re: pg_rewind and replication user Mateusz Henicz 14:37
Re: 38.10.6. Composite-Type Arguments C-language function code demo works for int, but not for numeric. Tom Lane 15:05
Re: Best Open Source OS for Postgresql Wim Bertels 15:21
Re: A Small psql Suggestion Matt Zagrabelny 15:25
Re: Best Open Source OS for Postgresql Marc Millas 15:39
Re: Best Open Source OS for Postgresql Marc Millas 15:54
Re: A Small psql Suggestion hubert depesz lubaczewski 16:04
Re: Best Open Source OS for Postgresql Jeffrey Walton 16:05
Re: Best Open Source OS for Postgresql Adrian Klaver 16:25
New to PostgreSQL - looking for query writing tools Troy Sherven 16:43
Re: New to PostgreSQL - looking for query writing tools Robin Tang 17:00
Re: Best Open Source OS for Postgresql Bob Jolliffe 17:22
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 18:15
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches David G. Johnston 18:26
VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches) Dimitrios Apostolou 18:27
Re: Sequence vs UUID veem v 18:34
Re: VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches) David G. Johnston 18:45
Re: VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches) Christophe Pettus 18:47
Re: Sequence vs UUID Kirk Wolak 18:47
Re: Best Open Source OS for Postgresql Adrian Klaver 18:53
Re: VACUUM vs VACUUM FULL (was: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches) Tom Lane 18:56
"SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? Ron 20:00
Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? Rodrigo Luna 20:06
Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? David G. Johnston 20:06
Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? Tom Lane 20:10
Re: FATAL: database "xxx" does not exist when it does Siddharth Jain 20:13
Re: FATAL: database "xxx" does not exist when it does Rodrigo Luna 20:15
Re: "SELECT FROM foo" acts like "SELECT COUNT(*) FROM foo"? David G. Johnston 20:18
Re: FATAL: database "xxx" does not exist when it does Rodrigo Luna 20:19
Re: FATAL: database "xxx" does not exist when it does Tom Lane 20:45

Feb. 2, 2023

Thread Author Time
Re: pgBackrest Error : authentication method 10 not supported Daulat 06:45
How to write a new tuple into page? jacktby@gmail.com 06:57
Re: New to PostgreSQL - looking for query writing tools Giovanni Biscontini 07:34
Re-2: New to PostgreSQL - looking for query writing tools Sacha Kerres 07:51
Re: Re-2: New to PostgreSQL - looking for query writing tools Brent Wood 08:08
Re: Re-2: New to PostgreSQL - looking for query writing tools Jiten Kumar Shah 08:50
Re: pgBackrest Error : authentication method 10 not supported Magnus Hagander 09:27
Re: Re-2: New to PostgreSQL - looking for query writing tools AR 11:27
Re: pgBackrest Error : authentication method 10 not supported Daulat 11:37
From Clause Conditional Zahir Lalani 12:54
Re: pgBackrest Error : authentication method 10 not supported Magnus Hagander 14:59
Re: Sequence vs UUID Miles Elam 15:16
Re: Sequence vs UUID Benedict Holland 15:22
Re: From Clause Conditional Erik Wienhold 15:28
Re: From Clause Conditional Tom Lane 15:29
Re: Sequence vs UUID veem v 19:47
Re: Logical Replication - "invalid ordering of speculative insertion changes" Joe Wildish 20:11
Re: Sequence vs UUID Peter J. Holzer 23:11
Re: Sequence vs UUID Ron 23:17
Re: Sequence vs UUID Benedict Holland 23:26

Feb. 3, 2023

Thread Author Time
Re: Support logical replication of DDLs Peter Smith 00:41
Re: Sequence vs UUID Rob Sargent 02:07
Re: Support logical replication of DDLs Alvaro Herrera 10:21
Re: Support logical replication of DDLs 📎 Ajin Cherian 13:27
Re: Sequence vs UUID Miles Elam 15:35
Fwd: Sequence vs UUID Dominique Devienne 15:58
Re: Sequence vs UUID veem v 16:47
Re: Sequence vs UUID Dominique Devienne 17:36

Feb. 4, 2023

Thread Author Time
Switching identity column to serial Erik Wienhold 00:54
Re: Switching identity column to serial Erik Wienhold 01:05
Re: Switching identity column to serial Ron 04:41
Re: Switching identity column to serial Ron 04:42
Re: Switching identity column to serial Erik Wienhold 20:55

Feb. 5, 2023

Thread Author Time
Re: Support logical replication of DDLs Peter Smith 20:49
Slow down dev database transactions/second for testing? Richard Brockie 22:17
Re: Slow down dev database transactions/second for testing? Erik Wienhold 23:05
Question regarding UTF-8 data and "C" collation on definition of field of table Dionisis Kontominas 23:08
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Tom Lane 23:24
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Dionisis Kontominas 23:36

Feb. 6, 2023

Thread Author Time
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Tom Lane 00:19
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Dionisis Kontominas 00:48
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Ron 00:57
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Dionisis Kontominas 01:07
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Peter Geoghegan 01:14
Re: Support logical replication of DDLs Peter Smith 01:16
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Tom Lane 01:30
Re: Slow down dev database transactions/second for testing? Richard Brockie 03:58
Re: Support logical replication of DDLs 📎 Ajin Cherian 07:07
Understanding years part of Interval Marcos Pegoraro 11:20
Re: Support logical replication of DDLs 📎 vignesh C 11:32
Re: Understanding years part of Interval Erik Wienhold 13:59
ALTER COLUMN to change GENERATED ALWAYS AS expression? Philip Semanchuk 17:04
Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch 17:17
Re: Understanding years part of Interval Marcos Pegoraro 17:33
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Thomas Kellerer 17:43
plpgsql: ambiguous column reference in ON CONFLICT clause Torsten Förtsch 17:46
Re: plpgsql: ambiguous column reference in ON CONFLICT clause Adrian Klaver 17:50
Re: plpgsql: ambiguous column reference in ON CONFLICT clause David G. Johnston 18:02
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch 18:03
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch 18:11
Re: plpgsql: ambiguous column reference in ON CONFLICT clause Pavel Stehule 18:26
Re: Sequence vs UUID veem v 18:31
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Peter J. Holzer 19:04
Re: Sequence vs UUID Julian Backes 19:04
Re: Sequence vs UUID Peter J. Holzer 19:22
Re: Understanding years part of Interval Erik Wienhold 19:29

Feb. 7, 2023

Thread Author Time
Language options for GIN index support functions Phillip Diffley 02:48
Re: Language options for GIN index support functions Pavel Stehule 05:12
Re: ALTER COLUMN to change GENERATED ALWAYS AS expression? Laurenz Albe 08:30
Re: Logical Replication - "invalid ordering of speculative insertion changes" Rahila Syed 09:05
Too coarse predicate locks granularity for B+ tree indexes Rinat Shigapov 10:23
Re: Too coarse predicate locks granularity for B+ tree indexes Laurenz Albe 10:29
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch 10:43
PostgreSQL Joseph Kennedy 11:02
Re: Too coarse predicate locks granularity for B+ tree indexes Rinat Shigapov 11:08
Re: PostgreSQL Thomas Kellerer 11:10
Re: Too coarse predicate locks granularity for B+ tree indexes Thomas Munro 11:10
Re: PostgreSQL Giovanni Biscontini 11:15
Re: PostgreSQL Joseph Kennedy 11:36
ERROR: deadlock detected Matthias Apitz 11:46
Re: Understanding years part of Interval Marcos Pegoraro 12:00
Re: Too coarse predicate locks granularity for B+ tree indexes Rinat Shigapov 12:00
Re: Support logical replication of DDLs vignesh C 12:05
Re: ERROR: deadlock detected Torsten Förtsch 12:16
Re: PostgreSQL Giovanni Biscontini 13:19
Re: ALTER COLUMN to change GENERATED ALWAYS AS expression? Philip Semanchuk 14:09
Re: PostgreSQL Laurenz Albe 14:34
Re: ERROR: deadlock detected Laurenz Albe 14:37
Re: PostgreSQL Joseph Kennedy 14:46
Re: Sequence vs UUID Merlin Moncure 14:47
Re: ALTER COLUMN to change GENERATED ALWAYS AS expression? Adrian Klaver 15:06
Re: Sequence vs UUID Dominique Devienne 16:07
Re: Too coarse predicate locks granularity for B+ tree indexes Andrey Borodin 16:24
Re: A Small psql Suggestion Raymond Brinzer 16:44
Re: ALTER COLUMN to change GENERATED ALWAYS AS expression? Ron 18:40
Re: ALTER COLUMN to change GENERATED ALWAYS AS expression? Laurenz Albe 19:00
Re: ALTER COLUMN to change GENERATED ALWAYS AS expression? Tom Lane 19:00
Re: ALTER COLUMN to change GENERATED ALWAYS AS expression? Ron 19:05
Re: ALTER COLUMN to change GENERATED ALWAYS AS expression? Ron 19:06
Re: PostgreSQL Peter J. Holzer 21:42
Re: Too coarse predicate locks granularity for B+ tree indexes Thomas Munro 21:44
Re: Too coarse predicate locks granularity for B+ tree indexes 📎 Thomas Munro 21:51
Need help debugging slow logical replication 📎 sunyucong@gmail.com 23:38
Re: PostgreSQL Brad White 23:42
How do a user-defined function that returns a table executes a query? Katsuya Okizaki 23:49
Re: How do a user-defined function that returns a table executes a query? David G. Johnston 23:50

Feb. 8, 2023

Thread Author Time
Re: A Small psql Suggestion Brad White 00:00
Re: A Small psql Suggestion Adrian Klaver 00:05
Quoting issue from ODBC Brad White 00:10
Re: PostgreSQL Brad White 00:11
Re: A Small psql Suggestion Brad White 00:14
Opportunity for clarification on ODBC options Brad White 00:18
Re: Quoting issue from ODBC Adrian Klaver 00:19
Re: Need help debugging slow logical replication Justin 00:19
Fwd: Quoting issue from ODBC Brad White 00:19
Re: Quoting issue from ODBC David G. Johnston 00:23
Re: Quoting issue from ODBC Rob Sargent 00:32
Re: PostgreSQL Stephen Frost 00:35
Re: Need help debugging slow logical replication sunyucong@gmail.com 01:07
Re: Need help debugging slow logical replication Justin 01:32
Re: Need help debugging slow logical replication sunyucong@gmail.com 02:10
Re: Quoting issue from ODBC Brad White 04:20
Re: Need help debugging slow logical replication 📎 sunyucong@gmail.com 05:13
Re: Sequence vs UUID veem v 09:18
Re: How do a user-defined function that returns a table executes a query? Laurenz Albe 10:18
Re: Switching identity column to serial Peter Eisentraut 11:03
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Peter Eisentraut 11:07
Re: Sequence vs UUID Peter J. Holzer 11:33
Index scan for PK constraint validation Philippe VIEGAS 12:09
Re: Get the sequence name corresponding to a GENERATED { ALWAYS | BY DEFAULT } AS IDENTITY column Sebastien Flaesch 13:00
Re: Index scan for PK constraint validation David G. Johnston 13:25
How to create directory format backup Andrus 15:00
Re: Need help debugging slow logical replication sunyucong@gmail.com 16:27
Re: How to create directory format backup hubert depesz lubaczewski 17:59
How to verify postrgresql download on windows? Ali M. 19:03
How to use the BRIN index properly? Siddharth Jain 19:51
Re: Sequence vs UUID Kirk Wolak 19:55
Re: How to use the BRIN index properly? Siddharth Jain 19:58
Re: How to use the BRIN index properly? Ron 20:27
Re: Sequence vs UUID Miles Elam 20:27
Re: How to create directory format backup Andrus 20:59
Re: How to use the BRIN index properly? Siddharth Jain 21:17
Re: How to create directory format backup Erik Wienhold 21:17
Re: How to use the BRIN index properly? Christophe Pettus 21:20
Re: How to create directory format backup Andrus 21:37
Re: How to use the BRIN index properly? Siddharth Jain 22:14
Re: How to use the BRIN index properly? Christophe Pettus 22:16
Re: Support logical replication of DDLs Peter Smith 22:16
Re: How to use the BRIN index properly? Ron 22:20
Re: How to create directory format backup Erik Wienhold 22:45
Re: How do a user-defined function that returns a table executes a query? Katsuya Okizaki 22:54

Browse Archives

Prev | Next
Jump to day: 1 2 3 4 5 6 7 8 9 10 11 12 13 14 15 16 17 18 19 20 21 22 23 24 25 26 27 28