pgsql-general since 2023-02-09 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. 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
DELETE trigger, direct or indirect? Dominique Devienne 13:23
Re: Automatic aggressive vacuum on almost frozen table takes too long Adrian Klaver 15:44
Postgres undeterministically uses a bad plan, how to convince it otherwise? cen 15:47
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? David G. Johnston 16:07
Re: DELETE trigger, direct or indirect? Erik Wienhold 16:09
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? Ron 16:15
Re: DELETE trigger, direct or indirect? Adrian Klaver 16:46
Re: Support logical replication of DDLs Jonathan S. Katz 16:48
Re: DELETE trigger, direct or indirect? David G. Johnston 16:55
Re: DELETE trigger, direct or indirect? Adrian Klaver 16:59
Re: DELETE trigger, direct or indirect? Dominique Devienne 17:17
How to avoid Trigger ping/pong / infinite loop Dominique Devienne 17:43
Re: DELETE trigger, direct or indirect? Adrian Klaver 17:51
Re: Support logical replication of DDLs Alvaro Herrera 17:53
Re: How to avoid Trigger ping/pong / infinite loop Adrian Klaver 17:58
Re: Support logical replication of DDLs Alvaro Herrera 18:02
Re: How to avoid Trigger ping/pong / infinite loop Dominique Devienne 18:21
Re: DELETE trigger, direct or indirect? Dominique Devienne 18:28
Re: DELETE trigger, direct or indirect? Brad White 18:46
Re: Support logical replication of DDLs Jonathan S. Katz 19:01
Re: How to avoid Trigger ping/pong / infinite loop David G. Johnston 19:22
Re: Vacuum full issue David G. Johnston 19:28
Re: Vacuum full issue Adrian Klaver 19:29
Re: Support logical replication of DDLs Alvaro Herrera 19:38
Re: Automatic aggressive vacuum on almost frozen table takes too long Peter Geoghegan 19:41
Re: How to avoid Trigger ping/pong / infinite loop David Wheeler 19:42
Re: Support logical replication of DDLs Jonathan S. Katz 19:43
Re: DELETE trigger, direct or indirect? Adrian Klaver 19:45
Re: How to avoid Trigger ping/pong / infinite loop Adrian Klaver 19:55
Re: Support logical replication of DDLs Jonathan S. Katz 21:08
Re: How to avoid Trigger ping/pong / infinite loop Ken Tanzer 22:47

Feb. 17, 2023

Thread Author Time
Re: Automatic aggressive vacuum on almost frozen table takes too long Mikhail Balayan 01:23
Re: Automatic aggressive vacuum on almost frozen table takes too long Mikhail Balayan 01:40
Re: Support logical replication of DDLs Zheng Li 04:13
PostgreSQL configuration in a VM Sebastien Flaesch 08:13
Re: Support logical replication of DDLs Amit Kapila 09:15
Sv: PostgreSQL configuration in a VM Andreas Joseph Krogh 09:48
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? cen 10:30
Re: Support logical replication of DDLs vignesh C 11:04
Re: Postgres undeterministically uses a bad plan, how to convince it otherwise? Marc Millas 13:23
Re: Query plan for "id IS NULL" on PK Ben Chrobot 14:20
Sequential scan faster than index Arthur Ramsey 16:18
Re: Automatic aggressive vacuum on almost frozen table takes too long Peter Geoghegan 21:34

Feb. 18, 2023

Thread Author Time
Hi All, Ryan MYJ 00:00
can't get psql authentication against Active Directory working Tomas Pospisek 14:02
Does Postgres 14 have a query cache? Siddharth Jain 14:46
Re: Does Postgres 14 have a query cache? David G. Johnston 14: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