Changeset b67d3e3528e327b7942ad1e179bf74c6b22ea0f5 for sql

Timestamp:

11/24/09 04:57:32 (5 years ago)

Author:

Theo Schlossnagle <jesus@omniti.com>

git-committer:

Theo Schlossnagle <jesus@omniti.com> 1259038652 +0000

git-parent:

[945e6311e33234753312cfc16348db1cebe0fae7]

git-author:

Theo Schlossnagle <jesus@omniti.com> 1259038652 +0000

Message:

limit to a single trigger

Files:

• sql/sprocs/stratcon.archive_part_maint.sql (modified) (1 diff)

sql/sprocs/stratcon.archive_part_maint.sql

@@ -94 +94 @@
-              join pg_namespace as n on(p.pronamespace = n.oid) 
-             where relname = v_parent_table and nspname = v_schema_name 
+               and relnamespace = n.oid
-               and proname <> 'parent_empty' LOOP
-          v_sql := 'CREATE TRIGGER ' || v_rec.tgname || '';