LP1820339: Vandelay Imports on Pg 10
authorJason Stephenson <jason@sigio.com>
Thu, 25 Apr 2019 22:11:59 +0000 (18:11 -0400)
committerJason Stephenson <jason@sigio.com>
Fri, 5 Jul 2019 14:07:48 +0000 (10:07 -0400)
commitca880ab8f9a42bef7ac1e25ad3ad3d45ea2433af
tree99682d0758039c933ba4ef9d3fc36c0655248177
parentb05293deb440fbb9b976b7b97756017df81ccb06
LP1820339: Vandelay Imports on Pg 10

The previous commit used a function that only exists in Pg 10, so it
would require everyone to upgrade PostgreSQL.

After some investigation, Ben Shum and I found a method that works on
Pg 9.4 through Pg 10 by putting the existing function into a
subselect as suggested by PostgreSQL documentation.

Signed-off-by: Jason Stephenson <jason@sigio.com>
Signed-off-by: Ben Shum <ben@evergreener.net>
Signed-off-by: Jason Boyer <jboyer@library.in.gov>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1820339-pg10-vandelay.sql