Re: Debug information

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