Re: BUG #1672: Postgres 8.0 doesn't return errors.
От | Gregory L Miller-Kramer |
---|---|
Тема | Re: BUG #1672: Postgres 8.0 doesn't return errors. |
Дата | |
Msg-id | 1116421861.5590.5.camel@localhost.localdomain обсуждение исходный текст |
Ответ на | Re: BUG #1672: Postgres 8.0 doesn't return errors. (Michael Fuhr <mike@fuhr.org>) |
Ответы |
Re: BUG #1672: Postgres 8.0 doesn't return errors.
|
Список | pgsql-bugs |
Thanks again for getting back to me. I entered the statement you wanted. (show client_min_messages;) It returned... client_min_messages --------------------- log (1 row) I did try what you mentioned (set client_min_messages to notice;) and it didn't work. Any other recommendations? I do appreciate your assistance and I will endeavor to make sure to try what you suggest before replying. Thank you, Greg Miller-Kramer On Tue, 2005-05-17 at 17:05 -0600, Michael Fuhr wrote: > On Tue, May 17, 2005 at 05:05:03PM -0400, Gregory L Miller-Kramer wrote: > > > On system One I enter the database ... > > psql exdb exdb > > select misspelled_excol from extable; > > > > and an error is displayed... > > ERROR: column 'misspelled_excol' does not exist > > > > On the "Other" system (Postgres 8.0) that error is NOT displayed. > > Infact, nothing is displayed it just returns to the prompt. > > As I asked in my previous message, what's the output of the following > query? > > SHOW client_min_messages; > > My first guess is that client_min_messages is set to "fatal" or > "panic", which, although not among the documented settings for > client_min_messages, are allowed and would have the effect you > describe: > > test=> SET client_min_messages TO panic; > SET > test=> SELECT misspelled_excol FROM extable; > test=> SET client_min_messages TO notice; > SET > test=> SELECT misspelled_excol FROM extable; > ERROR: column "misspelled_excol" does not exist > > -- > Michael Fuhr > http://www.fuhr.org/~mfuhr/ > Senior Engineer Context Technologies, Inc. CRM & Systems Integration - Software, Services, Solutions 1173 Pittsford-Victor Rd. Suite 110 Pittsford, NY 14534 Phone: 585.586.6775 x8195 Fax: 585.383.8872 E-Mail: millerg@contexttech.com Web: http://www.contexttech.com/ -- This message has been scanned for viruses and dangerous content, and is believed to be clean.
В списке pgsql-bugs по дате отправления: