Errors on fresh run of `psql -f pgstac.sql`

[cole-floodbase]

Tried psql -f pgstac.sql on an empty PostgreSQL 12 GCP Cloud SQL database on commit d60d7e8 and got some errors, especially:

psql:sql/003_items.sql:269: NOTICE:  trigger "items_stmt_trigger" for relation "items" does not exist, skipping
psql:sql/004_search.sql:191: ERROR:  return type mismatch in function declared to return box3d

Here's the full output:

BEGIN
CREATE EXTENSION
CREATE SCHEMA
CREATE EXTENSION
CREATE SCHEMA
SET
CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
SET
CREATE TABLE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
SET
CREATE TABLE
ALTER TABLE
CREATE TABLE
ALTER TABLE
DELETE 0
 create_parent 
---------------
 t
(1 row)

CREATE FUNCTION
CREATE FUNCTION
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE INDEX
CREATE TYPE
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:sql/003_items.sql:269: NOTICE:  trigger "items_stmt_trigger" for relation "items" does not exist, skipping
DROP TRIGGER
CREATE TRIGGER
CREATE VIEW
CREATE VIEW
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
SET
DROP VIEW
CREATE VIEW
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
CREATE FUNCTION
psql:sql/004_search.sql:191: ERROR:  return type mismatch in function declared to return box3d
DETAIL:  Actual return type is geometry.
CONTEXT:  SQL function "bbox_geom"
psql:sql/004_search.sql:195: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/004_search.sql:199: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/004_search.sql:259: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/004_search.sql:279: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/004_search.sql:288: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/004_search.sql:330: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/004_search.sql:361: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/004_search.sql:371: ERROR:  current transaction is aborted, commands ignored until end of transaction block
psql:sql/004_search.sql:595: ERROR:  current transaction is aborted, commands ignored until end of transaction block
ROLLBACK