Re: Cannot recreate DB scheme using pg_dump

Nishad Prakash <prakashn@uci.edu> writes:
> If step (3) is perfomed by the postgres superuser, then certain
> indices and foreign key constraints are not re-created and I see the
> error "must be owner of relation <foo>".

That's a tad hard to believe: superusers always have ownership rights.
Could we see a complete example?

And which PG version are you using, anyway?

			regards, tom lane