Collected from the PG bugs email list.

Comments or questions about this bug tracker can be sent to

I have generally closed without review by marking as stale any bug whose last message was older than 180 days ago.

Timed Out10
Not Our Bug46
Not a Bug117
Won't Fix17

291 open bugs have no response message in the database.

Not a Bug
Bug IDDescriptionPG VersionOS First MessageLast MessageMessage Count
15606Postgres incorrectly returns syntax error when using WITH clacuse11.1Windows 10 Home version1803 x642019-01-232019-01-232
15604NOT IN condition incorrectly returns False10.6linux Red Hat 4.8.3-92019-01-232019-01-234
15601ERRO TYPE SERIAL11.1Win 102019-01-212019-01-213
15595matchctx->npatterns is always 1 no matter pattern have 0 or 1 subexpression11.1linux2019-01-172019-01-173
15591pg_receivewal does not honor replication slots11.1all2019-01-112019-01-145
15576Missing X509_get_signature_nid symbol causes the standby to fail to start stream replication11.1CentOS Linux release 7.1.1503 (Core)2019-01-052019-01-093
15573Need more clarification in Json10.5Windows 102019-01-042019-01-042
15551Date/Time comparison not correct when the comparison is inside join clause and involves "+" or "-"11.1macOS Mojave 10.142018-12-142018-12-142
15545wrong calculation10.5Windows2018-12-112018-12-112
15538Postgres query performance is slow.9.6.0Windows 102018-12-072018-12-072
15536ERROR: column "value " does not exist11.0 Windows 64 2018-12-052018-12-057
15523\df command not working in psql 10.4 postgres 11.1 version11.1macOS High Sierra2018-11-272018-11-276
15517JSONB_BUILD_ARRAY and JSON_BUILD_ARRAY omit XML Declaration (if present) from XML colums11.1Windows2018-11-222018-11-232
15506Foreign data wrapper (postgres_fdw) unexpected behavior10.5Ubuntu 16.04.4 LTS2018-11-142018-11-142
15500Cannot set NULL to a field with ENUM type11.1Alpine Linux2018-11-132018-11-132
15491index on function not being used for full text search when querying through a view11.0linux2018-11-072018-11-072
15485Order by of inlineable stable function incorrect9.6.10ubuntu 14.04 x642018-11-042018-11-043
15464I use PostgreSQL11.0windows 72018-10-272018-10-271
15463I use PostgreSQL11.0windows 72018-10-272018-10-271
15462WITH ORDINALITY and CTEs don't work11.0Windows 102018-10-262018-10-262
15458pg_typeof inconsistency on negative integer constant limits11.0x86_64-pc-linux-gnu2018-10-242018-10-266
15457please de-activate my account11.0n/a - please de-activate my account2018-10-242018-10-241
15445Difference between two dates is not an integer10.4Windows Server 20122018-10-192018-10-197
15418pg_restore fails with [archiver (db)] could not execute query: ERROR: function XXXXX does not exist10.5Ubuntu 16.04.5 LTS2018-10-032018-10-033
15415Can we install OS cluster for PostgreSQL10.0Redhat Linux 642018-10-022018-10-021
15413windows 109.3.1windows2018-10-012018-10-011
15401pg_dump error9.6.6Red Hat Enterprise Linux Server release 7.4 (Maipo2018-09-252018-09-252
15397perl error10.4CentOS Linux release 7.5.1804 (Core)2018-09-242018-09-242
15393not able to CREATE EXTENSION plperl;10.4CENTOS 7.52018-09-202018-09-203
15391Problem with removing old instances on 9.610.5Ubuntu 16.04.2 LTS2018-09-192018-09-191
15390PostgreSQL sql
15389Fill zero in milliseconds of a timestamp9.6.10Windows 7 Service Pack 22018-09-182018-09-184
15387explain analyze timing on bug?11beta3CentOS 7.x x642018-09-182018-09-182
15386The PostGres_XL branch should be part of the main PostGRESQL repo by now?10.0Win 102018-09-152018-09-172
15385Copy from using CSV ignores the header9.5.14Linux2018-09-142018-09-142
15382Error create dictionary in pg_dump10.5Ubuntu 16.042018-09-132018-09-145
15380Sorting paging data loss10.5CentOS 7 X86_642018-09-122018-09-122
15377SLES 119.4.19OpenSUSE2018-09-102018-09-101
15374Error al ejecutar el paso de post instalacion10.5windows 8.1 Pro2018-09-092018-09-092
15372pg_stat_statements extension ignore stats_temp_directory setting and always write into pg_stat_tmp9.6.10Linux2018-09-082018-09-082
15366Rails issues with postgres 1010.0x86_642018-09-062018-09-061
15362llbeta3: ./configure; in x86_64-w64-mingw32-gcc 8.2.0 wrong options "-V" and "-qversion"11beta3Windows 10 64bit latest2018-09-032018-09-032
15357Data goes to wrong partition in HASH Partitioned table11beta3Linux (CentOS 7.4 64 bit)2018-08-282018-08-282
15353\det (list foreign tables) ignoring search_path9.6.8Linux2018-08-252018-08-252
15341postgresql is not running9.6.10Ubuntu 64bit2018-08-202018-08-201
15322Bancos de dados10.5mac os2018-08-112018-08-111
15319pg_stat_user_tables not showing last vacuum date10.3CentOS release 6.5 (Final)2018-08-092018-08-093
15318ERROR: current transaction is aborted, commands ignored until end of transaction block9.6.9Linux centos-test.sst.stp 3.10.0-327.el7.x86_642018-08-082018-08-084
13665Foreign Key constraint doesn't work9.4.4Mac2015-10-062015-10-073
13661Using word LIMIT9.4.1Windows2015-10-022015-10-029
13659Constraint names truncated without error9.4.4OS X (and Linux etc.)2015-10-012015-10-018
13658DELETE with syntax error in subselect deletes ALL9.3.9Ubuntu 14.04 LTS2015-10-012015-10-0112
13655Incorrect Syntax Error9.4.4Gentoo Linux2015-09-302015-10-0119
13652Function names as a table prefiex by underscore, confused with array9.4.4Ubuntu Server 14.04.12015-09-292015-09-295
13648Old Records disappearing after upgrade from 9.4.1 to 5.82015-09-282015-09-293
136442xRecovery without new writes, causes archiving failure9.5alpha2Linux2015-09-262015-09-285
13643Should a process dying bring postgresql down, or not?9.5alpha2Linux2015-09-262015-09-288
13642no backup_label file in PG_DATA after pg_stop_backup();9.4.4Linux2015-09-262015-09-275
13628System Hangs During Update Query9.1.3OpenSuse2015-09-212015-09-213
13619regression functions return Null9.4.4Any2015-09-142015-09-154
136083 argument range constructor functions9.3.9FreeBSD (9.2)2015-09-022015-09-022
13607Creating "Readonly" User for public Shema. 9.4.0Widows 10 Pro x642015-09-022015-09-022
13606CHECK clause in CREATE TABLE command9.2.4CENTOS 6.22015-09-022015-09-022
13586Repository/Distribution issues9.4.4Linux Mint2015-08-252015-08-264
13584Upsert. The sequence value is increased.9.5alpha2Windows 72015-08-222015-08-242
13581pg_dump omits extension versions9.4.4CentOS 6.62015-08-202015-08-253
13580Fix namespace handling in xpath function, current functions collision9.4.1Windows 7 x642015-08-202015-08-202
13578use cipher=NULL-SHA256 error when connect9.4.4CentOS 6.x x642015-08-182015-08-193
13572Foreign Key Corruption9.4.4Windows 8.1 x642015-08-142015-08-142
13557ESQL select issue9.4.0Linux 62015-08-102015-08-112
13540upsert is not good9.5alpha1windows72015-08-062015-08-062
13538REGEX non-greedy is working incorrectly (and also greedy matches fail if non-greedy is present)9.3.0?2015-08-032015-08-0510
13533jsonb_populate_record does not work when the value is a simple string9.5alpha1Linux Ubuntu 14.42015-08-032015-08-054
13524Not Getting expected Serialization error9.4.1Mac OS X 2015-07-282015-07-293
13521refused connection to host and port9.4.4Linux2015-07-282015-07-292
13520postgres not connecting with opnerp7.09.1.0ubuntu 12.042015-07-272015-07-283
13508Migration of version error9.1.18Linux2015-07-212015-07-212
13506jsonb || operator does not work9.5alpha1debian jessie2015-07-202015-07-213
13505Create Extension9.4.0windows2015-07-172015-07-172
13504Types in math functions table is incorrect9.4.4--2015-07-172015-07-184
13502parser misconstrues table alias9.4.4Debian stretch/sid2015-07-162015-07-163
13501Bug with subqueries in WHERE clause9.3.6Linux (don't know the distribution)2015-07-152015-07-152
13496INSERT WHERE NOT EXISTS error9.4.4Debian Linux 8 / Redhat Linux 6.52015-07-092015-07-093
13495Postgres documentation consistently teaches 'bad' practice9.3.9Linux2015-07-092015-07-092
13490Segmentation fault on pg_stat_activity9.5alpha1Ubuntu 14.04.2 LTS2015-07-072015-07-2220
13488Wrong netmask calculation9.4.4CentOS 6.52015-07-062015-07-113
13487GetBufferFromRing code bug9.4.4It does not matter2015-07-042015-07-062
13478Simple dictionary does not check for stopwords9.4.4Ubuntu & Windows2015-06-302015-06-302
13464Optimizer fails to use partial index on boolean when selected via "IS" operator.9.4.2Ubuntu 14.042015-06-242015-06-243
13455Start fair9.4.4windows 7 2015-06-202015-06-212
13444psql can't recover a pg_dump.9.4.4Debian 82015-06-152015-06-187
13426table bloat - dead rows not removed after vacuum9.1.14x86_64-unknown-linux-gnu debian2015-06-102015-06-104
13425Not able to import osm data into database9.4.3windows server 64 bit2015-06-102015-06-102
13367Calculate the each field of the table9.2.0Window82015-05-282015-05-281
13336Unexpected result from invalid query9.4.2Windows 8.12015-05-232015-05-235
12889Documentation9.1.0Debian 7.82015-03-212015-03-232
12856No space left on device, but there is space!9.4.1ubuntu 14.042015-03-122015-03-134
12628range of sqlstate for user defined exception9.3.0linux x86 64 / centos 5.92015-01-222015-01-222
12622mapping java object to postgres with types9.3.4linux x86 642015-01-212015-01-222
12465Materialized view dump restoration issue9.4.0Ubuntu 14.04.12015-01-082015-01-096
11705\d(escribe) table shows incorrect check constraint9.1.13x86_64-unknown-linux-gnu2014-10-172014-10-203
11596Duplicate column9.1.14UBUNTU 12.042014-10-062014-10-062
11524Unable to add value to ENUM when having AUTOCOMMIT disabled in psql9.4beta2Debian2014-09-302014-10-014
11518full_page_writes is off after executing pg_start_backup()9.2.2ubuntu2014-09-292014-09-302
11500PRIMARY KEY index not being used9.1.12Linux2014-09-262014-09-264
11404Current PostgreSQL Databases Configuration 9.2.1Linux2014-09-122014-09-122
10610connecting postgresql server to pgadmin III8.4.0linux2014-06-112014-06-111
10235Postgres is opening 8.4.1Win 72014-05-062014-05-061
9841Need some help in sql query9.3.1mac os2014-04-032014-04-043
8674Professional services in Poland9.2.1Windows2013-12-112013-12-111
8661Update on all rows in table fails9.1.3MacOSX or Windows2013-12-062013-12-063
7844xpath missing entity decoding - bug or feature9.2.2Debian2013-02-012013-11-075
5465dblink TCP connection hangs blocking translation from being terminated8.2.1Red Hat 3.4.6-3 (kernel 2.6.9-42.0.3.ELsmp)2010-05-192014-03-178