Michael Bayer wrote:
On May 19, 2010, at 5:34 AM, jose soares wrote:
Hi all,
I have to create a constraint like this:
CheckConstraint('data_start <= CURRENT_DATE'),
it works for PostgreSQL but it doesn't work for Oracle10.
Is there some workaround to make it compatible with pg and oracle?
Assuming there's a way to create such a CHECK constraint on Oracle, you should
use the DDL() construct with per-dialect instructions for Oracle - and for your
CheckConstraint that works on PG, set it up with an AddConstraint that is
specific to Postgresql.
http://www.sqlalchemy.org/docs/metadata.html#customizing-ddl
Oracle doesn't support such constrtaint, then I have to find a way to
create it, not at db level, but in the code.
My hope was to be able to define it, only at SQLAlchemy level, like we
do with some sa functions.
j
--
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.
