pgsql-hackers since 2016-07-01 00:12

The PostgreSQL developers team lives here. Discussion of current development issues, problems and bugs, and proposed new features. If your question cannot be answered by people in the other lists, and it is likely that only a developer will know the answer, you may re-post your question in this list. You must try elsewhere first!

Search the Archives

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

Browse Archives

Prev | Next

July 1, 2016

Thread Author Time
Allow INSTEAD OF DELETE triggers to modify the tuple for RETURNING 📎 Marko Tiikkaja 00:12
Re: OpenSSL 1.1 breaks configure and more 📎 Andreas Karlsson 00:27
Is a UDF binary portable across different minor releases and PostgreSQL distributions? Tsunakawa, Takayuki 00:33
Re: primary_conninfo missing from pg_stat_wal_receiver 📎 Michael Paquier 00:46
Re: initdb issue on 64-bit Windows - (Was: [pgsql-packagers] PG 9.6beta2 tarballs are ready) Craig Ringer 00:48
Re: initdb issue on 64-bit Windows - (Was: [pgsql-packagers] PG 9.6beta2 tarballs are ready) Alvaro Herrera 00:57
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Michael Paquier 00:58
Re: initdb issue on 64-bit Windows - (Was: [pgsql-packagers] PG 9.6beta2 tarballs are ready) Michael Paquier 01:02
Re: _mdfd_getseg can be expensive Peter Geoghegan 01:14
Re: _mdfd_getseg can be expensive Andres Freund 01:23
Bad behavior from plpython 'return []' Jim Nasby 01:25
Re: initdb issue on 64-bit Windows - (Was: [pgsql-packagers] PG 9.6beta2 tarballs are ready) Craig Ringer 01:28
Re: _mdfd_getseg can be expensive Peter Geoghegan 01:34
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Tsunakawa, Takayuki 01:35
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Michael Paquier 01:56
Re: _mdfd_getseg can be expensive Andres Freund 02:08
Re: OpenSSL 1.1 breaks configure and more Michael Paquier 02:08
Re: Reviewing freeze map code Amit Kapila 02:12
Re: [sqlsmith] crashes in RestoreSnapshot on hot standby Michael Paquier 02:17
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Tom Lane 02:22
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Tsunakawa, Takayuki 02:33
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Michael Paquier 03:15
Re: [sqlsmith] crashes in RestoreSnapshot on hot standby 📎 Thomas Munro 03:18
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Tsunakawa, Takayuki 03:19
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Michael Paquier 03:25
Re: [sqlsmith] crashes in RestoreSnapshot on hot standby Amit Kapila 03:25
Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Noah Misch 03:51
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Tsunakawa, Takayuki 04:00
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Noah Misch 04:06
Re: [sqlsmith] crashes in RestoreSnapshot on hot standby 📎 Thomas Munro 04:08
Re: Broken handling of lwlocknames.h Noah Misch 04:09
Re: [sqlsmith] crashes in RestoreSnapshot on hot standby Amit Kapila 04:22
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Pavel Stehule 05:02
Re: [sqlsmith] crashes in RestoreSnapshot on hot standby Andreas Seltenreich 05:41
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Craig Ringer 06:40
Re: pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Andres Freund 06:48
Re: Odd system-column handling in postgres_fdw join pushdown patch 📎 Etsuro Fujita 07:10
Re: Is a UDF binary portable across different minor releases and PostgreSQL distributions? Tsunakawa, Takayuki 07:24
Re: OpenSSL 1.1 breaks configure and more Magnus Hagander 08:02
Re: OpenSSL 1.1 breaks configure and more Michael Paquier 08:10
Re: WIP: About CMake v2 Yury Zhuravlev 08:32
Re: OpenSSL 1.1 breaks configure and more Magnus Hagander 09:08
Re: WIP: About CMake v2 Dmitry Maslyuk 09:26
Re: OpenSSL 1.1 breaks configure and more Christoph Berg 09:41
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Oleg Bartunov 09:52
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Craig Ringer 11:06
Re: problems using pg_start_backup/pg_stop_backup and pg_basebackup at same time Magnus Hagander 11:30
Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Robert Haas 12:17
Re: [sqlsmith] crashes in RestoreSnapshot on hot standby Robert Haas 13:04
Re: Broken handling of lwlocknames.h Robert Haas 13:18
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Robert Haas 13:23
Re: Documentation fixes for pg_visibility Robert Haas 13:28
Re: Broken handling of lwlocknames.h Tom Lane 13:29
Re: Broken handling of lwlocknames.h Michael Paquier 13:30
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Robert Haas 13:33
Re: Truncating/vacuuming relations on full tablespaces Robert Haas 13:41
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Tom Lane 13:52
Re: Actuall row count of Parallel Seq Scan in EXPLAIN ANALYZE . Robert Haas 13:52
Re: Comment and function argument names are mismatched in bugmgr.c. Robert Haas 13:56
Re: Extract Jsonb key and values Robert Haas 13:57
Re: how is the WAL receiver process stopped and restarted when the network connection is broken and then restored? Robert Haas 13:58
Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner 14:00
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Robert Haas 14:02
Re: Documentation fixes for pg_visibility Amit Kapila 14:09
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Tom Lane 14:11
Re: Postgres_fdw join pushdown - wrong results with whole-row reference Robert Haas 14:15
Re: Postgres_fdw join pushdown - wrong results with whole-row reference Ashutosh Bapat 14:16
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Merlin Moncure 14:20
Re: Reviewing freeze map code 📎 Masahiko Sawada 14:22
Re: fixing consider_parallel for upper planner rels Tom Lane 14:52
The link to download PostgreSQL 9.6 Beta 2 for Windows X64 is broken (The link downloads Beta 1) Jean-Pierre Pelletier 15:07
Re: fixing consider_parallel for upper planner rels Tom Lane 15:09
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Robert Haas 15:25
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Robert Haas 15:27
Re: Postgres_fdw join pushdown - wrong results with whole-row reference Robert Haas 15:32
Re: ToDo: API for SQL statement execution other than SPI Robert Haas 15:39
Re: fixing consider_parallel for upper planner rels Robert Haas 15:53
Re: fixing consider_parallel for upper planner rels Robert Haas 15:55
Re: Documentation fixes for pg_visibility Robert Haas 16:00
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Merlin Moncure 16:00
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Stephen Frost 16:02
Re: Actuall row count of Parallel Seq Scan in EXPLAIN ANALYZE . David G. Johnston 16:06
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Robert Haas 16:07
Re: The link to download PostgreSQL 9.6 Beta 2 for Windows X64 is broken (The link downloads Beta 1) Dave Page 16:12
Re: The link to download PostgreSQL 9.6 Beta 2 for Windows X64 is broken (The link downloads Beta 1) Bruce Momjian 16:19
Re: EXISTS clauses not being optimized in the face of 'one time pass' optimizable expressions Alvaro Herrera 16:45
Re: ToDo: API for SQL statement execution other than SPI Vibhor Kumar 16:51
TLC for EXPLAIN ANALYZE (parallel query and loops) David G. Johnston 17:15
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Andres Freund 17:31
Re: primary_conninfo missing from pg_stat_wal_receiver Alvaro Herrera 17:56
Re: Bad behavior from plpython 'return []' Robert Haas 18:00
Re: Broken handling of lwlocknames.h Tom Lane 18:01
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Peter Geoghegan 18:23
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Peter Eisentraut 18:46
Re: fixing subplan/subquery confusion 📎 Robert Haas 18:59
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Robert Haas 19:10
Re: Broken handling of lwlocknames.h Tom Lane 19:13
Re: Reviewing freeze map code Robert Haas 19:18
Re: Reviewing freeze map code Andres Freund 19:23
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Peter Geoghegan 19:30
[sqlsmith] ERROR: plan should not reference subplan's variable Andreas Seltenreich 19:31
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Peter Geoghegan 19:37
Re: Bad behavior from plpython 'return []' Tom Lane 19:52
Re: Bad behavior from plpython 'return []' Jim Nasby 20:34
Re: Reviewing freeze map code Jim Nasby 20:42
Re: Reviewing freeze map code Andres Freund 20:43
Re: Reviewing freeze map code Jim Nasby 20:49
Re: _mdfd_getseg can be expensive Peter Geoghegan 21:18
Re: [sqlsmith] ERROR: plan should not reference subplan's variable Tom Lane 21:29
Re: Comment and function argument names are mismatched in bugmgr.c. Andres Freund 21:34
Re: pg_replication_origin_xact_reset() and its argument variables Andres Freund 21:51
Re: pg_replication_origin_xact_reset() and its argument variables Tom Lane 22:01
Re: Broken handling of lwlocknames.h Michael Paquier 22:05
Re: [sqlsmith] ERROR: plan should not reference subplan's variable Robert Haas 22:18
Re: [sqlsmith] ERROR: plan should not reference subplan's variable Tom Lane 22:52
Re: Patch to implement pg_current_logfile() function Karl O. Pinc 23:56

