-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1
Gerry Reno ha scritto:
> Been doing great with SQLAlchemy 0.6beta1 for the past week after a
> couple snags migrating from 5.5.
>
> Today I hit a small problem with postgresql on DropTables:
>
> running this command:
> engine.execute(DropTable(table, cascade=True))
>
> produced this error:
> sqlalchemy.exc.ProgrammingError: (ProgrammingError) syntax error at or
> near "CONSTRAINTS"
> LINE 2: DROP TABLE users CASCADE CONSTRAINTS
> ^
> '\nDROP TABLE users CASCADE CONSTRAINTS' {}
>
> The problem seems to be with the keyword 'CONSTRAINTS' for the
> postgresql dialect. The drop succeeds without it.
>
I have reported the same problem a few days ago.
Support for cascading has been removed very recently, since it used
Oracle only syntax.
> [...]
Manlio
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.10 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org
iEYEARECAAYFAkuYt9kACgkQscQJ24LbaUTTFACgiYx4yWm7mT3ulZvYdt9wWLgf
gQEAn3IwidE3nba7o4hc2jW7iGoTbiPU
=Yne8
-----END PGP SIGNATURE-----
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To post to this group, send email to sqlalch...@googlegroups.com.
To unsubscribe from this group, send email to
sqlalchemy+unsubscr...@googlegroups.com.
For more options, visit this group at
http://groups.google.com/group/sqlalchemy?hl=en.
