pgsql-general since 2023-02-08 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
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. 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 [email protected] 01:07
Re: Need help debugging slow logical replication Justin 01:32
Re: Need help debugging slow logical replication [email protected] 02:10
Re: Quoting issue from ODBC Brad White 04:20
Re: Need help debugging slow logical replication 📎 [email protected] 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 [email protected] 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
Re: How to create directory format backup Tom Lane 22:57
Re: How do a user-defined function that returns a table executes a query? Katsuya Okizaki 23:10

Feb. 9, 2023

Thread Author Time
Boyer-Moore string searching in LIKE, ILIKE, and/or POSITION? Martin L. Buchanan 00:04
Re: Boyer-Moore string searching in LIKE, ILIKE, and/or POSITION? David Rowley 01:30
Re: Boyer-Moore string searching in LIKE, ILIKE, and/or POSITION? Tom Lane 01:49
Re: Boyer-Moore string searching in LIKE, ILIKE, and/or POSITION? David Rowley 02:06
Re: Boyer-Moore string searching in LIKE, ILIKE, and/or POSITION? Vladimir Sitnikov 05:41
ERROR: posting list tuple with 2 items cannot be split at offset 17 Paul McGarry 07:53
Re: PostgreSQL Joseph Kennedy 08:54
Re: Support logical replication of DDLs 📎 Ajin Cherian 09:55
Re: Support logical replication of DDLs Alvaro Herrera 10:55
Re: Question regarding UTF-8 data and "C" collation on definition of field of table Jehan-Guillaume de Rorthais 13:49
Using PostgreSQL for service discovery and health-check Dominique Devienne 15:30
WHERE col = ANY($1) extended to 2 or more columns? Dominique Devienne 15:41
Re: PostgreSQL Laurenz Albe 15:42
Concurrency issue with DROP INDEX CONCURRENTLY Kiriakos Georgiou 15:45
Re: Using PostgreSQL for service discovery and health-check David G. Johnston 15:45
Re: WHERE col = ANY($1) extended to 2 or more columns? David G. Johnston 15:51
Re: Using PostgreSQL for service discovery and health-check Dominique Devienne 15:58
Re: WHERE col = ANY($1) extended to 2 or more columns? Dominique Devienne 16:03
Re: Using PostgreSQL for service discovery and health-check Adrian Klaver 16:05
Re: WHERE col = ANY($1) extended to 2 or more columns? Dominique Devienne 16:09
Re: Concurrency issue with DROP INDEX CONCURRENTLY Adrian Klaver 16:15
Re: Using PostgreSQL for service discovery and health-check Dominique Devienne 16:16
Re: WHERE col = ANY($1) extended to 2 or more columns? David G. Johnston 16:17
Re: WHERE col = ANY($1) extended to 2 or more columns? Alban Hertroys 16:28
Re: WHERE col = ANY($1) extended to 2 or more columns? David G. Johnston 16:37
Re: Using PostgreSQL for service discovery and health-check Adrian Klaver 16:51
Re: ERROR: posting list tuple with 2 items cannot be split at offset 17 Adrian Klaver 16:59
Re: ERROR: posting list tuple with 2 items cannot be split at offset 17 Peter Geoghegan 17:27
Re: WHERE col = ANY($1) extended to 2 or more columns? Dominique Devienne 17:35
Re: Using PostgreSQL for service discovery and health-check Dominique Devienne 17:40
Re: Using PostgreSQL for service discovery and health-check Adrian Klaver 17:46
Re: Sequence vs UUID Merlin Moncure 17:50
Re: Using PostgreSQL for service discovery and health-check Adrian Klaver 17:52
delta.io foreign data wrapper Georg Heiler 18:12
Re: Concurrency issue with DROP INDEX CONCURRENTLY Kiriakos Georgiou 19:12
Re: Concurrency issue with DROP INDEX CONCURRENTLY Laurenz Albe 20:16
Re: Quoting issue from ODBC Brad White 22:43
Re: Quoting issue from ODBC Brad White 22:46
valgrind a background worker Jon Erdman 23:05
Re: Quoting issue from ODBC Adrian Klaver 23:10
Re: ERROR: posting list tuple with 2 items cannot be split at offset 17 Paul McGarry 23:55

