#!/bin/sh
#
# $Id: install 74 2007-11-08 21:13:18Z decibel $
#
# Copyright (c) 2004, Jim C. Nasby (decibel@rrs.decibel.org)
# All rights reserved.

plpgsql=`psql -qtc "SELECT EXISTS( SELECT * FROM pg_language WHERE lanname='plpgsql' )" $@`
if [ $? -ne 0 ]; then
    echo "ERROR: Unable to determine if plpgsql is installed" 1>&2
    exit 1
fi

if [ $plpgsql == f ]; then
    psql -qc 'CREATE LANGUAGE plpgsql' $@ >/dev/null || exit 1
fi

cd `dirname $0`

psql -f install.sql $@
