pgsql-bugs - September 2019

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

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 16 17 18 19 20 22 23 24 25 26 27 28 30

Sept. 1, 2019

Thread Author Time
Re: BUG #15987: Improve REINDEX of all indexes of a table at once Michael Paquier 04:35
Re: BUG #15987: Improve REINDEX of all indexes of a table at once Fabien COELHO 09:45
Re: BUG #15987: Improve REINDEX of all indexes of a table at once Jo Tzschenscher 11:18
Re: BUG #15987: Improve REINDEX of all indexes of a table at once Tom Lane 15:36

Sept. 2, 2019

Thread Author Time
Re: BUG #15984: order of where in() query affects query planer easteregg 09:28
BUG #15989: Cluster unable to open as hot standby after SIGKILL during exclusive backup PG Bug reporting form 13:53
Memory leak in formatting.c 📎 Konstantin Knizhnik 16:52

Sept. 3, 2019

Thread Author Time
Re: Memory leak in formatting.c Michael Paquier 03:33
Re: BUG #15977: Inconsistent behavior in chained transactions Peter Eisentraut 09:54
Re: BUG #15977: Inconsistent behavior in chained transactions Fabien COELHO 10:03
Re: BUG #15977: Inconsistent behavior in chained transactions fn ln 13:27
Re: BUG #15989: Cluster unable to open as hot standby after SIGKILL during exclusive backup Stephen Frost 16:30

Sept. 4, 2019

Thread Author Time
Re: BUG #15977: Inconsistent behavior in chained transactions Andres Freund 07:53
BUG #15990: PROCEDURE throws "SQL Error [XX000]: ERROR: no known snapshots" with PostGIS geometries PG Bug reporting form 10:06
Re: BUG #15990: PROCEDURE throws "SQL Error [XX000]: ERROR: no known snapshots" with PostGIS geometries Andres Freund 10:56
Re: BUG #15977: Inconsistent behavior in chained transactions 📎 fn ln 14:49
Re: BUG #15858: could not stat file - over 4GB 📎 Juan José Santamaría Flecha 21:47

Sept. 5, 2019

Thread Author Time
BUG #15991: Troubles about Management Tools for Postgre. PG Bug reporting form 00:24
ERROR: multixact X from before cutoff Y found to be still running 📎 Bossart, Nathan 00:37
Re: ERROR: multixact X from before cutoff Y found to be still running 📎 Jeremy Schneider 01:01
Re: ERROR: multixact X from before cutoff Y found to be still running Thomas Munro 04:01
BUG #15992: Index size larger than the base table size. Sometime 3 times large PG Bug reporting form 11:17
Re: BUG #15977: Inconsistent behavior in chained transactions Peter Eisentraut 12:16
Re: BUG #15992: Index size larger than the base table size. Sometime 3 times large Euler Taveira 12:31
Re: ERROR: multixact X from before cutoff Y found to be still running Jeremy Schneider 18:32
Re: PostgreSQL12 crash bug report 📎 Andres Freund 19:59
Re: PostgreSQL12 crash bug report 📎 Andres Freund 20:04
Re: ERROR: multixact X from before cutoff Y found to be still running Bossart, Nathan 20:08
Re: BUG #15977: Inconsistent behavior in chained transactions Andres Freund 21:11
Re: ERROR: multixact X from before cutoff Y found to be still running Thomas Munro 21:31
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Alvaro Herrera 23:20

Sept. 6, 2019

Thread Author Time
RE: BUG #15992: Index size larger than the base table size. Sometime 3 times large Ram Pratap Maurya 05:08
Re: BUG #15977: Inconsistent behavior in chained transactions Michael Paquier 07:54
Re: ERROR: multixact X from before cutoff Y found to be still running Robert Haas 17:25
Re: BUG #15808: ERROR: subtransaction logged without previous top-level txn record (SQLSTATE XX000) Dave Cramer 20:39
Re: ERROR: multixact X from before cutoff Y found to be still running Thomas Munro 20:40
BUG #15993: "CREATE OR REPLACE FUNCTION" does not clear search_path PG Bug reporting form 20:42
BUG #15994: can't run psql PG Bug reporting form 22:39
Re: BUG #15808: ERROR: subtransaction logged without previous top-level txn record (SQLSTATE XX000) Hsu, John 23:36

