pgsql-hackers before 2017-06-11 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 7, 2017

Thread Author Time
Re: PG10 transition tables, wCTEs and multiple operations on the same table Kevin Grittner 22:13
Re: PG10 transition tables, wCTEs and multiple operations on the same table Kevin Grittner 22:21
Re: PG10 transition tables, wCTEs and multiple operations on the same table Peter Geoghegan 22:25
Re: HACKERS[PROPOSAL] split ProcArrayLock into multiple parts Sokolov Yura 22:38
Re: PG10 transition tables, wCTEs and multiple operations on the same table Thomas Munro 23:05
Re: PG10 transition tables, wCTEs and multiple operations on the same table Thomas Munro 23:50

June 8, 2017

Thread Author Time
Re: BEFORE trigger can cause undetected partition constraint violation Amit Langote 00:04
Re: [PATCH] Fixed malformed error message on malformed SCRAM message. Michael Paquier 00:07
Re: Is ECPG's SET CONNECTION really not thread-aware? Tsunakawa, Takayuki 00:23
Re: Notes on testing Postgres 10b1 Peter Eisentraut 00:24
Re: logical replication - possible remaining problem Petr Jelinek 00:50
Re: Use of snapshot in logical replication Craig Ringer 01:08
Re: tap tests on older branches fail if concurrency is used Craig Ringer 01:09
Re: Notes on testing Postgres 10b1 Petr Jelinek 01:10
Re: Use of snapshot in logical replication Petr Jelinek 01:14
Re: Use of snapshot in logical replication Andres Freund 01:18
Re: Notes on testing Postgres 10b1 Josh Berkus 01:19
Re: Notes on testing Postgres 10b1 Petr Jelinek 01:25
Re: Notes on testing Postgres 10b1 Peter Eisentraut 01:37
Re: TAP: allow overriding PostgresNode in get_new_node 📎 Chapman Flack 01:42
Re: Notes on testing Postgres 10b1 Josh Berkus 01:50
Re: Notes on testing Postgres 10b1 Petr Jelinek 02:01
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity Tom Lane 02:01
Re: Fix a typo in snapmgr.c Masahiko Sawada 02:58
Does pg_upgrade really support "make installcheck"? Tom Lane 03:28
Re: Race conditions with WAL sender PID lookups 📎 Michael Paquier 04:15
Re: Re: [GSOC 17] Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions Mengxing Liu 05:07
Re: walsender & parallelism Noah Misch 05:54
Re: walsender termination error messages worse in v10 Noah Misch 05:57
src/include/Makefile is missing statistics directory 📎 Kyotaro HORIGUCHI 05:58
Re: Does pg_upgrade really support "make installcheck"? 📎 Neha Khatri 07:04
Re: Re: Alter subscription..SET - NOTICE message is coming for table which is already removed Masahiko Sawada 07:54
Long binded parameter value in the postgres log Nikitin Nikolay 08:00
List of hostaddrs not supported Heikki Linnakangas 08:36
Re: Adding support for Default partition in partitioning 📎 Ashutosh Bapat 09:24
Re: A bug in mapping attributes in ATExecAttachPartition() Amit Langote 09:43
Re: A bug in mapping attributes in ATExecAttachPartition() Ashutosh Bapat 10:25
Re: Adding support for Default partition in partitioning Ashutosh Bapat 10:34
Re: Adding support for Default partition in partitioning Jeevan Ladhe 10:59
Re: UPDATE of partition key Amit Kapila 11:01
Re: [BUGS] Crash observed during the start of the Postgres process K S, Sandhya (Nokia - IN/Bangalore) 12:25
Re: Parallel Aggregation support for aggregate functions that use transitions not implemented for array_agg Ashutosh Bapat 12:36
Re: Broken hint bits (freeze) Amit Kapila 12:58
Re: Broken hint bits (freeze) Dmitriy Sarafannikov 13:19
Re: List of hostaddrs not supported Tom Lane 13:49
Re: Broken hint bits (freeze) Amit Kapila 14:03
Re: Proposal: Improve bitmap costing for lossy pages Dilip Kumar 14:44
Re: List of hostaddrs not supported Robert Haas 14:46
Re: Does pg_upgrade really support "make installcheck"? Andrew Dunstan 14:49
Re: List of hostaddrs not supported Tom Lane 14:50
Re: Does pg_upgrade really support "make installcheck"? Tom Lane 15:02
Re: List of hostaddrs not supported Robert Haas 15:18
Re: strange error message from slave when connection to master cannot be established Robert Haas 15:19
Re: List of hostaddrs not supported David G. Johnston 15:39
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity Regina Obe 15:57
Re: Long binded parameter value in the postgres log Masahiko Sawada 16:31
Re: Adding support for Default partition in partitioning Robert Haas 16:49
Re: Adding support for Default partition in partitioning Robert Haas 16:56
Re: [PATCH] Fixed malformed error message on malformed SCRAM message. Heikki Linnakangas 17:00
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity 'Andres Freund' 17:07
Re: UPDATE of partition key Robert Haas 17:10
Re: Notes on testing Postgres 10b1 Josh Berkus 17:11
Re: Notes on testing Postgres 10b1 Josh Berkus 17:15
Re: strange error message from slave when connection to master cannot be established Pavel Stehule 17:17
Re: PG10 transition tables, wCTEs and multiple operations on the same table Robert Haas 17:36
Re: PG10 transition tables, wCTEs and multiple operations on the same table Heikki Linnakangas 17:48
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity Tom Lane 17:50
Re: pgbench tap tests & minor fixes 📎 Fabien COELHO 17:56
Re: PG10 transition tables, wCTEs and multiple operations on the same table Robert Haas 17:59
Re: PG10 transition tables, wCTEs and multiple operations on the same table Peter Geoghegan 18:05
jsonb_to_tsvector should be immutable Josh Berkus 18:07
Re: PG10 transition tables, wCTEs and multiple operations on the same table Bruce Momjian 18:11
Re: jsonb_to_tsvector should be immutable Tom Lane 18:26
Re: PG10 transition tables, wCTEs and multiple operations on the same table Robert Haas 18:32
Re: HACKERS[PROPOSAL] split ProcArrayLock into multiple parts Jim Van Fleet 18:33
Re: strange error message from slave when connection to master cannot be established Robert Haas 18:34
Re: PG10 transition tables, wCTEs and multiple operations on the same table Peter Geoghegan 18:55
Re: jsonb_to_tsvector should be immutable Andrew Dunstan 19:03
Re: jsonb_to_tsvector should be immutable Tom Lane 19:06
Re: jsonb_to_tsvector should be immutable Andrew Dunstan 19:27
Re: PG10 transition tables, wCTEs and multiple operations on the same table Robert Haas 20:20
Re: PG10 transition tables, wCTEs and multiple operations on the same table Peter Geoghegan 20:28
Re: PG10 transition tables, wCTEs and multiple operations on the same table Andrew Gierth 20:41
Re: PG10 transition tables, wCTEs and multiple operations on the same table Andrew Gierth 21:01
Re: PG10 transition tables, wCTEs and multiple operations on the same table Thomas Munro 21:15
Re: PG10 transition tables, wCTEs and multiple operations on the same table Tom Lane 21:18
Re: walsender termination error messages worse in v10 Andres Freund 21:57
Re: PG10 transition tables, wCTEs and multiple operations on the same table Robert Haas 22:08
Re: GSOC'17 project introduction: Parallel COPY execution with errors handling Peter Geoghegan 22:09
Re: PG10 transition tables, wCTEs and multiple operations on the same table Robert Haas 22:13
Re: Get stuck when dropping a subscription during synchronizing table Andres Freund 22:48
Re: logical replication busy-waiting on a lock Andres Freund 23:06
Re: PG10 transition tables, wCTEs and multiple operations on the same table Thomas Munro 23:28

