Re: NOTICE causing SQLException - Mailing list pgsql-jdbc

From Andrew Sullivan
Subject Re: NOTICE causing SQLException
Date
Msg-id 20020917105602.I27778@mail.libertyrms.com
Whole thread Raw
In response to NOTICE causing SQLException  (Daniel Serodio <daniel@checkforte.com.br>)
Responses Re: NOTICE causing SQLException  (Daniel Serodio <daniel@checkforte.com.br>)
List 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 by date:

Previous
From: Daniel Serodio
Date:
Subject: NOTICE causing SQLException
Next
From: Daniel Serodio
Date:
Subject: Re: NOTICE causing SQLException