I'm brand new to SA, and trying to import data from a text file by directly executing postgresql's COPY statement. It works fine in the postgresql client (psql), but when I run the same statements through SA I get an empty table. This is a snip of the python code:
dbengine = create_engine('postgres://%s:[EMAIL PROTECTED]:5432/database' % (admin, passwd)) dbengine.echo = True dbconn = dbengine.connect() dbconn.execute("DELETE FROM facility") dbconn.execute("COPY facility FROM '" + abspath(output_file) + "' WITH DELIMITER '|' NULL ''") dbconn.close() This is the echo text, which looks fine to me: 2008-05-22 20:14:46,726 INFO sqlalchemy.engine.base.Engine.0x..cL DELETE FROM facility 2008-05-22 20:14:46,727 INFO sqlalchemy.engine.base.Engine.0x..cL {} 2008-05-22 20:14:46,746 INFO sqlalchemy.engine.base.Engine.0x..cL COMMIT 2008-05-22 20:14:46,748 INFO sqlalchemy.engine.base.Engine.0x..cL COPY facility FROM '/home/brad/facility.cln' WITH DELIMITER '|' NULL '' 2008-05-22 20:14:46,748 INFO sqlalchemy.engine.base.Engine.0x..cL {} The DELETE statement clearly works since at this point my table has 0 rows. I know pgsql is doing something with the file because if there is an error in the data I get an exception. And if I run the same statements under the same user account in psql, it results in 39543 rows. Maybe SA is putting second execute in a transaction that isn't being commited? >>> sqlalchemy.__version__ '0.4.2p3' $ psql --version psql (PostgreSQL) 8.3.1 $ uname -a Linux name 2.6.24-16-generic #1 SMP Thu Apr 10 13:23:42 UTC 2008 i686 GNU/Linux Thanks for any pointers. --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "sqlalchemy" group. To post to this group, send email to sqlalchemy@googlegroups.com 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 -~----------~----~----~----~------~----~------~--~---