INSTR can not supported for postgresql

[Abhishek Kekane]

Recently added migration script doesn't support INSTR function. INSTR function does support sqlite3 and mysql.

[1] https://review.opendev.org/#/c/665606/5

[OpenStack Infra (hudson-openstack)]

Fix proposed to branch: master
Review: https://review.opendev.org/677694

[Goutham Pacha Ravi (gouthamr)]

We run a postgresql job against OpenStack/manila, and this bug shows up there: https://zuul.opendev.org/t/openstack/builds?job_name=manila-tempest-dsvm-postgres-zfsonlinux

Excerpt from devstacklog on that job: http://paste.openstack.org/show/760938/

[OpenStack Infra (hudson-openstack)]

Reviewed: https://review.opendev.org/677694
Committed: https://git.openstack.org/cgit/openstack/glance/commit/?id=6e525647f608839890a8a00a8e03a540a1891471
Submitter: Zuul
Branch: master

commit 6e525647f608839890a8a00a8e03a540a1891471
Author: Abhishek Kekane <email address hidden>
Date: Wed Aug 21 10:38:14 2019 +0000

    Fix INSTR not supported for postgresql

    Migration script 'train_migrate01_backend_to_store.py' doesn't support
    INSTR function for postgresql database. INSTR function does support
    sqlite3 and mysql.

    Used 'POSITION' function instead of 'INSTR' function if database is
    postgresql.
    Closes-Bug: #1840898

    Change-Id: I62c592f0885927b873ed35a1efe4a0f8407e7dee

[OpenStack Infra (hudson-openstack)]

This issue was fixed in the openstack/glance 19.0.0.0b1 development milestone.