Yep, that worked. Thanks!
On Wednesday, 24 April 2013 15:37:26 UTC+1, Michael Bayer wrote:
>
> actually, the issue is that it requires a SQL expression, this should be
> improved, but for now do this:
>
> from sqlalchemy.sql import text
>
> op.create_index(
> 'geocoded',
> 'locations',
> ['coordinates'],
> postgresql_where=text("locations.coordinates != Null"))
>
>
>
>
>
> On Apr 24, 2013, at 10:35 AM, Michael Bayer
> <[email protected]<javascript:>>
> wrote:
>
> are you getting a stack trace (I am) ? that would be a bug which needs
> repair.
>
>
> On Apr 24, 2013, at 10:24 AM, Stephan Hügel <[email protected]<javascript:>>
> wrote:
>
> This will probably be an obvious answer, but I'm struggling to figure out
> how to add a partial index using an Alembic (0.5.0) revision.
>
> from alembic import op
> import sqlalchemy as sa
>
>
> def upgrade():
> op.create_index(
> 'geocoded',
> 'locations',
> ['coordinates'],
> postgresql_where=locations.coordinates != Null")
>
>
> def downgrade():
> op.drop_index("geocoded")
>
> Isn't working – is it valid to pass that keyword to create_index, and if
> so, what string should I be passing?
>
> --
> You received this message because you are subscribed to the Google Groups
> "sqlalchemy" group.
> To unsubscribe from this group and stop receiving emails from it, send an
> email to [email protected] <javascript:>.
> To post to this group, send email to [email protected]<javascript:>
> .
> Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
> For more options, visit https://groups.google.com/groups/opt_out.
>
>
>
>
>
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to [email protected].
To post to this group, send email to [email protected].
Visit this group at http://groups.google.com/group/sqlalchemy?hl=en.
For more options, visit https://groups.google.com/groups/opt_out.
