LP1820339: Vandelay Imports on Pg 10
authorJason Stephenson <jason@sigio.com>
Thu, 25 Apr 2019 22:11:59 +0000 (18:11 -0400)
committerJason Boyer <jboyer@library.in.gov>
Wed, 8 May 2019 14:18:56 +0000 (10:18 -0400)
commit50c05dd6bf1a24082c4193b88c167142bb95444e
treebc5c2f22d5fd3a31af4814b5ac36c8d90c12610f
parent4ce058763027e724ee2bfc3b339a0dc77ad61107
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