Обсуждение: new script
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
Can this be done?
Thanks
Jodi
--
_______________________________
Jodi L Kanter
BioInformatics Database Administrator
University of Virginia
(434) 924-2846
jkanter@virginia.edu
Jodi Kanter <jkanter@virginia.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