new script

Поиск
Список
Период
Сортировка
Искать

new script

От:
Jodi Kanter <jkanter@virginia.edu>
Дата:
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? I find it tedious to have to search through them to ensure there are no error messages mixed in. I prefer to only see problem notifications.
Can this be done?
Thanks
Jodi
--

_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu


 

 

 

Re: new script

От:
Tom Lane <tgl@sss.pgh.pa.us>
Дата:
Jodi Kanter  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
FAQ