hi,
Why is pg_restore trying to put stuff into the pg_catalog schema of all
places?
It's ignoring the schema specified in the pg_dump itself (`myschema`)
and even my search_path (`public`).
$ psql stuff_development --command show search_path
search_path
-
public
(1 row)
$
Seamus Abshere sea...@abshere.net writes:
Why is pg_restore trying to put stuff into the pg_catalog schema of all
places?
Hm ... does myschema actually exist in the target database? If it
doesn't, and the dump file doesn't include a command to create it,
this is what you'll get. That's
On 4/4/14, 12:58 PM, Tom Lane wrote:
Seamus Abshere sea...@abshere.net writes:
Why is pg_restore trying to put stuff into the pg_catalog schema of all places?
Hm ... does myschema actually exist in the target database? [...] if myschema
doesn't exist, the creation target devolves to
Seamus Abshere sea...@abshere.net writes:
On 4/4/14, 12:58 PM, Tom Lane wrote:
Hm ... does myschema actually exist in the target database? [...] if
myschema doesn't exist, the creation target devolves to pg_catalog. This is
not terribly elegant but I'm not sure if there's consensus to