http://www.slony.info/bugzilla/show_bug.cgi?id=221

           Summary: implicit cast (int to text) make ERROR at initialize
                    and cleanup
           Product: Slony-I
           Version: 2.0
          Platform: All
        OS/Version: All
            Status: NEW
          Severity: minor
          Priority: low
         Component: core scripts
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: harukat at sraoss.co.jp
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


I report a problem on slony-I 2.0.6 (or HEAD).

We define a implicit cast on INT to TEXT for the migration 
PostgreSQL 8.2.x to 9.0.x. This causes Slony-I errors at
initialize and cleanup-thread.

It seems to me that to add explicit cast in addPartialLogIndices()
is the workaround.


cast definition:

CREATE CAST ( int4 AS text ) WITH INOUT AS IMPLICIT;

error message:
---
<stdin>:70: PGRES_FATAL_ERROR select "_baitoru_p01".storeSet_int
(1, 1, 'All hatarako tables');
  - ERROR:  operator is not unique: text || integer
LINE 1: ...d_baitoru_p01_sl_log_' || v_log::text || '-node-' || v_dummy...
                                                             ^
HINT:  Could not choose a best candidate operator. You might need to
 add explicit type casts.
QUERY:  SELECT 'PartInd_baitoru_p01_sl_log_' || v_log::text || '-node-'
 || v_dummy.set_origin
CONTEXT:  PL/pgSQL function "addpartiallogindices" line 28 at assignment
SQL statement "SELECT "_baitoru_p01".addPartialLogIndices()"
PL/pgSQL function "storeset_int" line 31 at PERFORM
---

workaround ? :
in src/backend/slony1_funcs.sql function @NAMESPACE at .addPartialLogIndices ()

add explicit cast

 v_iname := 'PartInd_ at CLUSTERNAME@_sl_log_' || v_log::text || '-node-' ||
             v_dummy.set_origin::text;
                               ~~~~~~

-- 
Configure bugmail: http://www.slony.info/bugzilla/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are on the CC list for the bug.
You are the assignee for the bug.