pgsql-hackers since 2018-06-14 00:00

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

June 14, 2018

Thread Author Time
Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" 小威 00:08
Re: commitfest 2018-07 Michael Paquier 00:24
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Tsunakawa, Takayuki 00:42
Re: pg_config.h.win32 missing a set of flags from pg_config.h.in added in v11 development Andrew Dunstan 00:55
RE: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Tsunakawa, Takayuki 00:58
Re: pg_config.h.win32 missing a set of flags from pg_config.h.in added in v11 development 📎 Michael Paquier 01:49
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Michael Paquier 01:57
Re: BUG #15212: Default values in partition tables don't work as expected and allow NOT NULL violation Amit Langote 02:07
Re: Partitioning with temp tables is broken Michael Paquier 02:09
Re: Index maintenance function for BRIN doesn't check RecoveryInProgress() Michael Paquier 02:12
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Masahiko Sawada 02:22
Re: [HACKERS] Pluggable storage Amit Kapila 02:25
Shared access methods? Andres Freund 02:37
[GSoC] current working status Charles Cui 03:00
Re: WAL prefetch Amit Kapila 03:45
Two round for Client Authentication Yinjie Lin 04:12
Re: Partitioning with temp tables is broken 📎 Amit Langote 04:12
Re: Two round for Client Authentication Marko Tiikkaja 04:54
Re: Two round for Client Authentication David G. Johnston 04:56
question on streaming replication Atul Kumar 05:28
Re: Partitioning with temp tables is broken Amit Langote 05:29
Re: Postgres, fsync, and OSs (specifically linux) Thomas Munro 05:30
ntile() throws ERROR when hashagg is false Rajkumar Raghuwanshi 06:06
Re: WAL prefetch Thomas Munro 06:52
Re: ntile() throws ERROR when hashagg is false Andrew Gierth 06:57
Re: WAL prefetch Konstantin Knizhnik 07:13
Re: why partition pruning doesn't work? 📎 Amit Langote 07:17
Re: Needless additional partition check in INSERT? Amit Langote 07:49
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Amit Langote 08:24
Re: [PROPOSAL] Shared Ispell dictionaries 📎 Arthur Zakirov 08:40
Re: [GSoC] current working status Aleksander Alekseeev 08:41
Re: why partition pruning doesn't work? David Rowley 09:49
Re: ntile() throws ERROR when hashagg is false David Rowley 10:20
Re: ON CONFLICT DO NOTHING on pg_dump 📎 Surafel Temesgen 10:39
Re: pgsql: Store 2PC GID in commit/abort WAL recs for logical decoding 📎 Nikhil Sontakke 11:02
Re: why partition pruning doesn't work? David Rowley 11:23
Re: Logging transaction IDs for DDL. Magnus Hagander 11:36
Re: SCRAM with channel binding downgrade attack Magnus Hagander 11:43
server crashed with TRAP: FailedAssertion("!(!parallel_aware || pathnode->path.parallel_safe)" Rajkumar Raghuwanshi 11:56
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Marina Polyakova 12:11
Re: question on streaming replication Fabio Pardi 12:14
Re: [HACKERS] WIP Patch: Pgbench Serialization and deadlock errors Marina Polyakova 12:16
Re: why partition pruning doesn't work? Robert Haas 12:40
Re: Locking B-tree leafs immediately in exclusive mode Alexander Korotkov 12:43
Re: WAL prefetch Robert Haas 12:44
Re: Shared access methods? Alexander Korotkov 12:59
Re: late binding of shared libs for C functions Robert Haas 13:00
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Ashutosh Bapat 13:00
Re: WAL prefetch Amit Kapila 13:02
Re: Few cosmetic suggestions for commit 16828d5c (Fast Alter Table Add Column...) Amit Kapila 13:10
Re: Partitioning with temp tables is broken Ashutosh Bapat 13:11
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Robert Haas 13:13
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Robert Haas 13:19
Re: WAL prefetch Konstantin Knizhnik 13:23
Re: WAL prefetch Robert Haas 13:25
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Ashutosh Bapat 13:37
Re: WAL prefetch Konstantin Knizhnik 13:39
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Ashutosh Bapat 13:45
Re: Fix some error handling for read() and errno Robert Haas 13:50
Re: Locking B-tree leafs immediately in exclusive mode Claudio Freire 13:56
Re: Locking B-tree leafs immediately in exclusive mode Alexander Korotkov 14:13
Re: Needless additional partition check in INSERT? Alvaro Herrera 14:23
Re: why partition pruning doesn't work? Tom Lane 14:40
Re: Partitioning with temp tables is broken Tom Lane 14:42
Re: Microoptimization of Bitmapset usage in postgres_fdw Nathan Bossart 14:56
Re: [GSoC] current working status Charles Cui 14:58
Re: ntile() throws ERROR when hashagg is false Tom Lane 14:58
Re: [GSoC] current working status Aleksander Alekseeev 15:03
Re: [GSoC] current working status Charles Cui 15:29
Re: Locking B-tree leafs immediately in exclusive mode Peter Geoghegan 15:31
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Rui DeSousa 15:39
Re: Locking B-tree leafs immediately in exclusive mode Alexander Korotkov 15:40
Re: [Proposal] Table-level Transparent Data Encryption (TDE) and Key Management Service (KMS) Masahiko Sawada 16:19
Re: server crashed with TRAP: FailedAssertion("!(!parallel_aware || pathnode->path.parallel_safe)" Tom Lane 16:24
Re: AtEOXact_ApplyLauncher() and subtransactions Alvaro Herrera 16:28
Re: server crashed with TRAP: FailedAssertion("!(!parallel_aware || pathnode->path.parallel_safe)" Tom Lane 16:35
Re: Shared access methods? Andres Freund 17:10
Re: Index maintenance function for BRIN doesn't check RecoveryInProgress() Alvaro Herrera 17:20
Re: PostgreSQL vs SQL Standard Alvaro Herrera 17:34
Re: commitfest 2018-07 Andrew Dunstan 17:45
Re: Few cosmetic suggestions for commit 16828d5c (Fast Alter Table Add Column...) Alvaro Herrera 18:01
Re: commitfest 2018-07 Stephen Frost 18:23
Making all nbtree entries unique by having heap TIDs participate in comparisons 📎 Peter Geoghegan 18:44
Re: WAL prefetch Stephen Frost 18:46
Re: Attempt to fix inheritance limitations: unique and foreign key constraints Robert Haas 18:47
Re: Few cosmetic suggestions for commit 16828d5c (Fast Alter Table Add Column...) Andrew Dunstan 19:24
Re: Microoptimization of Bitmapset usage in postgres_fdw 📎 Daniel Gustafsson 19:32
Re: Portability concerns over pq_sendbyte? Alvaro Herrera 19:51
Re: Transform for pl/perl Alvaro Herrera 19:54
Re: Possible bug in logical replication. Alvaro Herrera 20:06
Re: Shared access methods? Tom Lane 20:10
Re: Microoptimization of Bitmapset usage in postgres_fdw Bossart, Nathan 20:14
Re: Portability concerns over pq_sendbyte? Tom Lane 20:17
Re: Shared access methods? Andres Freund 20:23
Re: Portability concerns over pq_sendbyte? Andres Freund 20:25
Re: Shared access methods? Alvaro Herrera 20:33
Re: Shared access methods? Andres Freund 20:38
Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" Robert Haas 21:26
Re: [HACKERS] Optional message to user when terminating/cancelling backend 📎 Daniel Gustafsson 21:56
Re: Duplicate Item Pointers in Gin index R, Siva 22:55
row_to_json(), NULL values, and AS Neil Conway 22:57
Bogus dependency calculation for expressions involving casts Tom Lane 23:07
Re: row_to_json(), NULL values, and AS Tom Lane 23:28

June 15, 2018

Thread Author Time
Re: Partitioning with temp tables is broken Amit Langote 01:05
Re: [GSoC] current working status Charles Cui 01:16
Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" Justin Pryzby 01:38
Re: Partitioning with temp tables is broken Amit Langote 01:38
Re: Partitioning with temp tables is broken David Rowley 01:59
RE: ON CONFLICT DO NOTHING on pg_dump Ideriha, Takeshi 02:20
Re: Partitioning with temp tables is broken Tom Lane 02:38
Re: ntile() throws ERROR when hashagg is false Andrew Gierth 02:50
Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" Andrew Gierth 03:59
Re: Few cosmetic suggestions for commit 16828d5c (Fast Alter Table Add Column...) 📎 Amit Kapila 04:16
Re: AtEOXact_ApplyLauncher() and subtransactions Peter Eisentraut 04:16
Re: automating perl compile time checking Peter Eisentraut 04:21
Re: WAL prefetch Amit Kapila 04:36
RE: ON CONFLICT DO NOTHING on pg_dump Ideriha, Takeshi 05:06
Re: Problem while updating a foreign table pointing to a partitioned table on foreign server Ashutosh Bapat 05:49
Re: Two round for Client Authentication Yinjie Lin 06:02
Re: Remove mention in docs that foreign keys on partitioned tables are not supported 📎 Amit Langote 06:16
Memory leaks in BufFileOpenShared() Antonin Houska 06:54
Re: Memory leaks in BufFileOpenShared() Tatsuo Ishii 07:20
Getting "ERROR: did not find all requested child rels in append_rel_list" when enable_partition_pruning is on Rajkumar Raghuwanshi 07:32
Re: WAL prefetch Konstantin Knizhnik 07:38
Re: Getting "ERROR: did not find all requested child rels in append_rel_list" when enable_partition_pruning is on Amit Langote 07:41
Re: Attempt to fix inheritance limitations: unique and foreign key constraints Raphael Medaer 07:45
Re: Memory leaks in BufFileOpenShared() 📎 Antonin Houska 07:59
Re: Memory leaks in BufFileOpenShared() Tatsuo Ishii 08:22
Re: [GSoC] current working status Aleksander Alekseeev 08:33
Re: Index maintenance function for BRIN doesn't check RecoveryInProgress() Masahiko Sawada 08:37
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian Amit Langote 08:37
Re: why partition pruning doesn't work? 📎 Amit Langote 08:39
Re: Memory leaks in BufFileOpenShared() Antonin Houska 08:42
Re: Memory leaks in BufFileOpenShared() Thomas Munro 08:54
Re: Memory leaks in BufFileOpenShared() Tatsuo Ishii 09:07
Re: Possible bug in logical replication. Masahiko Sawada 09:11
Re: why partition pruning doesn't work? Amit Langote 09:30
Re: automating perl compile time checking Andrew Dunstan 11:06
Re: Jsonb transform for pl/python 📎 Nikita Glukhov 11:10
Re: Internal error XX000 with enable_partition_pruning=on, pg 11 beta1 on Debian David Rowley 11:41
Re: Jsonb transform for pl/python Alexander Korotkov 11:42
Re: Expression errors with "FOR UPDATE" and postgres_fdw with partition wise join enabled. Etsuro Fujita 11:56
Refactoring query_planner() callback 📎 Heikki Linnakangas 12:59
Re: why partition pruning doesn't work? Andrew Dunstan 13:58
Re: why partition pruning doesn't work? Tom Lane 14:02
Re: why partition pruning doesn't work? Andrew Dunstan 14:25
Re: question on streaming replication Amit Kapila 14:36
Re: row_to_json(), NULL values, and AS Tom Lane 14:53
Re: [GSoC] current working status Charles Cui 14:58
Re: WAL prefetch Amit Kapila 15:03
Re: Make description of heap records more talkative for flags Nathan Bossart 15:08
Re: WAL prefetch Konstantin Knizhnik 15:15
Re: Possible bug in logical replication. 📎 Arseny Sher 15:27
Re: question on streaming replication Andreas Kretschmer 16:43
Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" 📎 Tom Lane 17:21
Re: row_to_json(), NULL values, and AS Neil Conway 17:22
Re: Speedup of relation deletes during recovery Andres Freund 17:45
Re: Speedup of relation deletes during recovery Teodor Sigaev 17:54
Re: WAL prefetch Andres Freund 18:01
Removing "Included attributes in B-tree indexes" section from docs 📎 Peter Geoghegan 18:08
Re: Speedup of relation deletes during recovery Andres Freund 18:28
Re: AtEOXact_ApplyLauncher() and subtransactions 📎 Amit Khandekar 18:33
Re: missing toast table for pg_policy 📎 John Naylor 18:40
Re: BUG #15237: I got "ERROR: source for a multiple-column UPDATE item must be a sub-SELECT or ROW() expression" Andrew Gierth 18:47
Procedure additions to ParseFuncOrColumn are inadequate 📎 Tom Lane 19:00
Re: pgsql: Store 2PC GID in commit/abort WAL recs for logical decoding Alvaro Herrera 19:04
Re: pgsql: Store 2PC GID in commit/abort WAL recs for logical decoding Alvaro Herrera 19:04
Re: pgsql: Store 2PC GID in commit/abort WAL recs for logical decoding 📎 Alvaro Herrera 19:12
Re: missing toast table for pg_policy Joe Conway 19:15
Re: Spilling hashed SetOps and aggregates to disk David Gershuni 19:30
Re: row_to_json(), NULL values, and AS 📎 Tom Lane 19:34
Re: [HACKERS] Statement-level rollback Alvaro Herrera 20:23
Re: SCRAM with channel binding downgrade attack Robert Haas 21:23
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Robert Haas 21:36
pg_upgrade from 9.4 to 10.4 Vimalraj A 22:01
Re: Making all nbtree entries unique by having heap TIDs participate in comparisons Peter Geoghegan 23:46

June 16, 2018

Thread Author Time
Re: [HACKERS] Statement-level rollback MauMau 01:42
Re: WAL prefetch Amit Kapila 03:30
Re: WAL prefetch Amit Kapila 03:33
Re: Remove mention in docs that foreign keys on partitioned tables are not supported Robert Haas 03:59
Re: [HACKERS] Statement-level rollback Robert Haas 04:13
Re: WAL prefetch Konstantin Knizhnik 05:12
Re: server crashed with TRAP: FailedAssertion("!(!parallel_aware || pathnode->path.parallel_safe)" 📎 Amit Kapila 05:14
Re: server crashed with TRAP: FailedAssertion("!(!parallel_aware || pathnode->path.parallel_safe)" Amit Kapila 05:14
Re: WAL prefetch Konstantin Knizhnik 05:17
Re: WAL prefetch Amit Kapila 05:23
Re: Memory leaks in BufFileOpenShared() Tatsuo Ishii 05:44
Re: ON CONFLICT DO NOTHING on pg_dump Dilip Kumar 08:36
Re: WAL prefetch Tomas Vondra 09:38
Re: WAL prefetch Thomas Munro 10:06
Re: WAL prefetch Tomas Vondra 10:24
Re: [HACKERS] Statement-level rollback Simon Riggs 10:26
Re: Postgres 11 release notes Darafei Komяpa Praliaskouski 12:56
Re: WAL prefetch Stephen Frost 13:20
Re: server crashed with TRAP: FailedAssertion("!(!parallel_aware || pathnode->path.parallel_safe)" 📎 Amit Kapila 14:00
Query Rewrite for Materialized Views (Postgres Extension) John Dent 14:21
Re: row_to_json(), NULL values, and AS Tom Lane 14:42
Re: POC: GROUP BY optimization Tomas Vondra 15:59
Re: GCC 8 warnings 📎 Tom Lane 17:29
Re: GCC 8 warnings Andres Freund 18:52

Browse Archives

Prev | Next