By the way, on a larger database, drop_all() runs into an endless
loop. However, I have no small script to reproduce this yet.
Klaus
On 7 Nov., 16:39, klaus <[EMAIL PROTECTED]> wrote:
> That's very kind.
>
> I'm on the trunk (0.4.1dev_r3747) and on linux. And I think your
> script (with a changed connection string, nothing else) fails on my
> machine. Here's the complete output:
>
> 2007-11-07 16:33:14,848 INFO sqlalchemy.engine.base.Engine.0x..b4
> 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
> 2007-11-07 16:33:14,848 INFO sqlalchemy.engine.base.Engine.0x..b4
> {'name': 'referer'}
> 2007-11-07 16:33:14,940 INFO sqlalchemy.engine.base.Engine.0x..b4
> 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
> 2007-11-07 16:33:14,940 INFO sqlalchemy.engine.base.Engine.0x..b4
> {'name': 'test'}
> 2007-11-07 16:33:14,941 INFO sqlalchemy.engine.base.Engine.0x..b4
> DROP TABLE referer
> 2007-11-07 16:33:14,941 INFO sqlalchemy.engine.base.Engine.0x..b4 {}
> 2007-11-07 16:33:15,304 INFO sqlalchemy.engine.base.Engine.0x..b4
> COMMIT
> 2007-11-07 16:33:15,397 INFO sqlalchemy.engine.base.Engine.0x..b4
> DROP TABLE test
> 2007-11-07 16:33:15,397 INFO sqlalchemy.engine.base.Engine.0x..b4 {}
> 2007-11-07 16:33:15,430 INFO sqlalchemy.engine.base.Engine.0x..b4
> COMMIT
> 2007-11-07 16:33:15,439 INFO sqlalchemy.engine.base.Engine.0x..b4
> 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
> 2007-11-07 16:33:15,439 INFO sqlalchemy.engine.base.Engine.0x..b4
> {'name': 'test'}
> 2007-11-07 16:33:15,440 INFO sqlalchemy.engine.base.Engine.0x..b4
> 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
> 2007-11-07 16:33:15,440 INFO sqlalchemy.engine.base.Engine.0x..b4
> {'name': 'referer'}
> 2007-11-07 16:33:15,441 INFO sqlalchemy.engine.base.Engine.0x..b4
> CREATE TABLE test (
> id SERIAL NOT NULL,
> data TEXT,
> PRIMARY KEY (id)
> )
>
> 2007-11-07 16:33:15,442 INFO sqlalchemy.engine.base.Engine.0x..b4 {}
> 2007-11-07 16:33:15,893 INFO sqlalchemy.engine.base.Engine.0x..b4
> COMMIT
> 2007-11-07 16:33:15,894 INFO sqlalchemy.engine.base.Engine.0x..b4
> CREATE TABLE referer (
> id SERIAL NOT NULL,
> fk INTEGER,
> PRIMARY KEY (id),
> FOREIGN KEY(fk) REFERENCES test (id)
> )
>
> 2007-11-07 16:33:15,894 INFO sqlalchemy.engine.base.Engine.0x..b4 {}
> 2007-11-07 16:33:15,958 INFO sqlalchemy.engine.base.Engine.0x..b4
> COMMIT
> 2007-11-07 16:33:15,963 INFO sqlalchemy.engine.base.Engine.0x..b4
> INSERT INTO test (data) VALUES (%(data)s)
> 2007-11-07 16:33:15,963 INFO sqlalchemy.engine.base.Engine.0x..b4
> [{'data': 1}, {'data': 2}, {'data': 3}, {'data': 4}, {'data': 5},
> {'data': 6}, {'data': 7}, {'data': 8}, {'data': 9}, {'data': 10},
> {'data': 11}, {'data': 12}, {'data': 13}, {'data': 14}, {'data': 15},
> {'data': 30}, {'data': 44}, {'data': 55}]
> 2007-11-07 16:33:15,968 INFO sqlalchemy.engine.base.Engine.0x..b4
> COMMIT
> 2007-11-07 16:33:15,969 INFO sqlalchemy.engine.base.Engine.0x..b4
> select nextval('"referer_id_seq"')
> 2007-11-07 16:33:15,969 INFO sqlalchemy.engine.base.Engine.0x..b4 None
> 2007-11-07 16:33:15,970 INFO sqlalchemy.engine.base.Engine.0x..b4
> INSERT INTO referer (id, fk) VALUES (%(id)s, %(fk)s)
> 2007-11-07 16:33:15,970 INFO sqlalchemy.engine.base.Engine.0x..b4
> {'fk': 2, 'id': 1L}
> 2007-11-07 16:33:15,971 INFO sqlalchemy.engine.base.Engine.0x..b4
> COMMIT
> 2007-11-07 16:33:15,976 INFO sqlalchemy.engine.base.Engine.0x..b4
> SELECT "testView".id AS "testView_id", "testView".data AS
> "testView_data"
> FROM (SELECT test.id AS id, test.data AS data
> FROM test
> WHERE test.id IN (%(test_id)s, %(test_id_1)s, %(test_id_2)s, %
> (test_id_3)s, %(test_id_4)s, %(test_id_5)s, %(test_id_6)s, %
> (test_id_7)s, %(test_id_8)s, %(test_id_9)s, %(test_id_10)s)) AS
> "testView"
> WHERE "testView".id = %(param_1)s ORDER BY "testView".id
> 2007-11-07 16:33:15,976 INFO sqlalchemy.engine.base.Engine.0x..b4
> {'test_id_3': 5, 'test_id_10': 45, 'param_1': None, 'test_id_8': 30,
> 'test_id_9': 44, 'test_id_1': 3, 'test_id_2': 4, 'test_id': 2,
> 'test_id_4': 8, 'test_id_5': 10, 'test_id_6': 11, 'test_id_7': 13}
> None
> 2007-11-07 16:33:15,979 INFO sqlalchemy.engine.base.Engine.0x..b4
> SELECT referer.id AS referer_id, referer.fk AS referer_fk
> FROM referer
> WHERE referer.id = %(param_1)s ORDER BY referer.id
> 2007-11-07 16:33:15,979 INFO sqlalchemy.engine.base.Engine.0x..b4
> {'param_1': 1}
> 22007-11-07 16:33:15,982 INFO sqlalchemy.engine.base.Engine.0x..b4
> SELECT "testView".id AS "testView_id", "testView".data AS
> "testView_data"
> FROM (SELECT test.id AS id, test.data AS data
> FROM test
> WHERE test.id IN (%(test_id)s, %(test_id_1)s, %(test_id_2)s, %
> (test_id_3)s, %(test_id_4)s, %(test_id_5)s, %(test_id_6)s, %
> (test_id_7)s, %(test_id_8)s, %(test_id_9)s, %(test_id_10)s)) AS
> "testView"
> WHERE "testView".id = %(param_1)s ORDER BY "testView".id
> 2007-11-07 16:33:15,982 INFO sqlalchemy.engine.base.Engine.0x..b4
> {'test_id_3': 5, 'test_id_10': 45, 'param_1': None, 'test_id_8': 30,
> 'test_id_9': 44, 'test_id_1': 3, 'test_id_2': 4, 'test_id': 2,
> 'test_id_4': 8, 'test_id_5': 10, 'test_id_6': 11, 'test_id_7': 13}
> None
>
> What I checked today is that Python (2.5.1 versus the installed 2.4.1)
> plus the latest psycopg2 does not make a difference.
>
> Best regards
> Klaus
>
> On 7 Nov., 16:24, Michael Bayer <[EMAIL PROTECTED]> wrote:
>
> > On Nov 7, 2007, at 6:01 AM, klaus wrote:
>
> > > This is strange. I had problems reproducing the bug for a long time
> > > and was now quite happy that I succeeded.
>
> > > Yes, I'm using PostgreSQL 8.1.5 and psycopg2. And I still see the
> > > behavior that I reported. That should narrow the problem down to
> > > something in my local setup... I'm sorry for wasting your time.
>
> > are you on release 0.4.0 ? attached is the full script i was using, i
> > moved the tables around so that I could use drop_all()/create_all().
> > Additionally, I just remembered that there are often dictionary-
> > ordering related issues which will occur on linux but not OSX (which
> > is my normal platform). So I'll try on linux later today...or if
> > anyone else wants to run the attached script with PG, SA0.4 and a
> > linux machine that would be helpful.
>
> > test.py
> > 1KHerunterladen
--~--~---------~--~----~------------~-------~--~----~
You received this message because you are subscribed to the Google Groups
"sqlalchemy" 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/sqlalchemy?hl=en
-~----------~----~----~----~------~----~------~--~---