June 9, 2017

Thread Author Time
Re: walsender termination error messages worse in v10 Petr Jelinek 01:16
Re: logical replication busy-waiting on a lock Petr Jelinek 01:20
Fix comment in shm_mq.c 📎 Masahiko Sawada 01:58
Re: walsender termination error messages worse in v10 Alvaro Herrera 02:26
Re: Re: [GSOC 17] Eliminate O(N^2) scaling from rw-conflict tracking in serializable transactions Mengxing Liu 02:40
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity 📎 Tom Lane 03:05
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity Andres Freund 03:26
Re: UPDATE of partition key 📎 Amit Khandekar 03:36
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity Tom Lane 03:37
Something is rotten in publication drop Tom Lane 03:53
Re: transition table behavior with inheritance appears broken (was: Declarative partitioning - another take) 📎 Thomas Munro 03:56
Re: PG10 transition tables, wCTEs and multiple operations on the same table 📎 Thomas Munro 04:00
Transition tables vs ON CONFLICT 📎 Thomas Munro 04:10
Re: Proposal : For Auto-Prewarm. Mithun Cy 04:11
Re: Proposal : For Auto-Prewarm. 📎 Mithun Cy 04:31
Re: A bug in mapping attributes in ATExecAttachPartition() Amit Langote 05:01
How to refer to resource files from UDFs written in C Supun Nakandala 05:56
Re: walsender & parallelism Noah Misch 06:04
Re: Re: Alter subscription..SET - NOTICE message is coming for table which is already removed Noah Misch 06:07
Re: Coverage improvements of src/bin/pg_basebackup and pg_receivewal --endpos 📎 Michael Paquier 06:08
Re: BUG #14682: row level security not work with partitioned table Noah Misch 06:09
Re: A bug in mapping attributes in ATExecAttachPartition() 📎 Amit Langote 06:13
Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog Noah Misch 06:17
Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog Michael Paquier 06:23
Re: strcmp() tie-breaker for identical ICU-collated strings Amit Khandekar 06:27
Re: How to refer to resource files from UDFs written in C Heikki Linnakangas 07:05
Re: snapbuild woes Antonin Houska 07:25
ECPG: WHENEVER statement with DO CONTINUE action 📎 vinayak 08:01
Re: Surjective functional indexes 📎 Konstantin Knizhnik 08:08
Re: ECPG: WHENEVER statement with DO CONTINUE action Michael Meskes 08:38
Re: List of hostaddrs not supported Heikki Linnakangas 09:52
pgsql: Give a better error message on invalid hostaddr option. Heikki Linnakangas 10:06
Re: List of hostaddrs not supported Mithun Cy 10:22
Re: List of hostaddrs not supported 📎 Heikki Linnakangas 10:36
Re: A bug in mapping attributes in ATExecAttachPartition() Ashutosh Bapat 11:47
Re: A bug in mapping attributes in ATExecAttachPartition() Ashutosh Bapat 11:49
Re: walsender termination error messages worse in v10 Peter Eisentraut 12:31
Re: BUG #14682: row level security not work with partitioned table Joe Conway 13:16
Re: List of hostaddrs not supported Robert Haas 13:26
Re: Re: Alter subscription..SET - NOTICE message is coming for table which is already removed Peter Eisentraut 13:30
Re: UPDATE of partition key Amit Kapila 13:40
Re: How to refer to resource files from UDFs written in C Tom Lane 13:45
Re: Re: Alter subscription..SET - NOTICE message is coming for table which is already removed 📎 Peter Eisentraut 13:50
Re: Re: Alter subscription..SET - NOTICE message is coming for table which is already removed Peter Eisentraut 13:52
Re: Notes on testing Postgres 10b1 Peter Eisentraut 13:57
Re: UPDATE of partition key Amit Khandekar 14:18
Re: Fix tab-completion of ALTER SUBSCRIPTION SET PUBLICATION Peter Eisentraut 14:18
Re: strcmp() tie-breaker for identical ICU-collated strings Robert Haas 14:31
Re: Proposal : For Auto-Prewarm. Amit Kapila 14:37
Re: List of hostaddrs not supported Jeff Janes 14:47
Re: strcmp() tie-breaker for identical ICU-collated strings Peter Eisentraut 15:05
Re: strcmp() tie-breaker for identical ICU-collated strings Tom Lane 15:12
partial aggregation with internal state type Jeff Janes 15:24
Re: Something is rotten in publication drop Peter Eisentraut 15:25
Re: strcmp() tie-breaker for identical ICU-collated strings Peter Eisentraut 15:29
Re: Fix comment in shm_mq.c Peter Eisentraut 15:40
Re: Fix comment in shm_mq.c Masahiko Sawada 15:44
Re: Something is rotten in publication drop Tom Lane 15:45
Re: strcmp() tie-breaker for identical ICU-collated strings Tom Lane 15:46
BUG #14699: Statement trigger and logical replication konst583 16:01
Re: partial aggregation with internal state type Tom Lane 16:06
Re: strcmp() tie-breaker for identical ICU-collated strings Robert Haas 16:17
Re: strcmp() tie-breaker for identical ICU-collated strings Peter Geoghegan 16:18
Re: transition table behavior with inheritance appears broken (was: Declarative partitioning - another take) Robert Haas 16:19
Re: partial aggregation with internal state type Jeff Janes 16:47
Re: How to refer to resource files from UDFs written in C Supun Nakandala 17:04
Re: partial aggregation with internal state type Tom Lane 17:14
Re: strcmp() tie-breaker for identical ICU-collated strings Robert Haas 17:45
Re: strcmp() tie-breaker for identical ICU-collated strings Peter Eisentraut 17:45
Re: strcmp() tie-breaker for identical ICU-collated strings Peter Geoghegan 18:01
Re: Typo in xlogfuncs.c [WAS Re: Incorrect mention of pg_xlog_switch() in xlogfuncs.c] Peter Eisentraut 18:04
Re: transition table behavior with inheritance appears broken (was: Declarative partitioning - another take) Robert Haas 18:08
Re: strcmp() tie-breaker for identical ICU-collated strings Robert Haas 18:09
Re: transition table behavior with inheritance appears broken Andrew Gierth 18:27
Re: Tightening isspace() tests where behavior should match SQL parser Peter Eisentraut 18:36
HACKERS[PATCH] split ProcArrayLock into multiple parts 📎 Jim Van Fleet 18:39
Re: List of hostaddrs not supported Tom Lane 18:51
Re: List of hostaddrs not supported Heikki Linnakangas 18:52
Re: walsender & parallelism Andres Freund 18:56
Re: List of hostaddrs not supported Jeff Janes 19:45
Re: PG10 transition tables, wCTEs and multiple operations on the same table Robert Haas 19:48
Re: walsender & parallelism Petr Jelinek 19:52
Re: logical replication busy-waiting on a lock 📎 Petr Jelinek 20:28
Re: logical replication busy-waiting on a lock Andres Freund 20:31
Re: PROVE_FLAGS Peter Eisentraut 20:47
logical replication NOTICE "synchronized table states" Jeff Janes 21:06
Re: Logical replication in the same cluster Peter Eisentraut 21:16
Re: PG10 transition tables, wCTEs and multiple operations on the same table Peter Geoghegan 21:19
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity 📎 Tom Lane 21:33
Re: [BUGS] BUG #14682: row level security not work with partitioned table 📎 Joe Conway 21:52
logical replication: \dRp+ and "for all tables" Jeff Janes 22:29
Re: logical replication NOTICE "synchronized table states" Peter Eisentraut 23:17

