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 [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy.
For more options, visit https://groups.google.com/d/optout.
