Changeset 1359

Timestamp:

08/24/09 11:07:26 (15 years ago)

Author:

niltonneto

Message:

Ticket #604 - Correção do problema de cast de variáveis SQL na trigger delete.

Location:

trunk

Files:

• contactcenter/setup/tables_update.inc.php (modified) (1 diff)
• doc-expressolivre/debian/arqs-conf/expresso.dump (modified) (previous)

trunk/contactcenter/setup/tables_update.inc.php

@@ -119 +119 @@
         function contactcenter_upgrade1_21() {
                 $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.0.000';
+                // Bug fixing for type cast problem PGSQL version > 8.1. Replacing trigger function:
+                        $GLOBALS['phpgw_setup']->db->query("CREATE OR REPLACE function share_catalog_delete() returns trigger as '".
+                                        "begin if old.acl_appname = ''contactcenter'' and old.acl_location!=''run'' then delete from ".
+                                        "phpgw_cc_contact_rels where id_contact=old.acl_location::bigint and id_related=old.acl_account ".
+                                        "and id_typeof_contact_relation=1; end if; return new; end;' language 'plpgsql'");
                 return $GLOBALS['setup_info']['contactcenter']['currentver'];
         }