Thread: pg_dump: could not parse ACL list
Hi all, I have a fresh installation of 8.0devel but I'm not able to perform any backup using pg_dump: $ pg_dump -p 5433 test pg_dump: could not parse ACL list ([0:1]={postgres=UC/postgres,=UC/postgres}) for object "public" (SCHEMA) Regards Gaetano Mendola
Gaetano Mendola <mendola@bigfoot.com> writes: > $ pg_dump -p 5433 test > pg_dump: could not parse ACL list ([0:1]={postgres=UC/postgres,=UC/postgres}) for object "public" (SCHEMA) Ugh. This is an unforeseen side effect of Joe's recent changes to make array_out emit dimension info. I think the most reasonable answer is to tweak the ACL code so that it creates ACL arrays with lower bound 1 instead of lower bound 0. The only possible downside is that this would confuse any client code that is manually manipulating ACL arrays and knows about the lower-bound-0 behavior ... but any such code is likely broken anyway by the other ACL changes that have gone on lately ... regards, tom lane
Tom Lane wrote: > Gaetano Mendola <mendola@bigfoot.com> writes: >>$ pg_dump -p 5433 test >>pg_dump: could not parse ACL list ([0:1]={postgres=UC/postgres,=UC/postgres}) for object "public" (SCHEMA) > > Ugh. This is an unforeseen side effect of Joe's recent changes to make > array_out emit dimension info. Sorry about that :(. I guess I haven't tried dumping any databases since making the change. > I think the most reasonable answer is to tweak the ACL code so that it > creates ACL arrays with lower bound 1 instead of lower bound 0. The > only possible downside is that this would confuse any client code that > is manually manipulating ACL arrays and knows about the lower-bound-0 > behavior ... but any such code is likely broken anyway by the other ACL > changes that have gone on lately ... At least it looks like it was an easy fix :). Thanks, Joe
>>$ pg_dump -p 5433 test >>pg_dump: could not parse ACL list ([0:1]={postgres=UC/postgres,=UC/postgres}) for object "public" (SCHEMA) > > Ugh. This is an unforeseen side effect of Joe's recent changes to make > array_out emit dimension info. > > I think the most reasonable answer is to tweak the ACL code so that it > creates ACL arrays with lower bound 1 instead of lower bound 0. The > only possible downside is that this would confuse any client code that > is manually manipulating ACL arrays and knows about the lower-bound-0 > behavior ... but any such code is likely broken anyway by the other ACL > changes that have gone on lately ... Yes, phpPgAdmin is currently broken either way methinks. Chris