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

           Summary: Need for Postgres statement processor to process
                    statements individually
           Product: Slony-I
           Version: devel
          Platform: Other
        OS/Version: Other
            Status: NEW
          Severity: enhancement
          Priority: low
         Component: slon
        AssignedTo: slony1-bugs at lists.slony.info
        ReportedBy: cbbrowne at ca.afilias.info
                CC: slony1-bugs at lists.slony.info
   Estimated Hours: 0.0


Slony needs, at present, to split EXECUTE SCRIPT requests into statements
because the parser in the backend presently plans based on the entire set of
parsed material at once.

As result, the following sorts of pairs of statements need to be processed as
separate submissions since the later statement fails (if combined) due to the
parser thinking the state of the DB doesn't include the first query...

create table foo (id serial primary key, name text);
create unique index foo_name on foo(name);

create table bar (id serial primary key, name text);
alter table bar add column as_at timestamptz;

It Sure Would Be Nice if the Postgres backend could cope with this; that would
allow dropping out all the complications in Slony surrounding splitting DDL
into statements.

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