pgsql-bugs - June 2022

If you find a bug, please use the bug reporting form.

Search the Archives

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

Browse Archives

Prev | Next

June 1, 2022

Thread Author Time
BUG #17506: Issue with the downloading site PG Bug reporting form 12:03
BUG #17507: rpm packages provide wrong postgresql version PG Bug reporting form 19:49

June 2, 2022

Thread Author Time
BUG #17508: ja.po for pg_ctl has an obvious mistake PG Bug reporting form 02:02
Re: BUG #17449: Disk space not released Jeff Janes 02:51
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier 05:39
Re: How is this possible "publication does not exist" Amit Kapila 09:51
Unable to make use of "deep" JSONB index Shaheed Haque 10:27
Re: How is this possible "publication does not exist" operations i 11:00
Re: How is this possible "publication does not exist" operations i 11:01
Re: How is this possible "publication does not exist" operations i 11:12
Re: BUG #17508: ja.po for pg_ctl has an obvious mistake Daniel Gustafsson 13:34
Re: Unable to make use of "deep" JSONB index Tom Lane 14:31
Re: Unable to make use of "deep" JSONB index Shaheed Haque 15:51
Error installing Stack Builder on Windows 64bit Collins, John D. 19:14

June 3, 2022

Thread Author Time
Re: BUG #17506: Issue with the downloading site Semab Tariq 02:21
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error 📎 Kyotaro Horiguchi 08:56
Re: Error installing Stack Builder on Windows 64bit John Naylor 10:01
Re: Error installing Stack Builder on Windows 64bit Sandeep Thakkar 14:13
RE: Error installing Stack Builder on Windows 64bit Collins, John D. 16:16
Re: Extension pg_trgm, permissions and pg_dump order Nathan Bossart 18:17
Re: psql 15beta1 does not print notices on the console until transaction completes 📎 Fabien COELHO 18:25
Postgres do not allow to create many tables with more than 63-symbols prefix 📎 Andrey Lepikhov 19:02

June 6, 2022

Thread Author Time
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier 02:15
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Kyotaro Horiguchi 06:11
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 06:30
BUG #17510: cache lookup failed for type PG Bug reporting form 06:51
RE: BUG #17421: Core dump in ECPGdo() when calling PostgreSQL API from 32-bit client for RHEL8 hirose.masay-01@fujitsu.com 09:50
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Robert Haas 14:30
Re: BUG #17421: Core dump in ECPGdo() when calling PostgreSQL API from 32-bit client for RHEL8 📎 Tom Lane 15:01
Re: BUG #17510: cache lookup failed for type Tom Lane 16:40
BUG #17511: Inconsistent permissions on some information_schema tables PG Bug reporting form 18:10
Re: BUG #17511: Inconsistent permissions on some information_schema tables David G. Johnston 19:59
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error David G. Johnston 20:05
Re: BUG #17511: Inconsistent permissions on some information_schema tables Tom Lane 21:18
Re: BUG #17511: Inconsistent permissions on some information_schema tables Kirk Parker 22:12
BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 PG Bug reporting form 22:36

June 7, 2022

Thread Author Time
Re: BUG #17511: Inconsistent permissions on some information_schema tables Tom Lane 00:20
Re: BUG #17511: Inconsistent permissions on some information_schema tables Kirk Parker 00:40
RE: BUG #17421: Core dump in ECPGdo() when calling PostgreSQL API from 32-bit client for RHEL8 hirose.masay-01@fujitsu.com 01:14
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier 02:53
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 David Rowley 03:17
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 Aleš Zelený 08:29
Re: psql 15beta1 does not print notices on the console until transaction completes Peter Eisentraut 12:05
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 Aleš Zelený 17:04
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 Tom Lane 19:07
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 Aleš Zelený 20:26
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 📎 David Rowley 23:39
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 Tom Lane 23:43

June 8, 2022

