"Sandy Spence" <axs(at)aber(dot)ac(dot)uk> writes:
> thanks for the help, one last question I hope, how do I cross reference the
> pg_class, pg_user and pg_type so that I can obtain the usesysid of the
> missing owner?
It's whatever is in the relowner and typowner fields. There is no entry
anymore in pg_user, if there were you wouldn't be having a problem;
so you'll likely have to make up names for the user ids.
regards, tom lane
In response to
pgsql-admin by date
|Next:||From: Tom Lane||Date: 2006-12-15 17:57:04|
|Subject: Re: Change "shutdown time" was: Change "database system |
|Previous:||From: Sandy Spence||Date: 2006-12-15 16:30:54|
|Subject: Re: invalid types and tables |