Re: Debug information - Mailing list pgsql-admin

From POLONIUM-Team
Subject Re: Debug information
Date
Msg-id 5.1.0.14.0.20021008015532.01f1ace0@mail.polonium.de
Whole thread Raw
In response to Re: Debug information  ("Devinder K Rajput" <Devinder.Rajput@ipaper.com>)
Responses Re: Debug information  (Bruce Momjian <pgman@candle.pha.pa.us>)
List pgsql-admin
Hallo,

I found in reference.pdf small part about debug level. Where can I read
more about the 17 debug levels?


Best Regards,
Rafal

At 18:06 07.10.2002 -0500, Devinder K Rajput wrote:

>You can display a lot of debug info setting up loggin.  Make the following
>changes in your postgresql.conf file for some basic logging.  The higher up
>you go with the debug level, the more info you'll get.
>
>      debug_level = 2 # range 0-16
>      debug_print_query = true
>      debug_pretty_print = true
>
>regards,
>
>Devinder Rajput
>Stores Division Corporate Offices
>Chicago, IL
>(773) 442-6474
>
>
>
>
>                     "Rafal
> Kedziorski"
>
>                     <rafcio@polonium.de>         To:
> pgsql-admin@postgresql.org
>                     Sent
> by:                     cc:
>
>                     pgsql-admin-owner@post       Subject:     [ADMIN]
> Debug information
>                     gresql.org
>
>
>
>
>
>                     10/07/2002 06:01
> PM
>
>
>
>
>
>
>
>
>
>Hallo,
>
>I'm working on porting Oracle schema to PostgreSQL. Now I habe the whole
>schema in PostgreSQL. But there are some problems in our application in
>some sql queries. I get following errors.
>
>ERROR:  Unable to identify an operator '<=' for types 'numeric' and 'double
>precision'
>          You will have to retype this query using an explicit cast
>
>Its possible to display the queries in debug print out ftom PostgreSQL with
>queries which failed? If yep, how?
>
>
>Best Regards,
>Rafal
>
>
>---------------------------(end of broadcast)---------------------------
>TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org


pgsql-admin by date:

Previous
From: "Shridhar Daithankar"
Date:
Subject: Re: [GENERAL] Fast Deletion For Large Tables
Next
From: "Fabio C. Bon"
Date:
Subject: Two questions.