Re: pg_dump multi VALUES INSERT
От
Fabien COELHO
Тема
Re: pg_dump multi VALUES INSERT
Дата
Msg-id
alpine.DEB.2.21.1812251218060.32444@lancre
Ответ на
Re: pg_dump multi VALUES INSERT (Surafel Temesgen)
Список
Дерево обсуждения
pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT Tom Lane <tgl@sss.pgh.pa.us>
Re: pg_dump multi VALUES INSERT Stephen Frost <sfrost@snowman.net>
Re: pg_dump multi VALUES INSERT Michael Paquier <michael@paquier.xyz>
Re: pg_dump multi VALUES INSERT Stephen Frost <sfrost@snowman.net>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Pavel Stehule <pavel.stehule@gmail.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT Dmitry Dolgov <9erthalion6@gmail.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT "David G. Johnston" <david.g.johnston@gmail.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT "David G. Johnston" <david.g.johnston@gmail.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT "David G. Johnston" <david.g.johnston@gmail.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT Michael Paquier <michael@paquier.xyz>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT Michael Paquier <michael@paquier.xyz>
Re: pg_dump multi VALUES INSERT Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Peter Eisentraut <peter.eisentraut@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Fabien COELHO <coelho@cri.ensmp.fr>
Re: pg_dump multi VALUES INSERT Alvaro Herrera <alvherre@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Re: pg_dump multi VALUES INSERT David Rowley <david.rowley@2ndquadrant.com>
Re: pg_dump multi VALUES INSERT Surafel Temesgen <surafel3000@gmail.com>
Hello Surafel, > Thank you for informing, Here is an updated patch against current master Patch applies cleanly, compiles, "make check" is okay, but given that the feature is not tested... Feature should be tested somewhere. ISTM that command-line switches with optional arguments should be avoided: This feature is seldom used (hmmm... 2 existing instances), because it interferes with argument processing if such switches are used as the last one. It is only okay with commands which do not expect arguments. For backward compatibility, this suggests to add another switch, eg --insert-multi=100 or whatever, which would possibly default to 100. The alternative is to break compatibility with adding a mandatory argument, but I guess it would not be admissible to committers. Function "atoi" parses "1zzz" as 1, which is debatable, so I'd suggest to avoid it and use some stricter option and error out on malformed integers. The --help output does not document the --inserts argument, nor the documentation. There is an indendation issue within the while loop. Given that the implementation is largely a copy-paste of the preceding function, I'd suggest to simply extend it so that it takes into account the "multi insert" setting and default to the previous behavior if not set. -- Fabien.
В списке pgsql-hackers по дате отправления