Re: NOTICE causing SQLException

Daniel,

There was a bug in the way the 7.2 driver handled notices under some 
circumstances.  This should be fixed in the 7.3 driver.  Can you try the 
latest driver build from jdbc.postgresql.org to verify that the code 
changes fix the problem in your case?

thanks,
--Barry



Daniel Serodio wrote:
> On Tue, 2002-09-17 at 11:56, Andrew Sullivan wrote:
>
> > 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.
>
>
> Hi, thanks for the quick reply. That's what he (the DBA) did to get the
> system up again, after I told him to undo whatever changes he had done
> to postgresql.conf. However, I think the JDBC driver really should
> handle NOTICEs more gracefully.


---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster