View the value of the variables in the log ! 
Author Message
 View the value of the variables in the log !

Hi,

I already try to change my postgresql.conf adding debug_print_parse,
debug_print_plan, debug_print_rewritten and debug_print_query with only
one purpose, to see the values that are passing in the queries.
But I can't see what's going on, only the parse query, like: DEBUG:  
query: SELECT  turno,tipo,parte,indice FROM evento_v WHERE id_e =  $1.

How can I see the values that are passing in the queries, using log ?

Thanks, Luis Sousa

---------------------------(end of broadcast)---------------------------
TIP 2: you can get off all lists at once with the unregister command



Sun, 25 Jul 2004 20:22:17 GMT
 
 [ 1 post ] 

 Relevant Pages 

1. Views ported from access with variable criteria values

2. Passing value from a PL/SQL variable to a SQL*Plus variable

3. Variable Name vs Variable Value

4. using variable from URL .... page.asp?variable=value

5. exec command for assigning values into variables where tablename is a variable

6. How to assign a value into local variable from a query in string variable

7. select value from table where value in(@variable)

8. Stored procedure returning variable value, not column value?

9. Three event logged in the event view About SQLAgent whenever clear the event logs or failover

10. Viewing global variables in a DTS package (SQL 7 with SP1)

11. Variables in a view????

12. @Variable in a view?


 
Powered by phpBB® Forum Software