Sept. 7, 2019

Thread Author Time
Re: BUG #15994: can't run psql Tom Lane 00:00
Re: BUG #15977: Inconsistent behavior in chained transactions Fabien COELHO 06:54
Re: BUG #15977: Inconsistent behavior in chained transactions 📎 fn ln 09:58
Re: BUG #15977: Inconsistent behavior in chained transactions Andres Freund 10:16
Re: BUG #15977: Inconsistent behavior in chained transactions Fabien COELHO 13:23
erro in Instaling PostegreSQL 11 Renato Netto 15:39
Re: BUG #15977: Inconsistent behavior in chained transactions 📎 fn ln 16:32
Re: BUG #15977: Inconsistent behavior in chained transactions Fabien COELHO 17:04
Re: BUG #15977: Inconsistent behavior in chained transactions fn ln 17:31

Sept. 8, 2019

Thread Author Time
Re: BUG #15977: Inconsistent behavior in chained transactions Peter Eisentraut 20:27
pgsql: Fix RelationIdGetRelation calls that weren't bothering with erro Tom Lane 21:01

Sept. 9, 2019

Thread Author Time
BUG #15995: VACUUM not working after setting/unsetting of archive_mode = on, wal_level = replica PG Bug reporting form 02:12
Re: BUG #15977: Inconsistent behavior in chained transactions fn ln 03:58
Re: BUG #15995: VACUUM not working after setting/unsetting of archive_mode = on, wal_level = replica Tom Lane 04:22
Re: BUG #15977: Inconsistent behavior in chained transactions Peter Eisentraut 08:42
Re: Postgres 11.5.1 failed installation Sandeep Thakkar 09:22
Re: BUG #15977: Inconsistent behavior in chained transactions fn ln 09:32
RE: Postgres 11.5.1 failed installation 📎 Petar Masev 10:12
Re: Postgres 11.5.1 failed installation Sandeep Thakkar 10:19
Re: BUG #15995: VACUUM not working after setting/unsetting of archive_mode = on, wal_level = replica Jeff Janes 11:28
BUG #15996: Unable to install any PosgresSQL version PG Bug reporting form 13:56
Re: PostgreSQL12 crash bug report Andres Freund 14:05
Re: PostgreSQL12 crash bug report Tom Lane 14:20
BUG #15997: PgManager giving error while looking a table with PgV12 PG Bug reporting form 18:33
Re: BUG #15997: PgManager giving error while looking a table with PgV12 Tom Lane 18:48
Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND 📎 Tom Lane 19:35
Re: BUG #15992: Index size larger than the base table size. Sometime 3 times large Euler Taveira 20:12

Sept. 10, 2019

Thread Author Time
Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND Michael Paquier 05:11
Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND Tom Lane 05:28
Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND Michael Paquier 05:39
BUG #15998: query to return a table column list gives error on a missing foreign data wrapper library PG Bug reporting form 09:46
BUG #15999: jsonb_populate_record fails with array column PG Bug reporting form 09:55
Re: BUG #15998: query to return a table column list gives error on a missing foreign data wrapper library Etsuro Fujita 11:41
Re: BUG #15996: Unable to install any PosgresSQL version Sandeep Thakkar 11:49
Re: BUG #15998: query to return a table column list gives error on a missing foreign data wrapper library Tom Lane 13:59
Re: BUG #15999: jsonb_populate_record fails with array column Tom Lane 14:38
Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND 📎 Tom Lane 14:58
BUG #16000: PgAdmin 4.12 Internal Server Error PG Bug reporting form 18:56

