#/bin/sh
echo CREATE or REPLACE FUNCTION partition_insert_trigger\(\) RETURNS trigger AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION partition_update_trigger\(\) RETURNS trigger AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION partition_insert_trigger_hash\(\) RETURNS trigger AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION partition_constraints_hash\(\) RETURNS trigger AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION dumppartitionedtableschema\(oid\) RETURNS text AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION isvalidoverflowpartition\(oid\) RETURNS integer AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION getparentfromoverflow\(oid\) RETURNS text AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION minval\(oid\) RETURNS text AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION maxval\(oid\) RETURNS text AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION parttype\(int\) RETURNS text AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE or REPLACE FUNCTION isoverflowindex\(oid\) RETURNS int AS "'"$1/src/test/regress/regress.so"'" LANGUAGE C";"
echo CREATE VIEW pg_partitions as \(SELECT c.relname parent, b.relname child, parttype \(a.parttype\), d.attname attr, \
a.keyorder, minval\(a.oid\), maxval\(a.oid\) from pg_partition a, pg_class b,  pg_class c, pg_attribute d \
where a.partrelid = b.oid AND a.parentrelid = c.oid AND  a.partrelid = d.attrelid AND a.partkey = d.attnum\)";"

