Postgres Pro
Downloads
Home   >   mailing lists

Re: pg_dump and search_path - Mailing list pgsql-general

From Ryan Lambert
Subject Re: pg_dump and search_path
Date
Msg-id CAN-V+g9ydM5w9gkUCyobJVbY11T5WPVo6grpNGhKFZCX99Cs1w@mail.gmail.com
Whole thread Raw
In response to Re: pg_dump and search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
Responses Re: pg_dump and search_path  (Adrian Klaver <adrian.klaver@aklaver.com>)
List pgsql-general
Tree view
My exact situation was a deployment via sqitch,  It appears that uses psql under the hood based on the error message I get.

Running just "sqitch deploy" I  get an error due to a non-fully qualified name and a missing search path (my mistakes).  The error I get:

 + 004 .. psql:deploy/004.sql:72: ERROR:  relation "vobservations" does not exist
LINE 11:                FROM vobservations
                             ^
not ok
"psql" unexpectedly returned exit value 3

Reverting all changes

Running the following works for me in this case and allows it to find the view in the proper schema.

PGOPTIONS='-c search_path=piws,public' sqitch deploy

Ryan

pgsql-general by date:

Previous
From: Steve Atkins
Date:
Subject: Re: DRY up GUI wiki pages
Next
From: Adrian Klaver
Date:
Subject: Re: pg_dump and search_path