June 10, 2017

Thread Author Time
Re: UPDATE of partition key Amit Kapila 02:11
Re: Notes on testing Postgres 10b1 Greg Stark 02:54
Re: ECPG: WHENEVER statement with DO CONTINUE action Vinayak Pokale 03:23
Re: logical replication: \dRp+ and "for all tables" 📎 Masahiko Sawada 05:20
Re: logical replication: \dRp+ and "for all tables" 📎 Jeff Janes 06:02
Re: BUG #14680: startup process on standby encounter a deadlock of TwoPhaseStateLock when redo 2PC xlog Noah Misch 06:31
tablesync.c - comment improvements 📎 Erik Rijkers 08:52
ICU support on Windows 📎 Ashutosh Sharma 09:40
Getting server crash on Windows when using ICU collation Ashutosh Sharma 09:55
Re: PG10 transition tables, wCTEs and multiple operations on the same table Alvaro Herrera 13:13
Re: logical replication: \dRp+ and "for all tables" Tom Lane 14:42
Re: PostgreSQL 10 changes in exclusion constraints - did something change? CASE WHEN behavior oddity 📎 Alvaro Herrera 18:04
Re: Notes on testing Postgres 10b1 Josh Berkus 18:33
memory fields from getrusage() Justin Pryzby 22:20
Re: GSoC 2017: Foreign Key Arrays 📎 Mark Rofail 22:35

Browse Archives

Prev | Next