I'm not sure I completely understand what's going on, so I apologize
is this is obvious use error :)
I'm trying to add to the create_all() method (by wrapping in my own
method) for some custom SQL to be executed after the basic
metadata.create_all() method is finished.
More specifically, I have something like this:
def create_all(metadata, engine):
metadata.create_all(engine)
s = Session()
s.begin()
engine.func.AddGeometryColumn('mytable', 'geo_col', 4326, 'POINT',
2).execute()
s.commit()
(This is PostGIS releated, but the problem appears to be unrelated to
that specifically.)
When I run my version of create_all(), I don't get any errors, but the
subsequent statement(s) are executed within a transaction that gets
rolled back. This happens regardless of whether I encapsulate my unit
of work in a new Session.
In the postgresql logs, I see:
<a whole bunch of expected log lines about creating my tables, etc.>
2008-06-17 10:28:09 EDT LOG: statement: COMMIT
2008-06-17 10:28:09 EDT LOG: statement: BEGIN; SET TRANSACTION
ISOLATION LEVEL READ COMMITTED
2008-06-17 10:28:09 EDT LOG: statement: SELECT
AddGeometryColumn(E'mytable', E'geo_col', 4326, E'POINT', 2) AS
"AddGeometryColumn_1"
2008-06-17 10:28:09 EDT LOG: statement: ROLLBACK
Is this expected / am I doing something wrong?
Thanks in advance -
Hans
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