July 2, 2016

Thread Author Time
Re: OpenSSL 1.1 breaks configure and more 📎 Andreas Karlsson 00:02
Re: OpenSSL 1.1 breaks configure and more Alvaro Herrera 00:28
Re: OpenSSL 1.1 breaks configure and more Andreas Karlsson 00:45
Re: OpenSSL 1.1 breaks configure and more Andreas Karlsson 00:50
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Noah Misch 02:05
Re: Comment and function argument names are mismatched in bugmgr.c. Masahiko Sawada 02:16
Re: Documentation fixes for pg_visibility Amit Kapila 02:20
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Andreas Karlsson 02:42
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Peter Geoghegan 03:09
Re: Reviewing freeze map code Amit Kapila 03:17
Re: Reviewing freeze map code Amit Kapila 03:34
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Noah Misch 03:37
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Peter Geoghegan 04:12
Re: fixing subplan/subquery confusion Amit Kapila 04:12
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Pavel Stehule 04:40
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Noah Misch 05:01
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Peter Geoghegan 05:40
Re: Re: [ADMIN] problems using pg_start_backup/pg_stop_backup and pg_basebackup at same time Amit Kapila 06:08
Statistics Injection Victor Giannakouris - Salalidis 07:35
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Jim Nasby 10:27
Re: Broken handling of lwlocknames.h Christoph Berg 11:51
Re: OpenSSL 1.1 breaks configure and more Christoph Berg 12:11
Leaking memory in text_overlay function Dirk Rudolph 12:23
9.6beta2: query failure with 'cache lookup failed for type 0' Stefan Huehner 13:10
Docs, backups, and MS VSS Craig Ringer 14:31
Re: Statistics Injection Tom Lane 14:35
Re: Docs, backups, and MS VSS Bruce Momjian 14:42
Re: Leaking memory in text_overlay function Tom Lane 14:45
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Tom Lane 15:07
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Tom Lane 15:11
Re: Leaking memory in text_overlay function Dirk Rudolph 15:11
Re: 9.6beta2: query failure with 'cache lookup failed for type 0' Tom Lane 15:35
Re: 9.6beta2: query failure with 'cache lookup failed for type 0' Stefan Huehner 16:00
Re: 9.6beta2: query failure with 'cache lookup failed for type 0' Christoph Berg 16:04
Re: 9.6beta2: query failure with 'cache lookup failed for type 0' Tom Lane 16:07
Typo Patch 📎 CharSyam 16:17
Column COMMENTs in CREATE TABLE? Marko Tiikkaja 16:55
Re: Column COMMENTs in CREATE TABLE? David G. Johnston 17:06
Re: Statistics Injection 📎 Vladimir Sitnikov 17:28
Re: dumping database privileges broken in 9.6 Noah Misch 18:25
Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Noah Misch 18:29
Re: dumping database privileges broken in 9.6 Stephen Frost 19:03
Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < 📎 Kevin Grittner 19:20
Re: Password identifiers, protocol aging and SCRAM protocol Heikki Linnakangas 19:54
Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Robert Haas 22:10
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Robert Haas 22:17
Re: Password identifiers, protocol aging and SCRAM protocol Michael Paquier 22:32

