Re: [HACKERS] pg_dump

2015-10-29 Thread Дмитрий Воронин
>  It's a problem. See this recent discussion: >   > http://www.postgresql.org/message-id/flat/20150710115735.gh26...@alap3.anarazel.de Postgresmen, we have a SQL function "current_database", which can be called by statement "SELECT CURRENT_CATALOG". If we will use CURRENT_CATALOG keyword, we

Re: [HACKERS] pg_dump

2015-10-29 Thread Дмитрий Воронин
David, do you want to have one dumper program for postgres? Maybe it will be a good idea to make a dumper with some dumping levels: - all cluster - global objects - database level -- Sent via pgsql-hackers mailing list (pgsql-hackers@postgresql.org) To make changes to your subscription:

Re: [HACKERS] pg_dump

2015-10-29 Thread Дмитрий Воронин
>>  Maybe it will be a good idea to make a dumper with some dumping levels: >>  - all cluster >>  - global objects >>  - database level > > I'm not sure I understand. Is there some utility in dividing this > into these particular levels? -all cluster -- it's what pg_dumpall and pg_dump do. -

Re: [HACKERS] pg_dump

2015-10-30 Thread Дмитрий Воронин
> More specifically, I am not quite understanding the distinction > between "all cluster" and "global objects." all cluster is roles, tablespaces, databases with it's content. global objects is roles, tablespaces. > What do you have in mind on the implementation side? Do you think > pg_dump is

Re: [HACKERS] New functions

2015-07-08 Thread Дмитрий Воронин
07.07.2015, 18:34, Michael Paquier michael.paqu...@gmail.com:  Speaking of which, I have rewritten the patch as attached. This looks  way cleaner than the previous version submitted. Dmitry, does that  look fine for you?  I am switching this patch as Waiting on Author.  Regards,  --  

[HACKERS] psql autocomplete works not good in USER command in 9.6

2016-10-06 Thread Дмитрий Воронин
Hello, I find, that autocomplete does not works good when I type in psql some USER commands: CREATE USER ... ALTER USER ... psql's autocomplete returns database users and "pg_signal_backend" function, I suppose, that is not correct. I try to undestand reasons and make a patch if those

Re: [HACKERS] pg_dump issues

2017-07-26 Thread Дмитрий Воронин
Hello, 25.07.2017, 11:17, "Victor Drobny" : > > Hello, > > Do you expect to have some flag like '--rename=test->test2'? Yes, I do. > Will dump with test replaced by test2(of course only in related places) > be valid dump in this case? Yes, it will. > What is the

[HACKERS] pg_dump issues

2017-06-05 Thread Дмитрий Воронин
Hello,We are working on one project with postgres as engeneer.Bellow is list of inconveniences that we are having with postgresql. We would like to solve them as possible.We can't create any schema dump with another (user defined) name. E.g. we dump schema test and we want to save it's dump with

[HACKERS] Warnings in objectaddress.c

2017-10-01 Thread Дмитрий Воронин
Hello, hackers! I'm building PostgreSQL 10 rc1 sources on Debian wheezy (gcc 4.7). I have those warnings: objectaddress.c: In function ‘get_object_address’: objectaddress.c:1646:10: warning: ‘typeoids[1]’ may be used uninitialized in this function [-Wmaybe-uninitialized]