[sqlalchemy] Re: Direct execute of postgres COPY

2008-05-22 Thread schickb
On May 22, 8:37 pm, schickb <[EMAIL PROTECTED]> wrote: > Maybe SA is putting second execute in a transaction that isn't > being commited? That was the problem. I found this in the SA docs: "While many DBAPIs implement a flag called autocommit, the current SQLAlchemy be

[sqlalchemy] Direct execute of postgres COPY

2008-05-22 Thread schickb
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('postgr