After applying the patch: regprocedure_7.4.patch
I took a guess that the following command would apply the SQL commands to the database but it returns this error.
[postgres][postgresql-7.4.7]>psql -f regprocedure_update.sql {DBNAME}
BEGIN
psql:regprocedure_update.sql:6: ERROR: relation "pg_ts_dict" does not exist
psql:regprocedure_update.sql:7: ERROR: current transaction is aborted, commands ignored until end of transaction block
.
.
.
psql:regprocedure_update.sql:54: ERROR: current transaction is aborted, commands ignored until end of transaction block
COMMIT
VACUUM