Re: [HACKERS] auto_explain causes regression failures

2010-02-20 Thread Andrew Dunstan
Tom Lane wrote: Andrew Dunstan and...@dunslane.net writes: With the following settings custom_variable_classes = 'auto_explain' auto_explain.log_min_duration = 0 auto_explain.log_format = 'xml' auto_explain.log_analyze = on auto_explain.log_verbose = on

Re: [HACKERS] auto_explain causes regression failures

2010-02-18 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: With the following settings custom_variable_classes = 'auto_explain' auto_explain.log_min_duration = 0 auto_explain.log_format = 'xml' auto_explain.log_analyze = on auto_explain.log_verbose = on shared_preload_libraries =

Re: [HACKERS] auto_explain causes regression failures

2010-02-17 Thread Tom Lane
I wrote: Andrew Dunstan and...@dunslane.net writes: I am getting regression failures on the rowtypes, transactions and arrays tests. Diff file is attached. I'm going to look into it, but if anyone has a good idea what's going on please speak up ASAP. And as for the transactions-test

Re: [HACKERS] auto_explain causes regression failures

2010-02-17 Thread Tom Lane
I wrote: If you're lost about the point here, it's this: an ArrayExpr can represent the result of an array assignment. For example, given UPDATE foo SET a[42] = x, what is generated is an ArrayExpr with refexpr = a, refupperindexpr = 42, refassgnexpr = x. On execution that generates the

[HACKERS] auto_explain causes regression failures

2010-02-16 Thread Andrew Dunstan
With the following settings custom_variable_classes = 'auto_explain' auto_explain.log_min_duration = 0 auto_explain.log_format = 'xml' auto_explain.log_analyze = on auto_explain.log_verbose = on shared_preload_libraries = 'auto_explain' I am getting regression failures on the

Re: [HACKERS] auto_explain causes regression failures

2010-02-16 Thread Takahiro Itagaki
Andrew Dunstan and...@dunslane.net wrote: With the following settings custom_variable_classes = 'auto_explain' auto_explain.log_min_duration = 0 auto_explain.log_format = 'xml' auto_explain.log_analyze = on auto_explain.log_verbose = on shared_preload_libraries =

Re: [HACKERS] auto_explain causes regression failures

2010-02-16 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: I am getting regression failures on the rowtypes, transactions and arrays tests. Diff file is attached. I'm going to look into it, but if anyone has a good idea what's going on please speak up ASAP. Hmm. Didn't decipher the transactions-test

Re: [HACKERS] auto_explain causes regression failures

2010-02-16 Thread Tom Lane
Andrew Dunstan and...@dunslane.net writes: I am getting regression failures on the rowtypes, transactions and arrays tests. Diff file is attached. I'm going to look into it, but if anyone has a good idea what's going on please speak up ASAP. And as for the transactions-test failures, a stack

Re: [HACKERS] auto_explain causes regression failures

2010-02-16 Thread Tom Lane
Takahiro Itagaki itagaki.takah...@oss.ntt.co.jp writes: Thank you for the bug report. Auto_explan tries to explain the query even if it is failed, but schema objects that are created in the same transaction might not be available. cache lookup failed erros can be avoided if auto_explain skips