Postgres Pro
Downloads
Home   >   mailing lists

pg_dump quietly ignore missing tables - is it bug? - Mailing list pgsql-hackers

From Pavel Stehule
Subject pg_dump quietly ignore missing tables - is it bug?
Date
Msg-id CAFj8pRBW=V-8fPs8Xh0gzhf3_QO1D2-H3gepDNKZ5g9-h_tt1g@mail.gmail.com
Whole thread Raw
Responses Re: pg_dump quietly ignore missing tables - is it bug?
List pgsql-hackers
Tree view
Hi

we found possible bug in pg_dump. It raise a error only when all specified tables doesn't exists. When it find any table, then ignore missing other.

/usr/local/pgsql/bin/pg_dump -t Foo -t omega -s postgres > /dev/null; echo $?

foo doesn't exists - it creates broken backup due missing "Foo" table

 [pavel@localhost include]$ /usr/local/pgsql/bin/pg_dump -t Foo -t omegaa -s postgres > /dev/null; echo $?
pg_dump: No matching tables were found
1

Is it ok? I am thinking, so it is potentially dangerous. Any explicitly specified table should to exists.

Regards

Pavel

pgsql-hackers by date:

Previous
From: Kevin Grittner
Date:
Subject: Re: Reduce pinning in btree indexes
Next
From: Kevin Grittner
Date:
Subject: Re: Reduce pinning in btree indexes