Sept. 11, 2019

Thread Author Time
BUG #16001: I'm trying to install postgre SQL using Enterprise DB installer but I'm getting error/ PG Bug reporting form 02:14
Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND Michael Paquier 02:16
AW: Postgres 11.5.1 failed installation Wilm Hoyer 07:43
Default collation changes leave indexes in invalid state Vincent Van Driessche 08:05
Re: Postgres 11.5.1 failed installation Sandeep Thakkar 08:12
Re: Default collation changes leave indexes in invalid state Tom Lane 13:39
Re: Default collation changes leave indexes in invalid state Vincent Van Driessche 14:07
Re: Default collation changes leave indexes in invalid state Alvaro Herrera 15:22
Re: BUG #15804: Assertion failure when using logging_collector with EXEC_BACKEND Tom Lane 15:47

Sept. 12, 2019

Thread Author Time
BUG #16002: Index size larger than the base table size and growing abnormally. PG Bug reporting form 05:38
BUG #16003: pg_basebackup failed with error : directory "xxxxxxx" exists but is not empty PG Bug reporting form 08:40
Unexpected behavior of jsonb_set() with a `null` value Марк 10:55
BUG #16004: New Version pgrouting_96-2.6.3-1 has dependency to postgis25_96 in postgresql.org-Channel PG Bug reporting form 11:17
BUG #16005: cannot use \d to get description of table PG Bug reporting form 12:35
Re: BUG #16005: cannot use \d to get description of table Alvaro Herrera 12:41
Re: BUG #16003: pg_basebackup failed with error : directory "xxxxxxx" exists but is not empty Magnus Hagander 13:27
Re: Unexpected behavior of jsonb_set() with a `null` value Thomas Kellerer 14:11
Re: Unexpected behavior of jsonb_set() with a `null` value Tom Lane 14:32
BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg PG Bug reporting form 16:51
BUG #16007: Regarding patch for BUG #3995: pqSocketCheck doesn't return PG Bug reporting form 19:51
Re: BUG #16007: Regarding patch for BUG #3995: pqSocketCheck doesn't return Tom Lane 20:17
Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg Tom Lane 20:33
Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg Andres Freund 21:10
Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg Tom Lane 22:28

Sept. 13, 2019

Thread Author Time
Re: BUG #16003: pg_basebackup failed with error : directory "xxxxxxx" exists but is not empty Michael Paquier 03:42
Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg Vinay Banakar 04:13
AW: BUG #16004: New Version pgrouting_96-2.6.3-1 has dependency to postgis25_96 in postgresql.org-Channel Zollinger Beat (OIZ) 04:20
Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg Tom Lane 04:29
BUG #16008: pgrouting rpm missing in pgdg PG Bug reporting form 06:06
RE: BUG #16003: pg_basebackup failed with error : directory "xxxxxxx" exists but is not empty RUIZ Sébastien 08:28
Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg Vinay Banakar 08:53
Re: BUG #16006: Update queries fail on a table having any policy with a function that takes a whole-row var as arg Tom Lane 11:59
Re: BUG #16003: pg_basebackup failed with error : directory "xxxxxxx" exists but is not empty Magnus Hagander 13:17
RE: BUG #16003: pg_basebackup failed with error : directory "xxxxxxx" exists but is not empty RUIZ Sébastien 15:12

Sept. 16, 2019

Thread Author Time
Re: BUG #16007: Regarding patch for BUG #3995: pqSocketCheck doesn't return Kiran Khatke 06:53
Re: BUG #15383: Join Filter cost estimation problem in 10.5 Peter Bex 11:32
Re: BUG #16007: Regarding patch for BUG #3995: pqSocketCheck doesn't return Tom Lane 13:54

Sept. 17, 2019

