NSM5200: Messages file shows ERROR: language plpgsql does not exist


An update from v2.3.1.0259 to v2.4.4.0009 has failed.

Product Line

Pelco Video Management


NSM5200 version being updated to


The plpgsql language is not present in the postgres database in version Use the below script to query the languages that are currently installed.

/usr/local/pgsql/bin/psql -U pelco -d nsd -c "select * from pg_language;"


Create the language using the below script then apply the update to  Rerun the script above to validate the language was created. Note: Running the below script on a system that already has this language installed will not affect it.

/usr/local/pgsql/bin/psql -U postgres -d nsd -c "create language plpgsql;"