On Wed, 2003-07-30 at 15:26, Tom Lane wrote: > "Mendola Gaetano" <[EMAIL PROTECTED]> writes: > > ""John P. Looney"" <[EMAIL PROTECTED]> 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
signature.asc
Description: This is a digitally signed message part
