Changeset a905d08014f72c334b467899569fc812d9e5ca7e

Show
Ignore:
Timestamp:
10/27/09 19:05:54 (4 years ago)
Author:
Robert Treat <robert@omniti.com>
git-committer:
Robert Treat <robert@omniti.com> 1256670354 +0000
git-parent:

[60d5e7392f328a65f988f7c7402b6a1bf7d4d5a6]

git-author:
Robert Treat <robert@omniti.com> 1256670354 +0000
Message:

only recreate triggers from this table

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved
  • sql/sprocs/stratcon.archive_part_maint.sql

    r60d5e73 ra905d08  
    9393              join pg_proc as p on(t.tgfoid = p.oid) 
    9494              join pg_namespace as n on(p.pronamespace = n.oid)  
    95              where relname = v_parent_table 
     95             where relname = v_parent_table and nspname = v_schema_name  
    9696               and proname <> 'parent_empty' LOOP 
    9797          v_sql := 'CREATE TRIGGER ' || v_rec.tgname || '';