Thread Author Time
BUG #16009: ERROR:  found xmax 1245512970 from before relfrozenxid 1245512975 PG Bug reporting form 09:27
BUG #16010: Unexpected reordering of WHERE clause operations and SELECT list function calls PG Bug reporting form 15:47
Re: BUG #16010: Unexpected reordering of WHERE clause operations and SELECT list function calls Tom Lane 16:24
BUG #16011: Select * query for sequences does not show all columns in output. PG Bug reporting form 17:45
Re: BUG #16011: Select * query for sequences does not show all columns in output. Anthony Sotolongo 17:57
Re: BUG #16007: Regarding patch for BUG #3995: pqSocketCheck doesn't return Kiran Khatke 19:21
Re: ERROR: multixact X from before cutoff Y found to be still running Bossart, Nathan 19:34
install error 📎 Scott Laing 20:42

Sept. 18, 2019

Thread Author Time
Restricted interval data type Robert Lichtenberger 06:10
Bug: array starting index seems incorrect (different for 1D and 2D arrays) Zachary Smith 10:40
Re: Bug: array starting index seems incorrect (different for 1D and 2D arrays) Dmitry Dolgov 11:09
BUG #16012: vacuum full, something weird PG Bug reporting form 13:24
Re: Restricted interval data type Tom Lane 14:16
BUG #16013: Unexpected results from bit field query PG Bug reporting form 16:49
Re: BUG #16012: vacuum full, something weird Jeff Janes 20:31

Sept. 19, 2019

Thread Author Time
citext LIKE search bug Morris de Oryx 00:32
Fwd: citext LIKE search bug Morris de Oryx 01:39
Re: BUG #16013: Unexpected results from bit field query Tom Lane 03:37
Re: citext LIKE search bug Tom Lane 04:19
Re: citext LIKE search bug Morris de Oryx 04:30
Re: citext LIKE search bug Tom Lane 04:44
Re: install error Mahendra Singh 06:47
AW: install error Wilm Hoyer 08:41
Re: AW: install error Scott Laing 12:16

Sept. 20, 2019

Thread Author Time
BUG #16014: how to modify column ev_action of pg_rewrite PG Bug reporting form 01:43
Re: BUG #16014: how to modify column ev_action of pg_rewrite Michael Paquier 02:11
BUG #16015: information_schema.triggers lack of truncate trigger PG Bug reporting form 09:18
BUG #16016: deadlock with startup process, AccessExclusiveLock on pg_statistic's toast table PG Bug reporting form 09:40
Re: BUG #16015: information_schema.triggers lack of truncate trigger Ashutosh Sharma 11:12
Re: BUG #16015: information_schema.triggers lack of truncate trigger Tom Lane 14:32
Re: BUG #16015: information_schema.triggers lack of truncate trigger Ashutosh Sharma 14:57
Re: BUG #16016: deadlock with startup process, AccessExclusiveLock on pg_statistic's toast table Sergei Kornilov 15:00

Sept. 22, 2019

Thread Author Time
BUG #16017: Postgres does not respond non-local connections PG Bug reporting form 13:54
Re: BUG #16017: Postgres does not respond non-local connections Francisco Olarte 15:32
Re: BUG #16016: deadlock with startup process, AccessExclusiveLock on pg_statistic's toast table Tom Lane 19:06
Re: citext LIKE search bug Jeff Janes 19:53
Re: BUG #16017: Postgres does not respond non-local connections Andrew Gierth 20:14
Re: BUG #16013: Unexpected results from bit field query Tom Lane 21:47
Re: citext LIKE search bug Morris de Oryx 22:48

Sept. 23, 2019

Thread Author Time
Re: Postgres 11.5.1 failed installation Fahar Abbas 08:16
RE: Postgres 11.5.1 failed installation Igor Neyman 14:46
Query tool won't load Orr, James 14:50
BUG #16018: pg_sequence_last_value() doesn't give results for owners PG Bug reporting form 21:45
Re: BUG #16018: pg_sequence_last_value() doesn't give results for owners David G. Johnston 22:33
Re: BUG #16018: pg_sequence_last_value() doesn't give results for owners Robert Treat 23:34
Re: BUG #16018: pg_sequence_last_value() doesn't give results for owners Tom Lane 23:40

