reset password
Author Message
raylongma1018
Posts: 81
Posted 00:10 Aug 04, 2015 |

Hi Dr.sun

What is set client_min_messages=WARNING in csjobs-create.sql do? 

is this has something to do with the logging?

how to use this in our database?

cysun
Posts: 2935
Posted 08:20 Aug 04, 2015 |

That's a PostgreSQL-specific command that controls what logging messages to be displayed in console. You can try running the script from command line with and without the command to see the difference. I like to use it because I mostly run db scripts from command line and too much logging output makes the output difficult to read, but it's not something that affects the database so you don't have to use it.