pgsql-bugs since 2016-10-05 00:00

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

Oct. 5, 2016

Thread Author Time
Re: BUG #14329: libpq doesn't send complete client certificate chain on first SSL connection Heikki Linnakangas 06:20
Re: BUG #14329: libpq doesn't send complete client certificate chain on first SSL connection 📎 Heikki Linnakangas 09:10
Re: BUG #14329: libpq doesn't send complete client certificate chain on first SSL connection John R Pierce 10:00
BUG #14354: Wrong interpretation of JSON 'null' kouber 10:12
Wrong results of function age(timestamp, timestamp) mmerta 14:01
Re: BUG #14354: Wrong interpretation of JSON 'null' Vitaly Burovoy 14:08
BUG #14356: "FATAL: the database system is starting up" error occurs to queries after PostgreSQL server start xrensis 14:25
Re: Wrong results of function age(timestamp, timestamp) Rader, David 14:34
Re: BUG #14356: "FATAL: the database system is starting up" error occurs to queries after PostgreSQL server start Tom Lane 14:45
BUG #14357: BUG : old_snapshot_threshold no effect digoal 16:21
Re: BUG #14357: BUG : old_snapshot_threshold no effect Kevin Grittner 20:12

Oct. 6, 2016

Thread Author Time
Re: BUG #14343: UPSERT (ON CONFLICT) doesn't check ON CONFLICT constraint first Reyes Ponce 02:34
Re: WAL senders sending base backups not listening much to SIGTERM Michael Paquier 02:34
Re: BUG #14343: UPSERT (ON CONFLICT) doesn't check ON CONFLICT constraint first Peter Geoghegan 02:47
Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file Michael Paquier 05:20
Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file Michael Paquier 06:31
Re: BUG #14354: Wrong interpretation of JSON 'null' Kouber Saparev 07:29
SQL Bug Bujji Babu 10:22
Re: SQL Bug 📎 Bujji Babu 10:23
Re: SQL Bug Oleksandr Shulgin 10:44
Re: [BUGS] SQL Bug Heikki Linnakangas 10:44
Re: [BUGS] SQL Bug Bujji Babu 10:59
Re: BUG #14356: "FATAL: the database system is starting up" error occurs to queries after PostgreSQL server start Heikki Linnakangas 11:04
Re: SQL Bug Heikki Linnakangas 11:07
Re: [BUGS] SQL Bug Bujji Babu 11:19
Re: BUG #14351: Upsert not working in case of partitioned tables Marco Colombo 11:43
Re: BUG #14354: Wrong interpretation of JSON 'null' Tom Lane 12:47
Re: BUG #14354: Wrong interpretation of JSON 'null' Vitaly Burovoy 12:50
Re: BUG #14356: "FATAL: the database system is starting up" error occurs to queries after PostgreSQL server start Michael Paquier 12:53
Re: BUG #14243: pg_basebackup failes by a STATUS_DELETE_PENDING file Kevin Grittner 14:15
Re: BUG #14354: Wrong interpretation of JSON 'null' Kouber Saparev 15:27
Re: BUG #14351: Upsert not working in case of partitioned tables Tom Lane 17:56
Rows go missing when selecting "for update" after savepoint "play" hubert depesz lubaczewski 18:05
Re: Rows go missing when selecting "for update" after savepoint "play" hubert depesz lubaczewski 18:35
Re: Rows go missing when selecting "for update" after savepoint "play" Alvaro Herrera 19:49

Oct. 7, 2016

Thread Author Time
When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode. 厚积薄发 00:00
Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode. Michael Paquier 00:09
Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode. 厚积薄发 00:15
Re: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode. Andres Freund 00:21
Re: Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode. Michael Paquier 00:22
Re: When I set the synchronous_standby_names and synchronous_commit to off, the replication query state also show in sync mode. 厚积薄发 00:35
BUG #14359: serial datatype issue debaratis 08:51
Re: BUG #14329: libpq doesn't send complete client certificate chain on first SSL connection Heikki Linnakangas 09:26
Re: BUG #14329: libpq doesn't send complete client certificate chain on first SSL connection Zuk, Kacper 09:58
Re: BUG #14351: Upsert not working in case of partitioned tables Marco Colombo 11:39
Re: BUG #14359: serial datatype issue hubert depesz lubaczewski 12:09
Re: Rows go missing when selecting "for update" after savepoint "play" hubert depesz lubaczewski 12:10
BUG #14360: snapshot too old bug? cann't reclaim dead tuple after has only xmin's transaction. digoal 14:54
BUG #14361: snapshot too old bug? in xmin>=xid transaction, also raise snapshot too old error digoal 15:03
Re: BUG #14360: snapshot too old bug? cann't reclaim dead tuple after has only xmin's transaction. Kevin Grittner 21:10
Re: BUG #14361: snapshot too old bug? in xmin>=xid transaction, also raise snapshot too old error Kevin Grittner 21:24

