Thanks - I am not sure why this 'gist' is used when creating index tbf. I
dont see any special difference w/o it. Will investigate further though.
Hope this might help if someone bumps into same problem.
Kindest regards
On Thu, Jan 24, 2019 at 6:21 PM Mike Bayer <mike...@zzzcomputing.com> wrote:
> On Thu, Jan 24, 2019 at 12:15 PM Nikola Radovanovic <nikola...@gmail.com>
> wrote:
> >
> > Hi,
> > you are right: I found that geoalchemy2 automatically creates indexes;
> which I eventually turned off in model, using e.g.
> >
> > polygon = Column(Geometry(geometry_type='POLYGON', srid=3857,
> spatial_index=False))
> >
> > and adding them manually to migration script:
> >
> > sa.Column('polygon', Geometry(geometry_type='POLYGON', srid=3857,
> spatial_index=False), nullable=True)
> >
> > op.create_index(op.f('id_tenant_schema_Locations_inhabitant_polygon'),
> 'Locations', ['polygon'], unique=False, postgresql_using='gist',
> schema='tenant_schema')
> >
> > This works apparently. Only thing I am unsure is this part:
> >
> > postgresql_using='gist'
> >
> > Can you please tell me if this is OK - I need to specify 'gist' when
> creating index and not sure did I set it properly.
>
> if it was accepted and created the DDL you wanted then it's right!
> I don't have much experience with the USING thing in PG other than how
> to make it render :)
>
>
>
> >
> >
> > ga2 latest release is 6 or 7 months old, so I think they are alive. What
> helped me greatly is this from their issue list (its still open)
> >
> >
> > Best regards
> >
> > --
> > You received this message because you are subscribed to the Google
> Groups "sqlalchemy-alembic" group.
> > To unsubscribe from this group and stop receiving emails from it, send
> an email to sqlalchemy-alembic+unsubscr...@googlegroups.com.
> > For more options, visit https://groups.google.com/d/optout.
>
> --
> You received this message because you are subscribed to a topic in the
> Google Groups "sqlalchemy-alembic" group.
> To unsubscribe from this topic, visit
> https://groups.google.com/d/topic/sqlalchemy-alembic/yBD4x6IvT4k/unsubscribe
> .
> To unsubscribe from this group and all its topics, send an email to
> sqlalchemy-alembic+unsubscr...@googlegroups.com.
> For more options, visit https://groups.google.com/d/optout.
>
--
You received this message because you are subscribed to the Google Groups
"sqlalchemy-alembic" group.
To unsubscribe from this group and stop receiving emails from it, send an email
to sqlalchemy-alembic+unsubscr...@googlegroups.com.
For more options, visit https://groups.google.com/d/optout.
