On Fri, Jun 2, 2017 at 10:19 AM, Joe Conway <m...@joeconway.com> wrote: >> Yeah, that's not crazy. I find it a bit surprising in terms of the >> semantics, though. SET >> when_i_try_to_insert_into_a_specific_partition_i_dont_really_mean_it = >> true? > > Maybe > SET partition_tuple_retry = true; > -or- > SET partition_tuple_reroute = true; > ? > > I like the idea of only rerouting when failing constraints although I > can envision where there might be use cases where you essentially want > to re-partition and therefore reroute everything, leading to: > > SET partition_tuple_reroute = (none | error | all);
Personally, I think it's more elegant to make this a pg_dump option than to make it a server GUC, but I'm not going to spend time fighting the server GUC idea if other people like it. -- Robert Haas EnterpriseDB: http://www.enterprisedb.com The Enterprise PostgreSQL Company -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-hackers
