Postgres Pro
Downloads
Home   >   mailing lists

Re: patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c - Mailing list pgsql-hackers

From Tom Lane
Subject Re: patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c
Date
Msg-id 19636.1311810719@sss.pgh.pa.us
Whole thread Raw
In response to patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c  (Phil Sorber <phil@omniti.com>)
Responses Re: patch: move dumpUserConfig call in dumpRoles function of pg_dumpall.c
List pgsql-hackers
Tree view 
Phil Sorber <phil@omniti.com> writes:
> Currently if you use 'ALTER ROLE rolename SET ROLE', pg_dumpall will
> dump an 'ALTER ROLE' out right after the 'CREATE ROLE' statement.

I think pg_dumpall is the very least of your problems if you do
something like that.  We probably ought to forbid it entirely.
        regards, tom lane

pgsql-hackers by date:

Previous
From: Florian Pflug
Date:
Subject: Re: Is a heads-up in 9.1 in order regarding the XML-related changes in 9.2?
Next
From: Tom Lane
Date:
Subject: Ripping out pg_restore's attempts to parse SQL before sending it