Nishad Prakash <prakashn(at)uci(dot)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