Configure psql to ignore notice messages

[Ivan Nunes]

Hi,

Is it possible to ignore "NOTICE" messages through configuration in the sqitch.conf file?

Branch:develop Host:csabjsam Error:'psql.bin:deploy/criar_arquivo_imposto_taxa.sql:5: NOTICE:  table "imposto_taxa" does not exist, skipping'

Or something similar to the one discussed here: https://stackoverflow.com/questions/3530767/disable-notices-in-psql-output

Best regards.

[David E. Wheeler]

Yep. I put this at the top of most of my Sqitch scripts:

    SET client_min_messages TO WARNING;

You can also set it in the postgresql.conf or via ALTER DATABASE.

  https://www.postgresql.org/docs/current/static/sql-alterdatabase.html

HTH,

David

[Nikolay Samokhvalov]

On Mon, Aug 7, 2017 at 3:12 PM, David E. Wheeler <da...@justatheory.com> wrote:

You can also set it in the postgresql.conf or via ALTER DATABASE.

 

...or via ALTER ROLE -- in some cases this way might be more convenient to control such things.

  https://www.postgresql.org/docs/current/static/sql-alterrole.html

[Ivan Nunes]

So, using postgres own resources, I already knew.

I did not want to put this inside every script (deploy, revert, verify). My colobarores are kind of forgotten.

I also did not want to insert in my ".psqlrc", I have more than 300 db's.

I simply wanted to place in repo/sqitch.conf and so sqitch + ansible would already do the rest.

Tky

[David E. Wheeler]

On Aug 8, 2017, at 7:33 AM, Ivan Nunes <ivanels...@gmail.com> wrote:

> So, using postgres own resources, I already knew.
>
> I did not want to put this inside every script (deploy, revert, verify). My colobarores are kind of forgotten.
>
> I also did not want to insert in my ".psqlrc", I have more than 300 db's.
>
> I simply wanted to place in repo/sqitch.conf and so sqitch + ansible would already do the rest.

No, there is currently no way to do this directly in Sqitch; it mostly tries to avoid database-specific interface stuff. The best way to do it is to put it in the scripts that need it.

Best,

David