Runnin ModPerl2 w/ Apache Restart + Apache DBI + Postgres, I found this:

        if  i change a table columns definition during testing, I'll get  
these errors:

                DBD::Pg::st execute failed: ERROR:  prepared statement 
"dbdpg_17"  
does not exist

        and to note, on every change i'll see the prepared statement id go  
up  a bit.


I'm  not sure exactly why its happening, but the general  cause is   
clear.  It also doesn't really matter - its  such an edge case.  i  
didn't bother trying to track down where the cached prepared  
startements are being rewritten , and if its looking for an earlier  
or newer version.

but the simple fix is to stop/start the server ( which takes 2  
seconds, and this would only conceivably happen on a dev machine )

I just wanted to warn other people who might  run into this and start  
scratching their heads trying to figure out what is wrong.


// Jonathan Vanasco

| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - -
| FindMeOn.com - The cure for Multiple Web Personality Disorder
| Web Identity Management and 3D Social Networking
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - -
| RoadSound.com - Tools For Bands, Stuff For Fans
| Collaborative Online Management And Syndication Tools
| - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -  
- - - - - - - - - - - - - - - -



-------------------------------------------------------------------------
Take Surveys. Earn Cash. Influence the Future of IT
Join SourceForge.net's Techsay panel and you'll get the chance to share your
opinions on IT & business topics through brief surveys - and earn cash
http://www.techsay.com/default.php?page=join.php&p=sourceforge&CID=DEVDEV
_______________________________________________
Rose-db-object mailing list
Rose-db-object@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/rose-db-object

Reply via email to