Re: pg_dump roles support [Review]

Поиск
Список
Период
Сортировка
От Benedek László
Тема Re: pg_dump roles support [Review]
Дата
Msg-id 4912FA4E.1090000@benedekl.tvnetwork.hu
обсуждение исходный текст
Ответ на pg_dump roles support [Review]  ("Ibrar Ahmed" <ibrar.ahmad@gmail.com>)
Ответы Re: pg_dump roles support [Review]  ("Ibrar Ahmed" <ibrar.ahmad@gmail.com>)
Re: pg_dump roles support [Review]  (Abhijit Menon-Sen <ams@oryx.com>)
Re: pg_dump roles support [Review]  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
Hi,

Thanks for your review.

I created an updated patch according to your notices.

> 1 - Patch does not apply cleanly on latest git repository, although
> there is no hunk failed but there are some hunk succeeded messages.
Rebased to the current HEAD.

> 2- Patch contains unnecessary spaces and tabs which makes the patch
> unnecessarily big. IMHO please read the patch before sending and make
> sure that patch only contains the changes you intended to send.
Yes, there were trailing whitespaces in the original files which
were removed by the previous patch. The attached version leaves them as is.

> 3 - We should follow the coding standards of existing code
I tried, of course, but this escaped my observation.

> 4 - pg_restore gives error wile restoring custom format backup
> 5 - Do you really want to write this code like this
Fixed.

I also need some feedback about the role support in pg_restore (not implemented yet).
Currently pg_restore sets the role during the restore process according to the TOC
entry in the archive. It may also support the --role option (just like pg_dump).
If specified it can be used to cancel the effect of the TOC entry and force the
emitting of the SET ROLE ... command. With emtpy argument it can be used to omit
the SET ROLE even if it is specified in the archieve. What do you think?

Thank you again.

   doc/src/sgml/ref/pg_dump.sgml        |   16 ++++++++++
   doc/src/sgml/ref/pg_dumpall.sgml     |   15 +++++++++
   src/bin/pg_dump/pg_backup.h          |    2 +
   src/bin/pg_dump/pg_backup_archiver.c |   36 +++++++++++++++++++++-
   src/bin/pg_dump/pg_dump.c            |   53 ++++++++++++++++++++++++++++++++++
   src/bin/pg_dump/pg_dumpall.c         |   23 ++++++++++++++
   6 files changed, 143 insertions(+), 2 deletions(-)



Вложения

В списке pgsql-hackers по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: [PATCH] EnableDisableTrigger Cleanup & Questions
Следующее
От: KaiGai Kohei
Дата:
Сообщение: Re: The suppress_redundant_updates_trigger() works incorrectly