#! /bin/sh

# Adds or updates stored procedures in pathena database.
# May be run as a standalone script after updgrading distribution.
# Assumes postmaster already started on designated port.

# Home directory for Pathena files is changed in this script
# by invoking script 'build/relocate'.

export PATHENA=~/.pathena

if [ -e $PATHENA/config/definitions ];
    then DEFS=config ;
    else DEFS=bin ;
fi
source $PATHENA/$DEFS/definitions

cd $PATHENA

$PGBIN/psql -p $PGPORT -d pathena < server/procedures.sql

echo -e "\nAdded/updated stored procedures for Pathena database."
