[odb-users] Postgres error: 42P05 prepared statement already exists

[Alessandro Bellina]

Thanks Boris

I don't have another table with the same name (this is all under the same Schema too). 

One thing I forgot to mention is that if I go to Postgres and attempt to deallocate the statement manually I get a notice, that the statement name is too long and that it will be truncated.

Thanks again Boris

Alessandro

Alessandro A. Bellina
abellina at gmail.com

> On Jul 11, 2014, at 2:44 AM, Boris Kolpackov <boris at codesynthesis.com> wrote:
> 
> Hi Alessandro,
> 
> Alessandro Bellina <abellina at gmail.com> writes:
> 
>> I'm using odb with Postgres. I get and error trying to insert into one
>> of my tables. The error is: 42P05 prepared statement "my_table_persist"
>> already exists.
> 
> This would be mean that another statement with the same name has already
> been prepared on the connection. Try to search all your ODB-generated
> files for this name. Perhaps there is another table with the same name
> used elsewhere (the statement name is derived from the table name)?
> 
> Boris