On 30 Jan 2004 at 23:34, Tom Lane wrote:
> "Dan Langille" <dan@langille.org> writes:
> > I upgraded two servers today from 7.3.* to 7.4.1. In both cases, the
> > schemas which existed in the original databases were not created in
> > the new database.
> > New issue? Known bug?
>
> New one on me. Look at the log output from when the dump was being
> restored. I suppose there must be an error message from the CREATE
> SCHEMA commands --- what is it?
I found three of these messages in /var/log/messages on the box which
had the problem.
ERROR: permission denied for database pg_freebsddiary.org.schemas
Nothing else. I don't have the output from the restore. I tried
reproducing the problem on another box but schemas were always
correctly created. I can't reproduce the problem situation. Sorry.
--
Dan Langille : http://www.langille.org/
BSDCan - http://www.bsdcan.org/