Oct. 8, 2016

Thread Author Time
Re: Sudden FTS-related error from parallel worker in 9.6 Amit Kapila 05:30
Re: Sudden FTS-related error from parallel worker in 9.6 Tom Lane 05:43
Re: Sudden FTS-related error from parallel worker in 9.6 Amit Kapila 06:38

Oct. 10, 2016

Thread Author Time
memory leak in libpq , definitely lost: 200 bytes in 1 blocks, indirectly lost: 2,048 bytes in 1 blocks ... 📎 Simplex 09:38
Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0 Tillmann Schulz 13:46
Re: memory leak in libpq , definitely lost: 200 bytes in 1 blocks, indirectly lost: 2,048 bytes in 1 blocks ... Heikki Linnakangas 14:14
Re: memory leak in libpq , definitely lost: 200 bytes in 1 blocks, indirectly lost: 2,048 bytes in 1 blocks ... Tom Lane 14:44
Re: Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0 Tom Lane 14:47
Re: Sudden FTS-related error from parallel worker in 9.6 Tom Lane 15:40
BUG #14362: Postgres macaddr does not support EUI-64 8-byte MAC addresses tilo.sloboda 16:20
Re: [BUGS] Query available indexes via jdbc meta data does not work any more in PostgreSQL 9.6.0 Dave Cramer 16:35
Re: BUG #14362: Postgres macaddr does not support EUI-64 8-byte MAC addresses Tom Lane 17:00
BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't hcate3 18:56
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't Pavel Stehule 19:15
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't Henry Cate 19:26
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't Pavel Stehule 19:29
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't Tom Lane 19:34
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't Henry Cate 19:34
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't David G. Johnston 19:47
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't Vitaly Burovoy 20:09
BUG #14364: json_populate_record doesn't accept JSON arrays joerg 20:51
Re: BUG #14363: CASE against a literal value produces correct against, same expression against a column null doesn't Henry Cate 20:59
Re: BUG #14362: Postgres macaddr does not support EUI-64 8-byte MAC addresses Tilo Sloboda 21:41

Oct. 11, 2016

Thread Author Time
Re: language code incompatibility in Windows Noah Misch 06:42
parallel plan in insert query Grigory Smolkin 10:01
BUG #14365: drop big schema will hang the standby's apply digoal 11:30
Re: parallel plan in insert query Greg Stark 11:41
Re: parallel plan in insert query Grigory Smolkin 11:48
Re: parallel plan in insert query Amit Kapila 12:24
Re: Sudden FTS-related error from parallel worker in 9.6 Amit Kapila 12:58
Re: parallel plan in insert query Tom Lane 13:00
Re: Sudden FTS-related error from parallel worker in 9.6 Tom Lane 13:07
Re: parallel plan in insert query Grigory Smolkin 14:08

Oct. 12, 2016

Thread Author Time
Re: BUG #14362: Postgres macaddr does not support EUI-64 8-byte MAC addresses Michael Paquier 03:35
got some errors after upgrade poestgresql from 9.5 to 9.6 张嘉志 05:27
Re: got some errors after upgrade poestgresql from 9.5 to 9.6 Pavel Stehule 05:40
Re: got some errors after upgrade poestgresql from 9.5 to 9.6 张嘉志 05:51
Re: got some errors after upgrade poestgresql from 9.5 to 9.6 Pavel Stehule 06:01
BUG #14366: jsonb_set() error when modify array element bluevaley 06:53
9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]', sunpeng 06:57
Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]', Michael Paquier 07:00
Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]', Michael Paquier 07:04
Return Codes of BatchUpdateException in PostgreSql 9.6 Tillmann Schulz 10:23
Re: Return Codes of BatchUpdateException in PostgreSql 9.6 John R Pierce 10:39
BUG #14367: Pressing execute 20-30 times really fast causes loop of error messages jan.kort 10:45
Re: Return Codes of BatchUpdateException in PostgreSql 9.6 Tillmann Schulz 11:42
BUG #14368: Strange behaviour of set_config() in case of transaction failure alena.zubets 15:15
Re: BUG #14344: string_agg(DISTINCT ..) crash Peter Geoghegan 21:20
Re: BUG #14367: Pressing execute 20-30 times really fast causes loop of error messages Kevin Grittner 21:21
Re: BUG #14344: string_agg(DISTINCT ..) crash 📎 Peter Geoghegan 23:36

Oct. 13, 2016

