On Jan 11, 2007, at 2:03 PM, John Siracusa wrote:
> I believe this is a DBI/DBD::Pg/libpg issue/reality/"feature" :)
> If you
> use DBI's prepare_cache() method and you change the db schema
> between calls,
> the previously-cached version of the cached statement will become
> invalid.
> I think that's what you're seeing.
i thought that at first too-- except the prepared statement id is
changing -- which suggests to me that its not going for the
previous version.
> So you can either not use prepare_cached() at all, or turn it off
> when the
> schema changes, and then perhaps back on again afterwards. Overriding
> dbi_prepare_cached() in a custom metadata class and making it
> "smart" is one
> way to do this without worrying about explicit prepare_cached => ...
> parameters to every call.
i could -- but this happens ONLY in a dev environment. there's no
reason why it should happen in production.
i'd rather not introduce a setting like that i could potentially
forget about on the live server - where i'd most certainly want my
app to be crashing if schemas suddenly start changing :)
completely off topic:
does anyone know when the new DBD::Pg is coming out?
i recall reading somewhere that there was going to be a patch in it
that put PIDs into prepared statement ids, so that it would work
better with Apache::DBI.
// 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
