Changeset 8f3d0bbff627f08aa8e0f50d47bbc884437df826
- 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
| rb67d3e3 |
r8f3d0bb |
|
| 87 | 87 | execute v_rec.sql; |
|---|
| 88 | 88 | END LOOP; |
|---|
| | 89 | RAISE INFO 'set permissions on partition %', v_table_name; |
|---|
| 89 | 90 | |
|---|
| 90 | 91 | FOR v_rec in |
|---|
| … | … | |
| 93 | 94 | join pg_proc as p on(t.tgfoid = p.oid) |
|---|
| 94 | 95 | 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) |
|---|
| 97 | 99 | and proname <> 'parent_empty' LOOP |
|---|
| | 100 | RAISE INFO 'creating trigger % on partition %', v_rec.tgname, v_table_name; |
|---|
| 98 | 101 | v_sql := 'CREATE TRIGGER ' || v_rec.tgname || ''; |
|---|
| 99 | 102 | IF 0 != (v_rec.tgtype & 2) THEN |
|---|