Feb. 10, 2023

Thread Author Time
Re: Quoting issue from ODBC Brad White 00:27
Re: ERROR: posting list tuple with 2 items cannot be split at offset 17 Peter Geoghegan 01:15
pg_trgm vs. Solr ngram Chris 02:20
Re: pg_trgm vs. Solr ngram Laurenz Albe 03:48
Re: pg_trgm vs. Solr ngram Tom Lane 05:13
Re: pg_trgm vs. Solr ngram Bertrand Mamasam 07:54
Re: WHERE col = ANY($1) extended to 2 or more columns? Alban Hertroys 08:14
Re: How to use the BRIN index properly? GF 10:20
Re: Support logical replication of DDLs Amit Kapila 11:06
Re: Support logical replication of DDLs Masahiko Sawada 14:52
Re: valgrind a background worker Tom Lane 15:03
Re: Support logical replication of DDLs 📎 vignesh C 16:20
Re: Support logical replication of DDLs vignesh C 16:24
PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode" Lawrence, Mike (DTST) 16:28
Re: Support logical replication of DDLs vignesh C 16:31
Re: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode" Adrian Klaver 16:42
RE: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode" Lawrence, Mike (DTST) 17:56
Re: valgrind a background worker Jon Erdman 18:05
Re: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode" Adrian Klaver 18:08
RE: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode" Lawrence, Mike (DTST) 19:47
Re: valgrind a background worker Tom Lane 19:56
Re: PostgreSQL 13.9.3 Uninstall fails with "Unable to initialize any installation mode" Adrian Klaver 20:07
Re: valgrind a background worker Jeffrey Walton 20:58
Re: valgrind a background worker Tom Lane 21:05

Feb. 11, 2023

Thread Author Time
Re: valgrind a background worker Jon Erdman 03:08
How to pass table column values to function Andrus 10:10
Re: How to pass table column values to function Marcos Pegoraro 12:21
Re: How to pass table column values to function jian he 14:16
Re: WHERE col = ANY($1) extended to 2 or more columns? Peter J. Holzer 15:21
Re: WHERE col = ANY($1) extended to 2 or more columns? Peter J. Holzer 22:00

Feb. 12, 2023

Thread Author Time
Re: pg_trgm vs. Solr ngram Christian Ramseyer (mx04) 00:13
Queries running forever, because of wrong rowcount estimate Peter 00:42
psql "\d" no longer working Rob Sargent 09:02
Re: psql "\d" no longer working Georg H. 09:24
pg_dump problem with postgres user ertan.kucukoglu 14:22
Re: pg_dump problem with postgres user David G. Johnston 15:37
Re: psql "\d" no longer working Adrian Klaver 16:19
Re: psql "\d" no longer working Ron 16:49
Re: psql "\d" no longer working Adrian Klaver 17:02
Re: psql "\d" no longer working Rob Sargent 18:58
Re: pg_dump problem with postgres user ertan.kucukoglu 21:10
Re: pg_dump problem with postgres user Adrian Klaver 21:15

Feb. 13, 2023

Thread Author Time
Re: Support logical replication of DDLs Zheng Li 04:20
Re: Support logical replication of DDLs Peter Smith 04:55
[Testcase] Queries running forever, because of wrong rowcount estimate Peter 05:33
Re: Support logical replication of DDLs Alvaro Herrera 09:07
Fwd: Quoting issue from ODBC Brad White 17:11
Re: Quoting issue from ODBC Brad White 17:34
Re: [Testcase] Queries running forever, because of wrong rowcount estimate Tom Lane 17:38
Re: [Testcase] Queries running forever, because of wrong rowcount estimate Peter 18:18
HOWTO? Permissions for user to access a single db Damian Carey 21:45
Re: HOWTO? Permissions for user to access a single db Tom Lane 21:59
Re: HOWTO? Permissions for user to access a single db Damian Carey 22:44
Re: HOWTO? Permissions for user to access a single db Tom Lane 22:54
Re: HOWTO? Permissions for user to access a single db Damian Carey 23:14
Re: HOWTO? Permissions for user to access a single db Rob Sargent 23:41
Re: HOWTO? Permissions for user to access a single db Tom Lane 23:46
Re: HOWTO? Permissions for user to access a single db Adrian Klaver 23:58

