Re: NOTICE causing SQLException

Поиск
Список
Период
Сортировка
От Andrew Sullivan
Тема Re: NOTICE causing SQLException
Дата
Msg-id 20020917105602.I27778@mail.libertyrms.com
обсуждение исходный текст
Ответ на NOTICE causing SQLException  (Daniel Serodio <daniel@checkforte.com.br>)
Ответы Re: NOTICE causing SQLException
Список pgsql-jdbc
On Tue, Sep 17, 2002 at 11:40:33AM -0300, Daniel Serodio wrote:

> *** TerminalManagerError connecting to the DataBase:
> Something unusual has occured to cause the driver to fail. Please report
> this exception: Exception: java.sql.SQLException: NOTICE:  Query
> statistics are disabled because parser, planner, or executor statistics
> are on.

There's a series of statistics settings in the postgresql.conf file.
They cannot all be turned on.  You're probably right in thinking that
this is a mistake the driver is making, because that is just a NOTICE
and not an ERROR.  Anyway, you can put the statistics pieces back the
way they were, and SIGUP the postmaster, and you should be set.  The
settings you want are

#show_parser_stats = false
#show_planner_stats = false
#show_executor_stats = false
#show_query_stats = false

(Those are the defaults.)  If any of parser, planner, or executor are
true, the query ones are unavailable.

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


В списке pgsql-jdbc по дате отправления:

Предыдущее
От: Daniel Serodio
Дата:
Сообщение: NOTICE causing SQLException
Следующее
От: Daniel Serodio
Дата:
Сообщение: Re: NOTICE causing SQLException