Thread Author Time
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 David Rowley 00:41
Re: psql 15beta1 does not print notices on the console until transaction completes Fabien COELHO 10:16
Fallout from 'Make type "name" collation-aware' and tg_table_name Christoph Berg 13:07
Using PQexecQuery in pipeline mode produces unexpected Close messages Daniele Varrazzo 13:59
Re: Fallout from 'Make type "name" collation-aware' and tg_table_name Tom Lane 14:05
Re: Fallout from 'Make type "name" collation-aware' and tg_table_name 📎 Christoph Berg 14:12
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Alvaro Herrera 15:08
BUG #17513: recompressing already-compressed data via VACUUM FULL or CLUSTER does not work PG Bug reporting form 19:41
Re: BUG #17512: Process running query fails with SIGSEV - nodeMemoize.c:349 Aleš Zelený 20:11
Re: BUG #17513: recompressing already-compressed data via VACUUM FULL or CLUSTER does not work David G. Johnston 22:59

June 9, 2022

Thread Author Time
Re: BUG #17513: recompressing already-compressed data via VACUUM FULL or CLUSTER does not work Michael Paquier 01:10
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 05:17
BUG #17514: Application with embedded SQL crashes when executing EXEC SQL PREPARE PG Bug reporting form 06:40
Re: psql 15beta1 does not print notices on the console until transaction completes Peter Eisentraut 07:38
Re: BUG #17514: Application with embedded SQL crashes when executing EXEC SQL PREPARE 📎 Tom Lane 17:01
BUG #17515: Change in behaviour of a composite type within a domain PG Bug reporting form 20:42

June 10, 2022

Thread Author Time
RE: BUG #17514: Application with embedded SQL crashes when executing EXEC SQL PREPARE okano.naoki@fujitsu.com 05:09
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages 📎 Kyotaro Horiguchi 06:25
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Kyotaro Horiguchi 06:33
Re: BUG #17515: Change in behaviour of a composite type within a domain Tom Lane 13:51
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Tom Lane 15:41
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Tom Lane 16:12
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier 19:45
Re: Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Tom Lane 19:47

June 11, 2022

Thread Author Time
Re: Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier 07:35

June 12, 2022

Thread Author Time
Re: Unable to make use of "deep" JSONB index Shaheed Haque 09:34
Re: Unable to make use of "deep" JSONB index Erik Rijkers 10:53
Re: Unable to make use of "deep" JSONB index Shaheed Haque 11:12
Re: Unable to make use of "deep" JSONB index Shaheed Haque 19:31
Re: Unable to make use of "deep" JSONB index Jeff Janes 21:24
Re: Unable to make use of "deep" JSONB index Tom Lane 21:55
Re: Unable to make use of "deep" JSONB index Shaheed Haque 23:51

June 13, 2022

Thread Author Time
Re: Unable to make use of "deep" JSONB index David G. Johnston 00:04
Re: Unable to make use of "deep" JSONB index Jeff Janes 02:23
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 03:45
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error 📎 Michael Paquier 06:45
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Kyotaro Horiguchi 07:07
Re: Unable to make use of "deep" JSONB index Erik Rijkers 10:41
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Álvaro Herrera 11:09
DELETE deletes more than one rows when LIMIT is used in the USING clause Onur Tirtir 14:13
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Tom Lane 14:52
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Tom Lane 14:54
Re: DELETE deletes more than one rows when LIMIT is used in the USING clause Tom Lane 15:16
Re: Unable to make use of "deep" JSONB index Shaheed Haque 15:59

June 14, 2022

Thread Author Time
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier 01:31
websearch_to_tsquery fails to transform compound words from a thesaurus dictionary Jean Gabriel 14:38
BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records. PG Bug reporting form 15:17
Re: BUG #17514: Application with embedded SQL crashes when executing EXEC SQL PREPARE Tom Lane 22:18
Re: pg_upgrade (12->14) fails on aggregate 📎 Justin Pryzby 23:09

June 15, 2022

