Re: pg_dump multi VALUES INSERT
David Rowley <david.rowley@2ndquadrant.com>
From: David Rowley <david.rowley@2ndquadrant.com>
To: Surafel Temesgen <surafel3000@gmail.com>
Cc: Fabien COELHO <coelho@cri.ensmp.fr>,
Dmitry Dolgov <9erthalion6@gmail.com>, Alvaro Herrera <alvherre@2ndquadrant.com>, PostgreSQL-development <pgsql-hackers@postgresql.org>
Date: 2019-01-18T11:29:17Z
Lists: pgsql-hackers
On Fri, 18 Jan 2019 at 19:29, Surafel Temesgen <surafel3000@gmail.com> wrote: > this happen because i don't disallow the usage of --inserts and --rows-per-insert > option together.it should be error out in those case.i correct it in attached patch I don't think it should be an error. It's not like the two options conflict. I imagined that you'd need to specify you want --inserts and optionally could control how many rows per statement that would be put in those commands. I'd be surprised to be confronted with an error for asking for that. It might be worth doing the same as what we do if --column-inserts is specified without --inserts. In this case we just do: /* --column-inserts implies --inserts */ if (dopt.column_inserts) dopt.dump_inserts = 1; If you do it that way you'll not need to modify the code much from how I wrote it. We can likely debate if we want --rows-per-insert to imply --inserts once there's a working patch. -- David Rowley http://www.2ndQuadrant.com/ PostgreSQL Development, 24x7 Support, Training & Services
Commits
-
Add pg_dumpall --rows-per-insert
- a193cbec1199 12.0 landed
-
pg_dump: allow multiple rows per insert
- 7e413a0f82c8 12.0 landed