Show
Ignore:
Timestamp:
11/24/09 05:17:35 (3 years ago)
Author:
Theo Schlossnagle <jesus@omniti.com>
git-committer:
Theo Schlossnagle <jesus@omniti.com> 1259039855 +0000
git-parent:

[b67d3e3528e327b7942ad1e179bf74c6b22ea0f5]

git-author:
Theo Schlossnagle <jesus@omniti.com> 1259039855 +0000
Message:

fix creation bug cross-schema

Files:

Legend:

Unmodified
Added
Removed
Modified
Copied
Moved

  • sql/sprocs/stratcon.archive_part_maint.sql

    rb67d3e3 r8f3d0bb  
    8787          execute v_rec.sql; 
    8888        END LOOP; 
     89        RAISE INFO 'set permissions on partition %', v_table_name; 
    8990 
    9091        FOR v_rec in 
    …… 
    9394              join pg_proc as p on(t.tgfoid = p.oid) 
    9495              join pg_namespace as n on(p.pronamespace = n.oid)  
    95              where relname = v_parent_table and nspname = v_schema_name  
    96                and relnamespace = n.oid 
     96             where relname = v_parent_table 
     97               and relnamespace in (select oid from pg_namespace 
     98                                     where nspname = v_schema_name) 
    9799               and proname <> 'parent_empty' LOOP 
     100          RAISE INFO 'creating trigger % on partition %', v_rec.tgname, v_table_name; 
    98101          v_sql := 'CREATE TRIGGER ' || v_rec.tgname || ''; 
    99102          IF 0 != (v_rec.tgtype & 2) THEN