David J N Begley <[EMAIL PROTECTED]> writes:
> I have verified that _no_ GRANT/REVOKE commands are dumped for the database,
> and only some GRANT/REVOKE commands are dumped for "language" objects (see
> below);
The latter is not really a bug. Languages don't currently have owners
(ie there is no
Tom Lane wrote:
> Given that -C overlaps pg_dumpall functionality anyway, maybe it should
> dump GRANT/REVOKE commands for the database too? Any thoughts pro or
> con out there?
I agree. Why have only half a funcionality if we can have the whole
thing? Maybe we can take that part of of pg_dump
David J N Begley <[EMAIL PROTECTED]> writes:
> Earlier today, Tom Lane wrote:
>> Please provide a concrete test case, not handwaving.
> C:\Program Files\PostgreSQL\8.1\bin>createdb concrete "Test Case"
> CREATE DATABASE
> COMMENT
> C:\Program Files\PostgreSQL\8.1\bin>psql -q concrete
> concrete=#
"David Begley" <[EMAIL PROTECTED]> writes:
> This means when the dump is imported to another PostgreSQL instance, the
> resultant ACLs do not match those of the original instance.
Please provide a concrete test case, not handwaving.
regards, tom lane
-
The following bug has been logged online:
Bug reference: 2085
Logged by: David Begley
Email address: [EMAIL PROTECTED]
PostgreSQL version: 8.1.0
Operating system: Windows XP
Description:pg_dump incompletely dumps ACLs
Details:
Running the following command:
pg_dump
