Possibly it is because you have used BEGIN/COMMIT statements inside the
slonik script?
(I'm not sure that exactly this caused your problem, but you surely MUST
avoid using a BEGIN statement.)

On 9/14/07, Richard Yen <dba at richyen.com> wrote:
>
> btw, replication is still happily proceeding...
>
> --Richard
>
>
> On Sep 14, 2007, at 11:50 AM, Richard Yen wrote:
>
> > Hi All,
> >
> > Ran an EXECUTE SCRIPT command, but somewhere, the script failed.
> > The DDL statements were successfully executed on the provider, but
> > for the two subscribers, naturally, nothing happened.
> >
> > Now, I'm wondering what I need to do?  Manually add the columns in
> > on the subscribers?  Attempt to drop the columns from the
> > provider?  Do something else?
> >
> > Here is the output of my slonik command:
> >> perform a single schema change
> >> DDL script consisting of 4 SQL statements
> >> DDL Statement 0: (0,6) [BEGIN;]
> >> <stdin>:6: WARNING:  there is already a transaction in progress
> >> DDL Statement 1: (6,57) [
> >> ALTER TABLE m_nodes ADD COLUMN crawl_host VARCHAR;]
> >> DDL Statement 2: (57,109) [
> >> ALTER TABLE m_nodes ADD COLUMN crawl_port SMALLINT;]
> >> DDL Statement 3: (109,117) [
> >> COMMIT;]
> >> Complete DDL Event...
> >> Event submission for DDL failed - PGRES_FATAL_ERROR
> >> <stdin>:6: WARNING:  there is no transaction in progress
> >
> > Not sure if it helps much.  I'm still scouring around my logs for
> > the statement that failed, but I don't think I can uncover it...
> >
> > Any suggestions/little known facts about what I can do?
> >
> > Thanks!
> > --Richard
> > _______________________________________________
> > Slony1-general mailing list
> > Slony1-general at lists.slony.info
> > http://lists.slony.info/mailman/listinfo/slony1-general
>
> _______________________________________________
> Slony1-general mailing list
> Slony1-general at lists.slony.info
> http://lists.slony.info/mailman/listinfo/slony1-general
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.slony.info/pipermail/slony1-general/attachments/20070914/=
effe6746/attachment.htm