Re: [HACKERS] [BUGS] pg_dump/all doesn't output schemas correctly

2003-09-16 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > I asked my programmers to look into this. They think they have fixed > it. I have asked them to provide me > a patch. Should I post the patch here? pgsql-patches is the usual place for patches. I was planning to work on this myself tomorrow, so y

Re: [HACKERS] [BUGS] pg_dump/all doesn't output schemas correctly

2003-09-16 Thread Joshua D. Drake
Hello, I asked my programmers to look into this. They think they have fixed it. I have asked them to provide me a patch. Should I post the patch here? Sincerely, Joshua Drake Bruce Momjian wrote: I can confirm that this bug still exists in current CVS. The problem is that "CREATE SCHEMA AUT

Re: [HACKERS] [BUGS] pg_dump/all doesn't output schemas correctly (v7.3.4)

2003-09-10 Thread Bruce Momjian
I can confirm that this bug still exists in current CVS. The problem is that "CREATE SCHEMA AUTHORIZATION test" is translated into "SET SESSION AUTHORIZATION 'test'; CREATE SCHEMA test;". While this does allow the schema to be owned by 'test', it assumes 'test' has permissions to create the sch