[go: up one dir, main page]

pgsql-general since 2023-01-27 00:00

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

Jan. 27, 2023

Thread Author Time
Re: Sequence vs UUID Ron 00:48
Re: Sequence vs UUID G Hasse 01:54
timestamptz, local time in the future, and Don't do it wiki Max Nikulin 12:12
PostgreSQL DBA training Matthias Apitz 12:44
Re: Sequence vs UUID Rob Sargent 14:55
Re: timestamptz, local time in the future, and Don't do it wiki Peter J. Holzer 18:03
Indexes mysteriously change to LOG Rumpi Gravenstein 20:23
Re: Indexes mysteriously change to ON ONLY Rumpi Gravenstein 20:24
Re: Indexes mysteriously change to LOG Adrian Klaver 20:34
Re: Indexes mysteriously change to LOG Rumpi Gravenstein 20:51
Re: Indexes mysteriously change to ON ONLY Tom Lane 20:53
nextval per counted Rob Sargent 20:59
Re: Indexes mysteriously change to ON ONLY Rumpi Gravenstein 21:01
Re: Indexes mysteriously change to ON ONLY Christophe Pettus 21:07
Re: Indexes mysteriously change to ON ONLY Tom Lane 21:16
Re: nextval per counted David G. Johnston 21:20
Re: nextval per counted Rob Sargent 21:25
Re: Indexes mysteriously change to ON ONLY Rumpi Gravenstein 21:30
Re: nextval per counted David G. Johnston 21:31
Re: nextval per counted Rob Sargent 21:41

Jan. 28, 2023

Thread Author Time
Re: Indexes mysteriously change to ON ONLY Ron 02:26
Why is this SELECT evaluated? Miles Elam 19:29
Re: Why is this SELECT evaluated? Erik Wienhold 20:34
Re: Sequence vs UUID Erik Wienhold 20:39
Re: Why is this SELECT evaluated? Christophe Pettus 20:55

Jan. 29, 2023

Thread Author Time
Re: Sequence vs UUID Benedict Holland 01:44
Re: Sequence vs UUID Ron 02:01
Re: Sequence vs UUID Miles Elam 03:28
Re: Sequence vs UUID Ron 04:02
Re: Sequence vs UUID Miles Elam 05:02

Jan. 30, 2023

Thread Author Time
How to control pg_catalog results for each users? hirose shigeo (廣瀬 繁雄 □SWC○ACT) 05:00
Re: How to control pg_catalog results for each users? David G. Johnston 05:23
Re: How to control pg_catalog results for each users? Tom Lane 05:48
Re: How to control pg_catalog results for each users? Laurenz Albe 08:41
Question on Logical Replication Venkata B Nagothi 08:53
Re: Postgres upgrade 12 - issues with OIDs Venkata B Nagothi 08:54
Does statement_timeout apply to commit? qihua wu 09:10
Re: Sequence vs UUID veem v 11:29
alter table impact on view Marc Millas 12:13
Re: alter table impact on view David Rowley 12:52
Re: How to control pg_catalog results for each users? Ron 13:18
Re: Does statement_timeout apply to commit? Laurenz Albe 13:19
Re: alter table impact on view Marc Millas 14:15
How could I elog the tupleTableSlot to the fronted terminal? jacktby@gmail.com 15:23
Re: Sequence vs UUID veem v 16:11
Re: Sequence vs UUID Dominique Devienne 16:37
Re: Sequence vs UUID Tom Lane 16:48
Re: How could I elog the tupleTableSlot to the fronted terminal? Alvaro Herrera 17:44
Re: Sequence vs UUID veem v 19:43
Re: Sequence vs UUID Adrian Klaver 19:46
Re: Sequence vs UUID Ron 21:58

Jan. 31, 2023

Thread Author Time
How is timeout implemented in postgresql? qihua wu 01:35
Re: How is timeout implemented in postgresql? David G. Johnston 01:50
any wait event for a commit in sync replication? qihua wu 07:35
Best Open Source OS for Postgresql Giovanni Biscontini 08:02
Re: any wait event for a commit in sync replication? qihua wu 08:22
Re: How to control pg_catalog results for each users? hirose shigeo (廣瀬 繁雄 □SWC○ACT) 09:31
Re: timestamptz, local time in the future, and Don't do it wiki Max Nikulin 11:32
Re: Best Open Source OS for Postgresql Surya Widyanto 11:59
Re: Best Open Source OS for Postgresql hubert depesz lubaczewski 12:06
Re: Best Open Source OS for Postgresql hubert depesz lubaczewski 12:23
Re: toast useless Marcos Pegoraro 12:34
Download file from COPY ... TO with pgadmin Marco Lechner 13:02
Re: Best Open Source OS for Postgresql Marc Millas 13:09
Re: Best Open Source OS for Postgresql hubert depesz lubaczewski 13:21
pgBackrest Error : authentication method 10 not supported Daulat 13:57
Re: Download file from COPY ... TO with pgadmin Erik Wienhold 13:58
Re: pgBackrest Error : authentication method 10 not supported Magnus Hagander 14:02
AW: Download file from COPY ... TO with pgadmin Marco Lechner 14:17
Re: toast useless Laurenz Albe 15:03
SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 15:07
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 15:16
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches David G. Johnston 15:20
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Tom Lane 15:28
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 15:40
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Christophe Pettus 15:42
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches David G. Johnston 15:43
Re: Re: How could I elog the tupleTableSlot to the fronted terminal? jacktby@gmail.com 16:12
A Small psql Suggestion Raymond Brinzer 16:17
RE: [EXT] DBeaver session populating pg_stat_activity.backend_xmin Dirschel, Steve 16:29
Re: Download file from COPY ... TO with pgadmin Adrian Klaver 16:30
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Dimitrios Apostolou 16:32
Re: Best Open Source OS for Postgresql Adrian Klaver 16:38
Re: SELECT * FROM huge_table LIMIT 10; Why does it take more than 10 min to complete, with cold caches Tom Lane 17:15
Logical Replication - "invalid ordering of speculative insertion changes" Joe Wildish 18:10

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

Browse Archives

Prev | Next