Thread Author Time
Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still commits after client-side error Michael Paquier 06:09
psql --on-error-stop (Re: BUG #17504: psql --single-transaction -vON_ERROR_STOP=1 still) commits after client-side error Christoph Berg 09:13
COPY TO CSV produces data that is incompatible/unsafe for \COPY FROM CSV Svante Richter 12:16
Re: Extension pg_trgm, permissions and pg_dump order Nathan Bossart 17:35
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages 📎 Alvaro Herrera 18:26
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Tom Lane 18:56
Re: pg_upgrade (12->14) fails on aggregate Tom Lane 19:32

June 16, 2022

Thread Author Time
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Kyotaro Horiguchi 01:34
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Kyotaro Horiguchi 01:41
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages 📎 Kyotaro Horiguchi 03:07
Re: Extension pg_trgm, permissions and pg_dump order 📎 Noah Misch 05:42
"SELECT COUNT(*) FROM" still causing issues (deadlock) in PostgreSQL 14.3? Marco Boeringa 06:10
BUG #17519: I get a segmentation fault when querying in parallel. PG Bug reporting form 06:17
BUG #17520: 14.4 release notes doc is out of order PG Bug reporting form 13:25
Re: BUG #17519: I get a segmentation fault when querying in parallel. Tom Lane 14:19
Re: BUG #17520: 14.4 release notes doc is out of order Anbazhagan M 14:57
Trouble with pgpool-II-pcp packaging Jon SCHEWE 22:31

June 17, 2022

Thread Author Time
Re: pg_upgrade (12->14) fails on aggregate 📎 Justin Pryzby 02:01
BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 PG Bug reporting form 12:03
Re: pg_upgrade (12->14) fails on aggregate Robert Haas 13:07
Re: pg_upgrade (12->14) fails on aggregate Pavel Stehule 13:30
Re: pg_upgrade (12->14) fails on aggregate Tom Lane 14:14
Issue with SSL and password protected keys in DER/PK8 format Derek Zasiewski 17:03
Wanted: Replacement Text Case Conversion in User Name Maps William Gould 18:20
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages 📎 Alvaro Herrera 18:31

June 18, 2022

Thread Author Time
BUG #17523: Postgresql Kerberos PAM authentication PG Bug reporting form 08:19

June 20, 2022

Thread Author Time
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Michael Paquier 03:05
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Michael Paquier 03:15
BUG #17524: Increase in WAL size due to logical replication with publication contain a table with low activity. PG Bug reporting form 11:19
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Peter Eisentraut 12:22
Re: Issue with SSL and password protected keys in DER/PK8 format Magnus Hagander 21:21

June 21, 2022

Thread Author Time
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Kyotaro Horiguchi 00:27
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Kyotaro Horiguchi 02:42
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages 📎 Kyotaro Horiguchi 05:56
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Kyotaro Horiguchi 05:59
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages Kyotaro Horiguchi 06:05
Re: Using PQexecQuery in pipeline mode produces unexpected Close messages 📎 Kyotaro Horiguchi 08:46
Re: BUG #17524: Increase in WAL size due to logical replication with publication contain a table with low activity. Amit Kapila 13:38
Re: Extension pg_trgm, permissions and pg_dump order Nathan Bossart 17:56
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Jacob Champion 18:34
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 📎 Jacob Champion 20:07
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Jacob Champion 20:15
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Tom Lane 21:15
BUG #17525: Range partition by date won't allow the use of a date that is the upper bound PG Bug reporting form 23:11
RE: BUG #17525: Range partition by date won't allow the use of a date that is the upper bound Allen Sutton 23:31
Re: BUG #17525: Range partition by date won't allow the use of a date that is the upper bound Christophe Pettus 23:33

June 22, 2022

Thread Author Time
BUG #17526: PG_DUMP is not outputting "CREATE SCHEMA" statements when an extension is assigned to a schema PG Bug reporting form 01:59
BUG #17527: Timestamp bind variable using 0000-00-00, 0000/00/00 PG Bug reporting form 02:27
Re: Extension pg_trgm, permissions and pg_dump order Noah Misch 03:37
BUG #17528: ERROR: could not access status of transaction 1997627701 PG Bug reporting form 05:34
Re: BUG #17526: PG_DUMP is not outputting "CREATE SCHEMA" statements when an extension is assigned to a schema David G. Johnston 13:53
Re: BUG #17526: PG_DUMP is not outputting "CREATE SCHEMA" statements when an extension is assigned to a schema Tom Lane 14:01
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Jacob Champion 16:11
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Tom Lane 16:16
Re: Extension pg_trgm, permissions and pg_dump order Nathan Bossart 16:25
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Jacob Champion 16:28
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Tom Lane 16:31
BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command PG Bug reporting form 20:37
Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command Kevin Wolf 20:46
BUG #17530: pg_dump comment on triggers is "off" by comparison to all of the other objects... PG Bug reporting form 23:05
Re: pg_upgrade (12->14) fails on aggregate 📎 Justin Pryzby 23:58

June 23, 2022

Thread Author Time
Re: Postgres do not allow to create many tables with more than 63-symbols prefix Masahiko Sawada 02:03
Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command David G. Johnston 03:45
Re: BUG #17530: pg_dump comment on triggers is "off" by comparison to all of the other objects... David G. Johnston 04:02
Re: BUG #17530: pg_dump comment on triggers is "off" by comparison to all of the other objects... Julien Rouhaud 04:11
Re: BUG #17530: pg_dump comment on triggers is "off" by comparison to all of the other objects... David G. Johnston 04:27
Re: BUG #17530: pg_dump comment on triggers is "off" by comparison to all of the other objects... Tom Lane 04:29
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Michael Paquier 06:00
Re: BUG #17524: Increase in WAL size due to logical replication with publication contain a table with low activity. Raman Kumar 06:33
Re: BUG #17528: ERROR: could not access status of transaction 1997627701 Andrey Borodin 12:39
Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command Kevin Wolf 15:58
dropdb utility command prompts for password despite valid .pgpass file in home directory Alan Lin 19:21
Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command Jeff Janes 19:27
Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command Kevin Wolf 19:34
Re: BUG #17529: SQL Error [57P01]: FATAL: terminating connection due to administrator command Jeff Janes 19:55

June 24, 2022

Thread Author Time
Re: Errors on CREATE TABLE IF NOT EXISTS 📎 Andrey Lepikhov 07:21
Re: dropdb utility command prompts for password despite valid .pgpass file in home directory Julien Rouhaud 08:40
Re: BUG #17522: While using --with-ssl=openssl and PG_TEST_EXTRA='ssl' options, SSL test fails on OpenBSD 7.1 Peter Eisentraut 11:11
BUG #17531: Push Notification Many Times Show. PG Bug reporting form 12:00
Re: BUG #17531: Push Notification Many Times Show. David G. Johnston 13:08
Re: pg_upgrade (12->14) fails on aggregate Andrey Borodin 18:43
Re: pg_upgrade (12->14) fails on aggregate 📎 Justin Pryzby 20:28

June 25, 2022

Thread Author Time
Re: pg_upgrade (12->14) fails on aggregate Andrey Borodin 10:34
BUG #17532: Prepared statements and insert on conflict can fail on the 6th execution PG Bug reporting form 15:05
BUG #17533: run benchmarksql test failed PG Bug reporting form 15:38
Re: BUG #17532: Prepared statements and insert on conflict can fail on the 6th execution David G. Johnston 15:56
server closed the connection unexpectedly - bug report 📎 Jiří Ledvinka 16:00
Re: server closed the connection unexpectedly - bug report David G. Johnston 21:11
Re: server closed the connection unexpectedly - bug report David G. Johnston 21:22
Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records. Dave Cramer 23:15
Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records. David G. Johnston 23:51

June 27, 2022

Thread Author Time
RE: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records. Krier, Bob 16:36
Re: BUG #17518: Getting Error "new multixact has more than one updating member" when trying to delete records. David G. Johnston 17:11
Auto-vacuum timing out and preventing connections David Johansen 20:38
Re: pg_upgrade (12->14) fails on aggregate 📎 Justin Pryzby 23:30

June 28, 2022

Thread Author Time
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Justin Pryzby 00:37
Re: Auto-vacuum timing out and preventing connections Julien Rouhaud 04:42
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end 📎 Masahiko Sawada 06:58
Re: BUG #17385: "RESET transaction_isolation" inside serializable transaction causes Assert at the transaction end Michael Paquier 07:58
BUG #17534: 'tablespace' option crushes 'create database' query with 'permission denied' message PG Bug reporting form 08:39
Re: Auto-vacuum timing out and preventing connections David Johansen 17:24
Re: BUG #17534: 'tablespace' option crushes 'create database' query with 'permission denied' message Tom Lane 18:08
Re: Auto-vacuum timing out and preventing connections Jeff Janes 19:31

Browse Archives

Prev | Next