Re: pg_dump multi VALUES INSERT

Поиск
Список
Период
Сортировка
Искать
От
Surafel Temesgen
Тема
Re: pg_dump multi VALUES INSERT
Дата
Msg-id
CALAY4q-ak24wXCbDm7wYYy6WpyXzb3T519Z-OYrtkwrQ00QwXA@mail.gmail.com
Ответ на
Список
Дерево обсуждения
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>


On Sun, Feb 3, 2019 at 11:00 AM Fabien COELHO <coelho@cri.ensmp.fr> wrote:

Hello David,

>> I do not understand why dump_inserts declaration has left the "flags for
>> options" section.
>
> I moved that because it's no longer just a flag. It now stores an int value.

Hmmm. Indeed, all th "int"s of this section should be "bool" instead. Now,
some "flags" do not appear although the culd (clear, createdb, blobs), so
the logic is kinda fuzzy anyway. Do as you wish.

>> I'd suggest not to rely on "atoi" because it does not check the argument
>> syntax, so basically anything is accepted, eg "1O" is 1;
>
> Seems like it's good enough for --jobs and --compress.   Do you think
> those should be changed too? or what's the reason to hold
> --rows-per-insert to a different standard?

I think that there is a case for avoiding sloppy "good enough" programming
practices:-) Alas, as you point out, "atoi" is widely used. I'm campaining
to avoid adding more of them. There has been some push to actually remove
"atoi" when not appropriate, eg from "libpq". I'd suggest to consider
starting doing the right thing, and left fixing old patterns to another
patch.


 
at least for processing user argument i think it is better to use strtol or other
function that have better error handling. i can make a patch that change usage
of atoi for user argument processing after getting feedback from here or i will do
simultaneously 

regards
Surafel
 
В списке pgsql-hackers по дате отправления
От: Andres Freund
Дата:
От: Andres Freund
Дата:
Сообщение: Re: Undo logs
FAQ