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