Re: [GENERAL] Why Postgresql Public Schema Is Not Owned By The DB Owner By Default

2008-10-29 Thread Eus
Hi Ho! --- On Thu, 10/30/08, Tom Lane <[EMAIL PROTECTED]> wrote: > Because it'd be extremely difficult to do otherwise > (given the way that > CREATE DATABASE works) Understood. > and it's not at all clear that > it'd be a good > idea anyway. Can it be cleared up by looking at the kind of secu

Re: [GENERAL] Why Postgresql Public Schema Is Not Owned By The DB Owner By Default

2008-10-29 Thread Tom Lane
Eus <[EMAIL PROTECTED]> writes: > Why does Postgresql by default assign the ownership of the public schema of a > DB to "postgres" instead of the owner of the DB itself? Because it'd be extremely difficult to do otherwise (given the way that CREATE DATABASE works) and it's not at all clear that i

[GENERAL] Why Postgresql Public Schema Is Not Owned By The DB Owner By Default

2008-10-29 Thread Eus
Hi Ho! As a new user of Postgresql 8.3.3, I came across this common error message when restoring a database previously dumped from another machine: 15: ERROR: must be owner of schema public when it came to this line in the dump file: COMMENT ON SCHEMA public IS 'Standard public schema'; And,