LP1820339: Vandelay Imports on Pg 10 user/bshum/lp1820339_pg10_vandelay_signoff
authorJason Stephenson <jason@sigio.com>
Thu, 25 Apr 2019 22:11:59 +0000 (18:11 -0400)
committerBen Shum <ben@evergreener.net>
Fri, 26 Apr 2019 05:42:58 +0000 (01:42 -0400)
commit5d12da6ae57915dc60d2dde2f1b5c07288d8aad0
tree2fd91261814c3329e52bf363199e4e2ffc994007
parent09d6c61a230468e0fc5e49e5652c77f9dc8dfe1a
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>
Open-ILS/src/sql/Pg/012.schema.vandelay.sql
Open-ILS/src/sql/Pg/upgrade/XXXX.schema.lp1820339-pg10-vandelay.sql