Re: new script

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Jodi Kanter <jkanter(at)virginia(dot)edu>
Cc: Postgres Admin List <pgsql-admin(at)postgresql(dot)org>
Subject: Re: new script
Date: 2003-09-29 16:00:45
Message-ID: 24990.1064851245@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

Jodi Kanter <jkanter(at)virginia(dot)edu> writes:
> So I now have my new schema script that includes PK and FK constraints.
> It runs without a problem but I get too many NOTICES regarding implicit
> indexes that have been created. I am running this script from within
> psql using the \i command. Can I run this and suppress these NOTICES?

Sure. Set client_min_messages higher than NOTICE level.

regards, tom lane

In response to

  • new script at 2003-09-29 14:25:31 from Jodi Kanter

Browse pgsql-admin by date

  From Date Subject
Next Message Marvin 2003-09-29 16:20:54 Automatic BackUp from VB
Previous Message Jan Wieck 2003-09-29 15:41:38 Re: [ADMIN] postgres 6.2 vacuum