Re: Postgres db corrupted ?

On Wed, 2003-07-30 at 15:26, Tom Lane wrote:
> "Mendola Gaetano" <mendola(at)bigfoot(dot)com> writes:
> > ""John P. Looney"" <valen(at)tuatha(dot)org> writes:
> >> bbadmin | | SQL_ASCII
>
> > For sure a way to obtain this inconsistence is delete the owner of
> > a db and voila' a DB result to have no owner.
>
> Nope. I don't know how John got into this state, but it most definitely
> was not that way. Try it.

OK, it turns out that the cause was the shared hosting admin software
that was trying to add users and databases had some wierd problems
(hidden obscure shell scripts crashing out when it couldn't find an up
to date text dump of the pg_shadow file), which resulted in tables being
created, given specific sysids for users that weren't created.

Anyway, it looks like it wasn't a postgres bug that caused the
problems. If any field should be considered "not null" though, it's that
owner field!

John