Sept. 24, 2019

Thread Author Time
Re: Query tool won't load Ashesh Vashi 05:11
BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12) PG Bug reporting form 09:29
Re: BUG #16019: error pg_restore from pg_dump(windows8.1-pgadmin 4.12) Tom Lane 14:17
Bug with "CHECK" when part of ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... CHECK ... Alfred R. Fuller 18:37
Re: Bug with "CHECK" when part of ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... CHECK ... Fabrízio de Royes Mello 20:27
Re: Bug with "CHECK" when part of ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... CHECK ... Tom Lane 20:27
Re: Bug with "CHECK" when part of ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... CHECK ... Fabrízio de Royes Mello 20:31
[No subject] Vladimir Ryabtsev 20:54
Violation of a unique key? Vladimir Ryabtsev 21:01
Re: Peter Geoghegan 21:04
Re: Bug with "CHECK" when part of ALTER TABLE ... ADD COLUMN IF NOT EXISTS ... CHECK ... Alfred R. Fuller 21:50

Sept. 25, 2019

Thread Author Time
Re: Vladimir Ryabtsev 00:27
Re: Peter Geoghegan 00:35
Re: Vladimir Ryabtsev 01:24
Re: Peter Geoghegan 01:48
Re: Vladimir Ryabtsev 02:53
RE: BUG #15724: Can't create foreign table as partition Stepan Yankevych 06:48
Re: Postgres 11.5.1 failed installation Sandeep Thakkar 06:50
BUG #16020: ICU Collations querys PG Bug reporting form 06:51
BUG #16021: Can create Pk on partitioned table with foreign table as partition PG Bug reporting form 07:11
Re: BUG #15724: Can't create foreign table as partition Etsuro Fujita 07:43
Re: BUG #16021: Can create Pk on partitioned table with foreign table as partition Etsuro Fujita 07:48
Re: BUG #15929: logical decoding can not write down the analyse result when the output file is touched. 📎 movead.li@highgo.ca 08:09
BUG #16022: to_json on arrays with unusual lower bound is not intuitive PG Bug reporting form 12:23
Re: BUG #16022: to_json on arrays with unusual lower bound is not intuitive Tom Lane 14:34
Re: BUG #16020: ICU Collations querys Peter Eisentraut 20:09
BUG #16023: in PgAdmin4.13, unable to recompile functions that have "search_path" set at the function level PG Bug reporting form 21:13
Re: BUG #16023: in PgAdmin4.13, unable to recompile functions that have "search_path" set at the function level Tom Lane 22:25
BUG #16024: segfault ip 0000560103865c60 error 4 in postgres PG Bug reporting form 22:31
Re: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres Tom Lane 22:45
Re: BUG #16024: segfault ip 0000560103865c60 error 4 in postgres Stephan Knauss 23:21
BUG #16025: pg_default tablespace is removable but not creatable PG Bug reporting form 23:31

Sept. 26, 2019

Thread Author Time
Re: BUG #16025: pg_default tablespace is removable but not creatable Tom Lane 00:09
BUG #16026: default_tablespace in postgresql.conf is used instead of the database's default. PG Bug reporting form 12:57
Re: BUG #16022: to_json on arrays with unusual lower bound is not intuitive Andreas Bergmaier 13:09
Re: BUG #16026: default_tablespace in postgresql.conf is used instead of the database's default. Tom Lane 15:01
Re: BUG #16020: ICU Collations querys Marina Garrido Sanchez 15:14
BUG #16027: Invalid output of to_timestamp PG Bug reporting form 15:20
Re: BUG #16027: Invalid output of to_timestamp Tom Lane 15:39
RE: BUG #16027: Invalid output of to_timestamp Jeffrey Sturm 16:03

Browse Archives

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