Version: 9.0 beta 3
Severity: Contrib feature broken
Platform: Ubuntu Netbook Remix, Dell 10 Mini laptop
Workaround Possible? No.
With 9.0, the obvious thing to do with autoexplain is to log JSON or XML
explain plans to a csvlog and then automatically process them.
However, when I attempt to do
Josh Berkus writes:
> With 9.0, the obvious thing to do with autoexplain is to log JSON or XML
> explain plans to a csvlog and then automatically process them.
> However, when I attempt to do this, I get the following warning at
> PostgreSQL startup time:
> Loaded module "auto_explain"
> Not saf
"Daniel Grace" writes:
> This test case fails with the above error:
> CREATE TABLE foo (
> t VARCHAR
> );
> INSERT INTO foo (t) VALUES ('a'), ('a'), ('b'), ('b'), ('c');
> SELECT STRING_AGG(DISTINCT t ORDER BY t) FROM foo;
I've applied a patch for this. Thanks for the report!
Josh Berkus writes:
> With 9.0, the obvious thing to do with autoexplain is to log JSON or XML
> explain plans to a csvlog and then automatically process them.
BTW, I tried this and it works fine for me.
> However, when I attempt to do this, I get the following warning at
> PostgreSQL startup ti
Tom Lane wrote:
Anyway, you'll get the same "not safe" bleat for any message
logged during early postmaster startup.
Maybe we should just drop the "not safe" message. It's not conveying
anything very helpful, I think. The useful bit of the behavior is to
shove the original message out to std
Andrew Dunstan writes:
> Tom Lane wrote:
>> Anyway, you'll get the same "not safe" bleat for any message
>> logged during early postmaster startup.
>>
>> Maybe we should just drop the "not safe" message. It's not conveying
>> anything very helpful, I think. The useful bit of the behavior is to
Tom Lane writes:
> Andrew Dunstan writes:
>> I thought we agreed back in November to stop the bleating.
> Did we? I'd forgotten.
You're right ... this conversation seems to be a repeat of the
thread here:
http://archives.postgresql.org/pgsql-hackers/2009-11/msg01260.php
I'll go fix it now bef
