--- On Tue, 6/29/10, Diez B. Roggisch <[email protected]> wrote:
> Not for me, but I also added a commit....
>
Thank you Diez, I tested your code but still no exception raised.
Here's the trace (echo=true) :
<trace>
(my-coriolis)chaou...@jogger:~/CODE/TEST/CORIOLIS$ python deleting-diez.py
2010-06-29 18:47:53,934 INFO sqlalchemy.engine.base.Engine.0x...3fcc select
relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where
n.nspname=current_schema() and lower(relname)=%(name)s
2010-06-29 18:47:53,934 INFO sqlalchemy.engine.base.Engine.0x...3fcc {'name':
'countries'}
2010-06-29 18:47:53,939 INFO sqlalchemy.engine.base.Engine.0x...3fcc select
relname from pg_class c join pg_namespace n on n.oid=c.relnamespace where
n.nspname=current_schema() and lower(relname)=%(name)s
2010-06-29 18:47:53,939 INFO sqlalchemy.engine.base.Engine.0x...3fcc {'name':
'cities'}
2010-06-29 18:47:53,942 INFO sqlalchemy.engine.base.Engine.0x...3fcc BEGIN
2010-06-29 18:47:53,942 INFO sqlalchemy.engine.base.Engine.0x...3fcc TRUNCATE
TABLE countries CASCADE
2010-06-29 18:47:53,942 INFO sqlalchemy.engine.base.Engine.0x...3fcc {}
2010-06-29 18:47:54,173 INFO sqlalchemy.engine.base.Engine.0x...3fcc COMMIT
2010-06-29 18:47:54,201 INFO sqlalchemy.engine.base.Engine.0x...3fcc BEGIN
2010-06-29 18:47:54,203 INFO sqlalchemy.engine.base.Engine.0x...3fcc select
nextval('"countries_id_seq"')
2010-06-29 18:47:54,203 INFO sqlalchemy.engine.base.Engine.0x...3fcc None
2010-06-29 18:47:54,205 INFO sqlalchemy.engine.base.Engine.0x...3fcc INSERT
INTO countries (id, name) VALUES (%(id)s, %(name)s)
2010-06-29 18:47:54,205 INFO sqlalchemy.engine.base.Engine.0x...3fcc {'name':
'Algeria', 'id': 58L}
2010-06-29 18:47:54,210 INFO sqlalchemy.engine.base.Engine.0x...3fcc select
nextval('"cities_id_seq"')
2010-06-29 18:47:54,210 INFO sqlalchemy.engine.base.Engine.0x...3fcc None
2010-06-29 18:47:54,211 INFO sqlalchemy.engine.base.Engine.0x...3fcc INSERT
INTO cities (id, name, country_id) VALUES (%(id)s, %(name)s, %(country_id)s)
2010-06-29 18:47:54,212 INFO sqlalchemy.engine.base.Engine.0x...3fcc
{'country_id': 58L, 'name': 'Algiers', 'id': 58L}
2010-06-29 18:47:54,215 INFO sqlalchemy.engine.base.Engine.0x...3fcc COMMIT
2010-06-29 18:47:54,226 INFO sqlalchemy.engine.base.Engine.0x...3fcc BEGIN
2010-06-29 18:47:54,228 INFO sqlalchemy.engine.base.Engine.0x...3fcc SELECT
countries.id AS countries_id, countries.name AS countries_name
FROM countries
WHERE countries.id = %(param_1)s
2010-06-29 18:47:54,229 INFO sqlalchemy.engine.base.Engine.0x...3fcc
{'param_1': 58L}
2010-06-29 18:47:54,231 INFO sqlalchemy.engine.base.Engine.0x...3fcc SELECT
cities.id AS cities_id, cities.name AS cities_name, cities.country_id AS
cities_country_id
FROM cities
WHERE cities.country_id = %(param_1)s
2010-06-29 18:47:54,237 INFO sqlalchemy.engine.base.Engine.0x...3fcc
{'param_1': 58}
2010-06-29 18:47:54,242 INFO sqlalchemy.engine.base.Engine.0x...3fcc UPDATE
cities SET country_id=%(country_id)s WHERE cities.id = %(cities_id)s
2010-06-29 18:47:54,242 INFO sqlalchemy.engine.base.Engine.0x...3fcc
{'country_id': None, 'cities_id': 58}
2010-06-29 18:47:54,244 INFO sqlalchemy.engine.base.Engine.0x...3fcc DELETE
FROM countries WHERE countries.id = %(id)s
2010-06-29 18:47:54,245 INFO sqlalchemy.engine.base.Engine.0x...3fcc {'id': 58}
2010-06-29 18:47:54,246 INFO sqlalchemy.engine.base.Engine.0x...3fcc COMMIT
(my-coriolis)chaou...@jogger:~/CODE/TEST/CORIOLIS$
</trace>
Could this be a some_package_version issue ?
--
You received this message because you are subscribed to the Google Groups
"SQLElixir" 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/sqlelixir?hl=en.
