Am 29.06.2010 um 19:51 schrieb chaouche yacine:
--- 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}
This is the culprit. It shouldn't work if your not-null-constraint was
working. What does the reflection of the table say, if you say
psql > \d cities;
?
Diez
--
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.
