Jason: I pushed a rebased version to user/dbs/unapi_improve_limit in the working repo, if you care to try it out.
For an upgrade script, I suspect we could pretty much reissue the entire Open-ILS/src/sql/Pg/990.schema.unapi.sql file. If we we're not comfortable dropping an entire schema, then dropping all of the functions with the old INT-based slimit/soffset arguments and reissuing all of the CREATE OR REPLACE FUNCTION statements should do the trick.
Jason: I pushed a rebased version to user/dbs/ unapi_improve_ limit in the working repo, if you care to try it out.
For an upgrade script, I suspect we could pretty much reissue the entire Open-ILS/ src/sql/ Pg/990. schema. unapi.sql file. If we we're not comfortable dropping an entire schema, then dropping all of the functions with the old INT-based slimit/soffset arguments and reissuing all of the CREATE OR REPLACE FUNCTION statements should do the trick.