From 2d1e477c76de97faab36c6a168a7855357630aad Mon Sep 17 00:00:00 2001 From: miker Date: Fri, 28 Aug 2009 15:51:52 +0000 Subject: [PATCH] add the tsearch2 config tables for pg 8.1 and 8.2 git-svn-id: svn://svn.open-ils.org/ILS/trunk@13933 dcc99617-32d9-48b4-a31d-7c20da2025e4 --- Open-ILS/examples/build-eg-replication.sh | 27 ++++++++++++++++----------- 1 file changed, 16 insertions(+), 11 deletions(-) diff --git a/Open-ILS/examples/build-eg-replication.sh b/Open-ILS/examples/build-eg-replication.sh index 9da71b7370..470abfa834 100644 --- a/Open-ILS/examples/build-eg-replication.sh +++ b/Open-ILS/examples/build-eg-replication.sh @@ -50,17 +50,22 @@ if [ "_$PGUSER" == "_" ]; then exit fi -TABLES=$(psql -tc " - select array_to_string(array_accum(table_schema || '.' || table_name),' ') - from information_schema.tables - where table_schema in ( - 'action', 'actor', 'asset', 'authority', 'auditor', 'biblio', 'config', - 'container', 'extend_reporter', 'metabib', 'money', 'offline', 'permission', - 'reporter', 'search', 'stats', 'vandely' - ) and table_type = 'BASE TABLE' order by 1; -") - -SEQUENCES=$(psql -tc "select array_to_string(array_accum(schemaname || '.' || relname),' ') from pg_statio_user_sequences;") +if [ "_$TABLES" == "_" ]; then + TABLES=$(psql -tc " + select array_to_string(array_accum(table_schema || '.' || table_name),' ') + from information_schema.tables + where table_schema in ( + 'action', 'actor', 'asset', 'authority', 'auditor', 'biblio', 'config', + 'container', 'extend_reporter', 'metabib', 'money', 'offline', 'permission', + 'reporter', 'search', 'stats', 'vandely' + ) and table_type = 'BASE TABLE' order by 1; + ") + TABLES="$TABLES pg_ts_cfg pg_ts_cfgmap" +fi + +if [ "_$SEQUENCES" == "_" ]; then + SEQUENCES=$(psql -tc "select array_to_string(array_accum(schemaname || '.' || relname),' ') from pg_statio_user_sequences;") +fi if [ "_$1" == "_" ]; then -- 2.11.0