July 3, 2016

Thread Author Time
Re: Column COMMENTs in CREATE TABLE? Fabrízio de Royes Mello 00:31
to_date_valid() 📎 Andreas 'ads' Scherbaum 01:04
Re: Docs, backups, and MS VSS Craig Ringer 01:07
Re: to_date_valid() Euler Taveira 01:32
Re: Column COMMENTs in CREATE TABLE? David Fetter 02:12
Re: Password identifiers, protocol aging and SCRAM protocol David Steele 03:06
Re: Column COMMENTs in CREATE TABLE? David G. Johnston 03:34
Re: Bug in batch tuplesort memory CLUSTER case (9.6 only) Peter Geoghegan 03:47
Re: to_date_valid() Jaime Casanova 05:05
GiST optimizing memmoves in gistplacetopage for fixed-size updates [PoC] 📎 Andrew Borodin 09:24
Re: GiST optimizing memmoves in gistplacetopage for fixed-size updates [PoC] Alexander Korotkov 10:21
Re: to_date_valid() Andreas 'ads' Scherbaum 10:36
Re: [COMMITTERS] pgsql: Avoid extra locks in GetSnapshotData if old_snapshot_threshold < Kevin Grittner 13:32
Re: Column COMMENTs in CREATE TABLE? Tom Lane 15:41
Re: fixing subplan/subquery confusion Tom Lane 17:14
INSERT .. SET syntax 📎 Marko Tiikkaja 19:36
Re: fixing subplan/subquery confusion Robert Haas 19:45
Re: fixing subplan/subquery confusion Tom Lane 20:42
Re: Password identifiers, protocol aging and SCRAM protocol Peter Eisentraut 21:34
Re: fixing subplan/subquery confusion Tom Lane 22:46
Parallel appendrel scans? Tom Lane 22:58

