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

           Summary: cant add column using slonik and execute_script
           Product: Slony-I
           Version: 2.0
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: critical
          Priority: low
         Component: slonik
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: sebpaa at gmail.com
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


using slony 2.2.2

i tried to add column to existing table in replication with this query:

ALTER TABLE xxxx ADD COLUMN is_catalog BOOLEAN DEFAULT FALSE NOT NULL;

using execute_script, my slonik script contains:

cluster name = getmedia;
 node 1 admin conninfo='host=192.168.10.241 dbname=getmedia user=slony
port=5900';
 node 2 admin conninfo='host=192.168.10.242 dbname=getmedia user=slony
port=5900';
 node 3 admin conninfo='host=192.168.10.229 dbname=getmedia user=slony
port=5900';
 node 4 admin conninfo='host=192.168.10.253 dbname=dashboarddata user=slony
port=5900';
 node 6 admin conninfo='host=192.168.10.248 dbname=dashboarddata user=slony
port=5900';
 node 8 admin conninfo='host=192.168.10.240 dbname=anasys user=slony
port=5910';
  execute script (
    SQL = 'ALTER TABLE payments_sellablecategory ADD COLUMN is_catalog BOOLEAN
DEFAULT FALSE NOT NULL',
    event node = 2
  );

i got an error:

PGRES_FATAL_ERROR [ALTER TABLE payments_sellablecategory ADD COLUMN is_catalog
BOOLEAN DEFAULT FALSE NOT NULL;] - ERROR:  value "6000633357" is out of range
for type integer
CONTEXT:  PL/pgSQL function "ddlcapture" while casting return value to
function's return type

error occurs every time with different integer value :/

one month ago i've upgraded slony from 2.1 to 2.2 and everythin was looking
good, till now.

-- 
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.