Feb. 14, 2023

Thread Author Time
Re: Support logical replication of DDLs Peter Smith 01:43
Re: HOWTO? Permissions for user to access a single db Damian Carey 04:35
Re: HOWTO? Permissions for user to access a single db Rob Sargent 04:40
Re: Support logical replication of DDLs Alvaro Herrera 09:27
Losing my latin on Ordering... Dominique Devienne 09:31
Re: Losing my latin on Ordering... Laurenz Albe 10:23
RE: Support logical replication of DDLs [email protected] 10:28
Re: Support logical replication of DDLs Amit Kapila 11:02
Re: Losing my latin on Ordering... Dominique Devienne 11:17
Re: Losing my latin on Ordering... Alvaro Herrera 11:35
Re: Losing my latin on Ordering... Laurenz Albe 11:40
Re: Losing my latin on Ordering... Dominique Devienne 12:06
Re: Losing my latin on Ordering... Laurenz Albe 12:27
Multi-column index: Which column order Sebastien Flaesch 17:53
[Outcome] Queries running forever, because of wrong rowcount estimate Peter 18:38
Re: Multi-column index: Which column order Erik Wienhold 18:47
pro services list Rob Sargent 20:49
Query plan for "id IS NULL" on PK Ben Chrobot 22:04
Re: Query plan for "id IS NULL" on PK Rob Sargent 22:25
Re: Query plan for "id IS NULL" on PK David G. Johnston 22:30
Re: Query plan for "id IS NULL" on PK Rob Sargent 22:36
Re: Query plan for "id IS NULL" on PK Peter J. Holzer 22:39
Re: Query plan for "id IS NULL" on PK Peter J. Holzer 22:43
Re: Query plan for "id IS NULL" on PK Rob Sargent 22:44
Re: Quoting issue from ODBC Brad White 22:58
Order of rows in simple "select r from table_fn()" Bryn Llewellyn 23:49

Feb. 15, 2023

Thread Author Time
Re: Order of rows in simple "select r from table_fn()" David G. Johnston 00:08
Re: Query plan for "id IS NULL" on PK David Rowley 00:21
Re: Quoting issue from ODBC Adrian Klaver 01:35
RE: Support logical replication of DDLs 📎 [email protected] 03:01
Re: Support logical replication of DDLs Peter Smith 04:00
Re: Query plan for "id IS NULL" on PK Tom Lane 04:11
Re: Support logical replication of DDLs Peter Smith 04:32
Re: Order of rows in simple "select r from table_fn()" Pavel Stehule 04:34
Re: Order of rows in simple "select r from table_fn()" Bryn Llewellyn 05:01
Re: Support logical replication of DDLs Amit Kapila 05:57
Re: Support logical replication of DDLs Amit Kapila 06:50
Re: Support logical replication of DDLs Alvaro Herrera 08:32
Re: Multi-column index: Which column order Laurenz Albe 08:46
Re: Support logical replication of DDLs Amit Kapila 09:51
unresolved external symbol when building on Windows King of Hearts 10:00
Re: unresolved external symbol when building on Windows Andy Y 11:01
Re: Query plan for "id IS NULL" on PK Ron 16:17
Re: Multi-column index: Which column order Ron 16:20
Re: Support logical replication of DDLs 📎 Zheng Li 22:16

Feb. 16, 2023

Thread Author Time
Re: Multi-column index: Which column order Laurenz Albe 03:45
Re: Support logical replication of DDLs Amit Kapila 04:00
Re: Multi-column index: Which column order Ron 04:08
Automatic aggressive vacuum on almost frozen table takes too long Mikhail Balayan 06:57
Re: Support logical replication of DDLs 📎 Ajin Cherian 07:54
Aggressive vacuum frequency on a table Simon Elbaz 09:58
Re: Multi-column index: Which column order Laurenz Albe 10:22
RE: Support logical replication of DDLs [email protected] 13:15
Vacuum full issue Rama Krishnan 13:18

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