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

332 open bugs have no response message in the database.

Open (but not New) Bugs
Bug IDDescriptionPG VersionOS First MessageLast MessageMessage Count
15623Inconsistent use of default for updatable view11.1Ubuntu 11.12019-02-072019-02-2813
15618Duplicating a join clause breaks index use10.3Windows 102019-02-012019-02-028
15617walsender hang if sync replica disconnected from network10.6Ubuntu 14.04.5 LTS (GNU/Linux 4.4.52-25 x86_64)2019-02-012019-03-083
15613Bug in PG Planner for Foreign Data Wrappers9.6.3Linux and macOS2019-01-302019-02-0712
15600ts_stat's nentry maxes out at 25511.0x86_64-pc-linux-gnu, compiled by gcc (GCC) 6.3.02019-01-212019-01-213
15594Unstable tests in contrib/test_decoding/output_iso/11.1Ubuntu 18.042019-01-162019-01-177
15592Memory overuse with subquery containing unnest() and set operations (11.x regression)11.1FreeBSD 12.02019-01-142019-02-0913
15590crosstab_hash unable to work with modified types (CreateTupleDescCopy returning dropped attributes?)9.6.11FreeBSD 10.22019-01-112019-01-112
15589Due to missing wal, restore ends prematurely and opens database for read/write11.1Red Hat Enterprise Linux Server release 7.62019-01-112019-01-124
15587Partitions with ALTER TABLE ADD CONSTRAINT11.1Fedora 282019-01-102019-01-2418
15585infinite DynamicSharedMemoryControlLock waiting in parallel query10.6Ubuntu 16.04.2 LTS2019-01-102019-04-129
15579Adding a column with default from configuration parameter fails on 11.111.1Ubuntu 18.04.1 LTS2019-01-072019-01-078
15577Query returns different results when executed multiple times11.1Windows 102019-01-062019-01-1037
15572Misleading message reported by "Drop function operation" on DB with functions having same name10.5RDS (on Amazon)2019-01-032019-03-1034
15558NOTIFY max channel length is undocumented11.1(irrelevant)2018-12-192018-12-193
15554Broken pipe when doing a COPY of a parallel query10.6Ubuntu 18.042018-12-172018-12-172
15546alter large object n owner to new owner9.6.10Debian 9.6 (Stretch)2018-12-112018-12-112
15544Unexpected: "Returned record type does not match expected record type" after ALTER TABLE10.6Ubuntu 182018-12-092018-12-092
15542value too long for type character varying does not show the real parameter value10.6CentOS 7.5, official docker container postgres:102018-12-072018-12-072
15541Use after release in PQprint11.1Linux2018-12-072018-12-075
15540Use after release in ExecuteTruncateGuts11.1Linux2018-12-072018-12-095
15535psql: \copy: parse error at...10.3 windows 7 2018-12-052018-12-0510
15534Operators from public schema in trigger WHEN-clauses are silently allowed despite breaking restores9.6.11Amazon Linux2018-12-012018-12-013
15533error on upsert when used in a fuction and a function parameter has the same name as the column11.1Ubuntu 18.042018-11-302018-12-017
15530unable restore index on function from earthdistance contrib11.1Linux Debian2018-11-302018-12-034
15529interval max value '178000000 years' in doc is not exact. It should 178956970.11.0Linux2018-11-302018-11-301
15527Issue converting from local date/time to 'timestamp with time zone' prior to dst transition9.6.10CentOS 6-9.el6.12.32018-11-282018-11-293
15518intarray index crashes hard11.1any2018-11-222018-11-232
15514process fails on jsonb_populate_recordset query. see simple example below11.1WindiwsServer 2012 64bit2018-11-202018-11-227
15511Drop table error "invalid argument"11.1windows 102018-11-172019-02-0514
15499pg_dump does not read connection URL from environment variableUnsupported/UnknownUbuntu 14.04 LTS2018-11-122018-11-123
15492pg_cancel_backend(pg_backend_pid()) returns true sporadically11.0Windows 2012 R22018-11-082018-11-1210
15486PG11 jit on 50x slower than jit off11.0Debian 92018-11-052019-02-096
15479Documentation claims that client_min_messages is related to logging11.0any2018-11-012018-11-082
15477Procedure call with named inout refcursor parameter - "invalid input syntax for type boolean" error11.0RedOS (based on Red Hat Linux) (
15476Problem on show_trgm with 4 byte UTF-8 characters9.6.2Windows Server 2012 Japanese2018-11-012018-11-033
15474Special character escape sequences need better documentation, or more easily found documentation11.0Any2018-10-312018-11-018
15471psql 11 array concatenation in CASE takes on values from the CASE expression when using enum_range11.0Confirmed on MacOs and Alpine Linux2018-10-302018-10-306
15460Error while creating index or constraint11.0Windows Server 2008 R22018-10-262018-11-2942
1545210.5 and reproducible "ERROR: could not read block 0 in file..." when creating functional index10.5CentOS release 6.6 (Final)2018-10-222018-10-232
15449file_fdw using program cause exit code error when using LIMIT10.5Ubuntu 16.04.2 LTS (Xenial Xerus)2018-10-222018-11-1320
15446Crash on ALTER TABLE11.0docker2018-10-192019-01-0620
15440pg_dump does not preserve quoted identifiers for statement-level trigger transition table names10.5Linux2018-10-192018-10-192
15438Standby corruption after "Too many open files in system" error10.4Redhat 7.32018-10-182018-10-225
15428"Inception" with recursive prepared statement causes infinite loop11beta4MacOS2018-10-122018-10-152
15427DROP INDEX did not free up disk space10.5Debian Sarge (9)2018-10-122018-10-126
15421Error: LIKE pattern must not end with escape character9.4.19Linux (4.9.0-4-amd64 #1 SMP Debian 4.9.65-3+deb9u)2018-10-052018-10-052
15420Server crash. Segmentation fault when parsing xml file10.5Ubuntu 16.04.3 LTS2018-10-042018-10-0539
15414extension compilation fails when c++ files are named with .cc11beta4any2018-10-012018-10-017
15412"invalid contrecord length" during WAL replica recovery10.4Ubuntu 16.04.4 LTS2018-10-012018-10-123
15388time convert error when use AT TIME ZONE '+8'10.1linux2018-09-182018-09-184
15383Join Filter cost estimation problem in 10.510.5Linux2018-09-132020-09-2524
15349"make installcheck -C src/interfaces/libpq" fails11beta3Ubuntu 18.042018-08-242018-09-122
15342pg_dump - XML with mixed content types generates invalid backup file9.6.7Ubuntu 16; Ubuntu 18; Raspbian (Pi)2018-08-202018-08-232
15338pg_restore --disable-triggers --data-only AND schema for table is not set.10.4ubuntu 18.042018-08-172018-08-173
15335Documentation is wrong about archive_command and existing files9.6.10Debian Stretch2018-08-162018-08-229
15333pg_dump error on large table -- "pg_dump: could not stat file...Unknown error"10.4Windows Server 2016 Server2018-08-162018-08-216
15331Please check if recovery.conf can be renamed9.6.10Debian Stretch2018-08-162018-08-184
15323wal_keep_segments must be >= 1 for WAL archiving + streaming to work9.6.10Debian Stretch2018-08-132018-08-1310
15313Waiting `startup` process on a streaming replica10.4Ubuntu 14.04.5 LTS (trusty)2018-08-072018-08-073
15312Possible access to unintended variable in "postgres/src/backend/postmaster/pgstat.c" line 2698Unsupported/UnknownMacosx2018-08-072018-08-073
15307Low numerical precision of (Co-) Variance9.6.6Linux2018-08-012018-08-285
15293Stored Procedure Triggered by Logical Replication is Unable to use Notification Events10.4Ubuntu 18.04 Desktop x64 - Linux 4.15.0-29-generic2018-07-242021-05-1217
15285Query used index over field with ICU collation in some cases wrongly return 0 rows10.4fedora2018-07-192020-09-1021
15231After Upgrade from 9.3.23 to 9.6.9 getting ERROR: found xmin 598 from before relfrozenxid 685691649.3.23Ubuntu 16.04.4 LTS (GNU/Linux 4.4.0-97-generic x82018-06-072018-11-033
15160planner overestimates number of rows in join when there are more than 200 rows coming from CTE10.3Linux2018-04-172018-09-254
15121Multiple UBSAN errors10.3Linux2018-03-182019-06-3020
14954fresh install of postgresql-server 9.6.6-3PGDG.rhel6 fails on initdb9.6.6CentOS 6.92017-12-082019-02-223
14242Role with a setconfig "role" setting to a nonexistent role causes pg_upgrade to fail9.5.264-bit Linux2016-07-112021-04-1414
3995pqSocketCheck doesn't return8.2.3Red Hat Enterprise Linux AS release 42008-02-282018-09-285