Diez B. Roggisch wrote:
> Ah, ok, then the temporary table itself will ensure that. I wasn't aware of 
> that.
>   
I've found the trouble

engine.execute is not bound to a specific session. It flip-flops (even
with a single user)

> |>>>| ||eng*.*execute*(*"select * from
> current_schemas('true');"*)**.*fetchall*(**)*||
> |[(['pg_temp_3', 'pg_catalog', 'public'],)]
> ||>>>| ||eng*.*execute*(*"select * from
> current_schemas('true');"*)**.*fetchall*(**)*||
> |[(['pg_temp_4', 'pg_catalog', 'public'],)]
> ||>>>| ||get_engine*(**)**.*execute*(*"select * from
> current_schemas('true');"*)**.*fetchall*(**)*||
> |[(['pg_temp_3', 'pg_catalog', 'public'],)]
> ||>>>| ||get_engine*(**)**.*execute*(*"select * from
> current_schemas('true');"*)**.*fetchall*(**)*||
> |[(['pg_temp_4', 'pg_catalog', 'public'],)]
> ||>>>| ||get_engine*(**)**.*execute*(*"select * from
> current_schemas('true');"*)**.*fetchall*(**)*||
which I'm sure is very nice and efficient but forces me to go read
sqlalchemy docs a bit more :-)



--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups 
"TurboGears" group.
To post to this group, send email to [email protected]
To unsubscribe from this group, send email to [EMAIL PROTECTED]
For more options, visit this group at 
http://groups.google.com/group/turbogears?hl=en
-~----------~----~----~----~------~----~------~--~---

Reply via email to