Re: Cannot recreate DB scheme using pg_dump - Mailing list pgsql-bugs

From Tom Lane
Subject Re: Cannot recreate DB scheme using pg_dump
Date
Msg-id 1879.1090040887@sss.pgh.pa.us
Whole thread Raw
In response to Cannot recreate DB scheme using pg_dump  (Nishad Prakash <prakashn@uci.edu>)
List pgsql-bugs
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

pgsql-bugs by date:

Previous
From: Tom Lane
Date:
Subject: Re: Slow views
Next
From: Stephan Szabo
Date:
Subject: Re: Slow views