Hello. How can I specify ON COMMIT... for a TEMP table in SA?
I.e. the following Python code meta = MetaData() foo = Table('tmp_foo' meta, Column('id', Integer, primary_key=True), Column('val', Integer, nullable=False), prefixes=['TEMPORARY'], ) conn = session.connection() foo.create(conn) will issue the following SQL CREATE TEMPORARY TABLE tmp_foo( id integer PRIMARY KEY, val integer NOT NULL ); but what if I want to issue this instead CREATE TEMPORARY TABLE tmp_foo( id integer PRIMARY KEY, val integer NOT NULL ) ON COMMIT DROP; -- e.g. this line I was unable to figure this out on my own. Is this even possible? Fortunately for me, I don't need this feature (yet), the default is good enough for my purposes. Thank you in advance, Ladislav Lenart -- You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To unsubscribe from this group and stop receiving emails from it, send an email to sqlalchemy+unsubscr...@googlegroups.com. To post to this group, send email to sqlalchemy@googlegroups.com. Visit this group at http://groups.google.com/group/sqlalchemy. For more options, visit https://groups.google.com/d/optout.