On Mon, Jun 1, 2009 at 1:32 PM, Bryce Nesbitt <bry...@obviously.com> wrote: > I'm looking for a good way to avoid triggering the "will create implicit > index" NOTICE that Postgres (all versions) puts out. This ends up spamming > cron scripts for no good reason: > > => create table junk_six (foo int, primary key (foo)); > NOTICE: CREATE TABLE / PRIMARY KEY will create implicit index > "junk_six_pkey" for table "junk_six" > CREATE TABLE > > I've got a hacky solution (in perl), pulled from > http://www.perlmonks.org/index.pl/jacques?node_id=540511 > which suppresses the warning: > > my $tmpwarn = $SIG{__WARN__}; > $SIG{__WARN__} = sub { print STDERR @_ if $_[0] !~ m/NOTICE: CREATE TABLE/; > }; > $sqldb->sql_execute("create table junk_six (foo int, primary key (foo));"); > $SIG{__WARN__} = $tmpwarn; > > And I know that I can edit the warning level in postgresql.conf with some > other side effects. > But the best solution would be to avoid the notice in the first place. Is > this possible?
You can also set log_min_messages by the connection, by the user, and by the database. alter user bubba set log_min_messages=error; etc. -- Sent via pgsql-sql mailing list (pgsql-sql@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-sql