July 4, 2016

Thread Author Time
Re: Docs, backups, and MS VSS Craig Ringer 00:21
Re: to_date_valid() Craig Ringer 02:25
Re: Parallel appendrel scans? Robert Haas 03:02
Re: to_date_valid() Pavel Stehule 03:19
Re: to_date_valid() Gavin Flower 03:39
Re: primary_conninfo missing from pg_stat_wal_receiver Michael Paquier 03:40
Re: to_date_valid() Pavel Stehule 03:51
Re: Password identifiers, protocol aging and SCRAM protocol Michael Paquier 03:54
Re: Forthcoming SQL standards about JSON and Multi-Dimensional Arrays (FYI) Thomas Munro 04:44
Re: IPv6 link-local addresses and init data type 📎 Haribabu Kommi 05:06
Re: [BUG] pg_basebackup from disconnected standby fails Kyotaro HORIGUCHI 05:41
Re: GiST optimizing memmoves in gistplacetopage for fixed-size updates [PoC] 📎 Andrew Borodin 05:41
Re: An extra error for client disconnection on Windows Kyotaro HORIGUCHI 06:04
[CF2016-9] Allow spaces in working path on tap-tests 📎 Kyotaro HORIGUCHI 07:02
Renaming more clearly SHA functions in pgcrypto/ Michael Paquier 07:15
Re: [CF2016-9] Allow spaces in working path on tap-tests Michael Paquier 07:29

Browse Archives

Prev | Next