Thread Author Time
Re: BUG #14344: string_agg(DISTINCT ..) crash 📎 Peter Geoghegan 00:02
Re: 9.6 bug: select jsonb_set('[{"f1":1,"f2":null},2,null,3]', '{0}','[2,3,4]', sunpeng 00:43
Re: BUG #14366: jsonb_set() error when modify array element Tom Lane 04:26
Re: BUG #14366: jsonb_set() error when modify array element Michael Paquier 04:33
Re: BUG #14344: string_agg(DISTINCT ..) crash Heikki Linnakangas 07:59
Table Partitioning with Foreign Data Wrapper Ranjeet Verma 08:10
BUG #14369: incorrect translation of error message to russian alexey.ermakov 10:22
Re: BUG #14344: string_agg(DISTINCT ..) crash Peter Geoghegan 17:27
Re: BUG #14364: json_populate_record doesn't accept JSON arrays Tom Lane 20:19

Oct. 14, 2016

Thread Author Time
BUG #14370: pgagent_96 service typo? alf 10:22
BUG #14371: Issue in uninstalling Postgres 8.4 in windows 10 OS kesavan.sengodan 13:49

Oct. 15, 2016

Thread Author Time
BUG #14372: ll_to_earth(...) assumes it'll always be executed with 'public' in the search_path postgres 00:14
BUG #14373: PostgreSQL Service is seems to be "Stopped" after Jan 19, 2038. kensuke.nakam 03:38
Installation Issue vatsla sharan 05:21
Re: Installation Issue John R Pierce 08:47
ERROR: could not determine which collation to use for view column Rahila Syed 22:17

Oct. 16, 2016

Thread Author Time
Issue in pg_update Yuriy Tereshchuk 00:15
Re: Issue in pg_update Tom Lane 17:50

Oct. 17, 2016

Thread Author Time
Re: BUG #14344: string_agg(DISTINCT ..) crash Heikki Linnakangas 09:20
Re: BUG #14344: string_agg(DISTINCT ..) crash Tom Lane 13:42
BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences. anup.saund 17:45
Re: BUG #14374: psql.exe command options \dtvs produces a database list, not table/view/sequences. Tom Lane 18:03
BUG #14375: ODBC driver SQLDescibeCol always returns the column size 28 son102yh 18:39
BUG #14376: How stop/cancel/break/quit the "process watcher - restoring backup on the server" thomastrovon 19:24
BUG #14377: ODBC SQLDescribeCol always returns decimal digit 6 son102yh 19:39

Oct. 18, 2016

Thread Author Time
Re: BUG #14376: How stop/cancel/break/quit the "process watcher - restoring backup on the server" Michael Paquier 00:01
Re: BUG #14344: string_agg(DISTINCT ..) crash Peter Geoghegan 01:29
BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug? digoal 07:57
BUG #14379: Different results pq 15:25
Re: BUG #14379: Different results Tom Lane 16:04
Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug? John R Pierce 18:25
Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug? Andres Freund 18:32
BUG #14380: pg_config fails to build. hellkite500 22:59

Oct. 19, 2016

Thread Author Time
Re: Return Codes of BatchUpdateException in PostgreSql 9.6 Bruce Momjian 00:03
Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug? 德哥 01:22
Re: BUG #14378: when drop schema, standby will do many more than primary, and very slow, it's a bug? 德哥 01:47
Re: BUG #14380: pg_config fails to build. Tom Lane 03:56
BUG #14381: justify_interval function works in strange way maciej.srebrny+postgresql 08:44
BUG #14382: System.TypeLoadException: Failure has occurred while loading a type mali.jitendra 10:43
pgAdmin4 on Mac Tizian Kronsbein 13:27
Re: pgAdmin4 on Mac Rader, David 14:32
Re: BUG #14382: System.TypeLoadException: Failure has occurred while loading a type Rader, David 14:34
Re: BUG #14370: pgagent_96 service typo? Bruce Momjian 15:05
Re: BUG #14373: PostgreSQL Service is seems to be "Stopped" after Jan 19, 2038. Bruce Momjian 15:12
Re: BUG #14380: pg_config fails to build. 📎 Nels Frazier 17:24
Re: BUG #14380: pg_config fails to build. Tom Lane 18:02
Re: BUG #14370: pgagent_96 service typo? Devrim Gündüz 19:51
Re: BUG #14370: pgagent_96 service typo? Alf Normann Klausen 20:02

Oct. 20, 2016

Thread Author Time
BUG #14384: pg_dump uses excessive amounts of memory for LOBs boleslaw.ziobrowski 07:56
BUG #14385: Operator IS changed priority in 9.5 strahinjak 08:50
Re: BUG #14385: Operator IS changed priority in 9.5 Strahinja Kustudić 09:12
BUG #14386: Run-time error '3018' with psqlODBC Driver using VB6 and DAO mg 09:20
Re: BUG #14384: pg_dump uses excessive amounts of memory for LOBs Tom Lane 13:23
BUG #14387: Trying to send mail to general@postgresql.org andre_mikulec 13:26
Re: BUG #14387: Trying to send mail to general@postgresql.org Rader, David 13:29
Re: BUG #14387: Trying to send mail to general@postgresql.org Tom Lane 13:30
Re: BUG #14387: Trying to send mail to general@postgresql.org Kevin Grittner 13:31
Re: BUG #14384: pg_dump uses excessive amounts of memory for LOBs Bolek Ziobrowski 21:22

Oct. 21, 2016

Thread Author Time
BUG #14389: Duplicate rows on tables with unique index constrain mahmoudhakh 09:32
BUG #14390: ODBC statement_timeout > psqlODBC 09.05.0210 olli.marx 12:21
BUG #14391: PostgreSQL OLE DB stops psqlODBC from working mg 12:35
BUG #14392: Selectting a data base diegojamweg 14:38
Re: BUG #14392: Selectting a data base David G. Johnston 14:52
bug? Alexander Mills 22:03
Re: bug? John R Pierce 22:36
Re: bug? Alexander Mills 23:03

Oct. 24, 2016

Thread Author Time
BUG #14393: Querry plan creation time is too long ufaowl 13:04
BUG #14394: No error raised in IN-clause when commas are missing andreas.imboden 14:28
Re: BUG #14394: No error raised in IN-clause when commas are missing hubert depesz lubaczewski 14:44
Re: BUG #14394: No error raised in IN-clause when commas are missing Tom Lane 14:46
Re: BUG #14394: No error raised in IN-clause when commas are missing David G. Johnston 14:47
Re: BUG #14394: No error raised in IN-clause when commas are missing Erik Rijkers 14:48
Re: BUG #14394: No error raised in IN-clause when commas are missing Pantelis Theodosiou 16:41
Re: BUG #14394: No error raised in IN-clause when commas are missing Tom Lane 16:59
Re: BUG #14394: No error raised in IN-clause when commas are missing Pantelis Theodosiou 17:14
Re: BUG #14394: No error raised in IN-clause when commas are missing David G. Johnston 17:42
Re: BUG #14394: No error raised in IN-clause when commas are missing Alvaro Herrera 19:09
Re: BUG #14393: Querry plan creation time is too long Jeff Janes 19:11

Oct. 25, 2016

Thread Author Time
BUG #14395: sslmode=prefer not checking for certificate and allows connection as SSL balaji.chithambaram 13:50
Re: BUG #14395: sslmode=prefer not checking for certificate and allows connection as SSL Andres Freund 14:21
Re: BUG #14395: sslmode=prefer not checking for certificate and allows connection as SSL Chithambaram, Balaji (CONT) 14:41
Re: BUG #14395: sslmode=prefer not checking for certificate and allows connection as SSL Andres Freund 14:45
Re: BUG #14395: sslmode=prefer not checking for certificate and allows connection as SSL Chithambaram, Balaji (CONT) 15:04
Compilation of timezone source with zic fails (on mountpoint) Sandeep Thakkar 16:03
Re: Compilation of timezone source with zic fails (on mountpoint) Tom Lane 16:37

Oct. 26, 2016

Thread Author Time
BUG #14396: grant drop table sennirban89 06:57
BUG #14397: Updatable VIEW doesn't work with ON CONFLICT from PgPreparedStatement grygoriy.gonchar 09:24
Re: BUG #14396: grant drop table Stephen Frost 14:17
Re: Compilation of timezone source with zic fails (on mountpoint) Tom Lane 16:41
Re: BUG #14344: string_agg(DISTINCT ..) crash Peter Geoghegan 18:44
AfterTriggerSaveEvent() Error on altered foreign key cascaded delete 📎 James Parks 19:21
Re: AfterTriggerSaveEvent() Error on altered foreign key cascaded delete Tom Lane 19:42
BUG #14398: Order of Joins results in different results returned vjchem 20:49
Re: BUG #14398: Order of Joins results in different results returned Tom Lane 21:52

Oct. 27, 2016

Thread Author Time
Not able to uninstall PostgreSQL 8.4.5-1 in Windows 10 OS and Windows Server 2012 OS Sengodan, Kesavan 07:41
PostgreSQL related problem on iMac Neil Marshall 09:31
Re: Not able to uninstall PostgreSQL 8.4.5-1 in Windows 10 OS and Windows Server 2012 OS Michael Paquier 12:43
Re: PostgreSQL related problem on iMac Francisco Olarte 14:37
Re: PostgreSQL related problem on iMac Tom Lane 14:59

Browse Archives

Prev | Next