psql 9.* pg_restore --clean exits 1 when table does not exist

From: PG Doc comments form <noreply(at)postgresql(dot)org>
To: pgsql-docs(at)lists(dot)postgresql(dot)org
Cc: mirah(dot)gary(at)gmail(dot)com
Subject: psql 9.* pg_restore --clean exits 1 when table does not exist
Date: 2018-03-07 16:47:49
Message-ID: 152044126994.23137.13155863308187682060@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-docs

The following documentation comment has been logged on the website:

Page: https://www.postgresql.org/docs/9.6/static/app-pgrestore.html
Description:

Using pg_restore with the --clean flag without the --if-exists flag and
objects are not present in the destination database results in exit status
1. The documentation states that --if-exists suppresses "some harmless error
messages" but it also changes the exit status to 0. A non-zero exit status
does not seem to be harmless.

Browse pgsql-docs by date

  From Date Subject
Next Message PG Doc comments form 2018-03-09 03:10:50 "IS NOT DOCUMENT" is missing
Previous Message Michael Paquier 2018-03-07 02:20:49 Re: libpq options