Disabling NOTICE messages when using ruby-postgres

[Nathaniel Talbott]

Does anyone know if there's a way to disable the NOTICE messages when using
ruby-postgres? Example:

require 'dbi'
db = DBI::connect('dbig:setest:localhost', 'setest', 'setest')
db.execute("CREATE TABLE test (id SERIAL PRIMARY KEY)")

=> NOTICE: CREATE TABLE will create implicit sequence 'test_id_seq' for
SERIAL column 'test.id'
NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index
'test_pkey' for table 'test'

I realize I'm using DBI, but it's Postgres that is at fault - evidently it
prints out some information straight to stderr.

Thanks,


Nathaniel

<(><

 

[ts]

N> require 'dbi'
N> db = DBI::connect('dbig:setest:localhost', 'setest', 'setest')

db.execute("set client_min_messages = warning")

N> db.execute("CREATE TABLE test (id SERIAL PRIMARY KEY)")



Guy Decoux