Re: pgBench cannot use prepared statements and reconnections

From: Josh Berkus <josh(at)agliodbs(dot)com>
To: Mark Kirkwood <mark(dot)kirkwood(at)catalyst(dot)net(dot)nz>
Cc: pgsql-bugs(at)postgresql(dot)org, Greg Smith <greg(at)2ndQuadrant(dot)com>
Subject: Re: pgBench cannot use prepared statements and reconnections
Date: 2013-08-01 18:00:29
Message-ID: 51FAA23D.40007@agliodbs.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

On 07/31/2013 04:11 PM, Mark Kirkwood wrote:
> Hmmm, apologies - actually it didn't - I read right past the text
>
> ERROR: prepared statement "P0_7" does not exist
>

Yah. It's quite possible that the answer is to explicitly disallow this
-- the only reason I even tried it is that I was testing for a
PostgreSQL bug -- but we should fail gracefully, e.g. "Use of prepared
statements with pgbench requires persistent connections. You may not
use the -C and -m prepared options together".

--
Josh Berkus
PostgreSQL Experts Inc.
http://pgexperts.com

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Maciek Sakrejda 2013-08-01 21:13:30 Re: BUG #8347: PANIC: heap_insert_redo: failed to add tuple when applying WAL
Previous Message josealdea 2013-08-01 17:59:51 BUG #8351: contraseña postgresql