[Libpqxx-general] Unnamed prepared statements

[Trigve Siver]

> From: Trigve Siver <trigves at yahoo.com>
> To: libpqxx-general at pgfoundry.org
> Sent: Friday, August 7, 2009 10:43:34 PM
> Subject: [Libpqxx-general] Unnamed prepared statements
> 
> Hi there,
> I've been trying to find where my problem with unnamed preparedt stmts lie. Oh 
> christ, have tried it for 5 hours. My problem is bit complicated because I 
> cannot simple isolate it. But I try to describe it. I'm preparing (and using it) 
> unnamed prepared statement (UPS) with definition named def1 (with some 
> parameters).

I found I was wrong, the second statement without params wasn't created so, ignore it. I've removed it in this mail.

>  Then I create the same UPS (as the first) with definition of def1 and 
> call it and I've got the error "unnamed prepared statement does not exist" from 
> Postgres. This is some basic scheme in which I encounter the problem. The fix is 
> attached.  I found that in rev. 1553 there was some update in UPS's. I've added 
> "i->second.registered = false;" in "pqxx::prepare::declaration 
> pqxx::connection_base::prepare". I havent go deeper but it seems that it works. 
> So can someone shed some light on this?
> 
> Thanks
> 
> Trigve