Changeset 1359


Ignore:
Timestamp:
08/24/09 11:07:26 (12 years ago)
Author:
niltonneto
Message:

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

Location:
trunk
Files:
2 edited

Legend:

Unmodified
Added
Removed
  • trunk/contactcenter/setup/tables_update.inc.php

    r1323 r1359  
    119119        function contactcenter_upgrade1_21() { 
    120120                $GLOBALS['setup_info']['contactcenter']['currentver'] = '2.0.000'; 
     121                // Bug fixing for type cast problem PGSQL version > 8.1. Replacing trigger function: 
     122                        $GLOBALS['phpgw_setup']->db->query("CREATE OR REPLACE function share_catalog_delete() returns trigger as '". 
     123                                        "begin if old.acl_appname = ''contactcenter'' and old.acl_location!=''run'' then delete from ". 
     124                                        "phpgw_cc_contact_rels where id_contact=old.acl_location::bigint and id_related=old.acl_account ". 
     125                                        "and id_typeof_contact_relation=1; end if; return new; end;' language 'plpgsql'"); 
    121126                return $GLOBALS['setup_info']['contactcenter']['currentver']; 
    122127        } 
Note: See TracChangeset for help on using the changeset viewer.