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

           Summary: Upgrade to 2.1.0b1 fails
           Product: Slony-I
           Version: devel
          Platform: PC
        OS/Version: Linux
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: stored procedures
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: ssinger at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


I tried upgrading my slony 2.0.6 cluster to 2.1 and it failed with

---------------------------

All of Slony-I is successfully installed
ssinger at ssinger-laptop:~/src/slony1-engine/slony1-engine$ slonik
include<test.preamble>
upgrade functions(id=1);
<stdin>:2: ERROR: syntax error at or near upgrade
ssinger at ssinger-laptop:~/src/slony1-engine/slony1-engine$ slonik
include<test.preamble>
update functions(id=1);
<stdin>:2: WARNING:  This node is running PostgreSQL 8.3 - cannot apply
TRUNCATE triggers
CONTEXT:  SQL statement "SELECT  "_test".add_truncate_triggers()"
PL/pgSQL function "upgradeschema" line 11 at PERFORM
<stdin>:2: NOTICE:  Changing Slony-I column [sl_event.ev_timestamp] to
timestamp WITH time zone
<stdin>:2: PGRES_FATAL_ERROR select "_test".upgradeSchema('2.0.6');  - ERROR: 
syntax error at or near "data"
LINE 1: ...le "_test".sl_event alter column ev_timestamp set data type ...
                                                             ^
QUERY:  alter table "_test".sl_event alter column ev_timestamp set data type
timestamp with time zone;
CONTEXT:  PL/pgSQL function "upgradeschema" line 33 at EXECUTE statement
ssinger at ssinger-laptop:~/src/slony1-engine/slony1-engine$

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