Cyril SCETBON wrote:
> 
> 
> Geoffrey wrote:
>> Cyril SCETBON wrote:
>>> Which type of ALTER did you make ?
>>>
>>> Don't forget that there's a special trigger on the source table that 
>>> must be updated too.
>>
>> I'm not sure of how the change was made, I didn't make it.  As far as 
>> I know, all he did was add a new field to one of the tables.  He did 
>> not modify any slony triggers by hand.
> Not good. Check in the slon daemons logs to see what's happening.

I do see the following regarding the field added:


update only "public"."avlds" set 
ship_date='2008-11-06',ship_time='00:00:00',ship_date2='2008-11-06',ship_time2='00:00:00',appt_date='2008-11-06',appt_time='00:00:00' 
where recid='96593';
" ERROR:  column "loop_flag" of relation "avlds" does not exist
LINE 1: ...appt_date,appt_time,hot_flag,shipment_id,air_flag,loop_flag)...


-- 
Until later, Geoffrey

Those who would give up essential Liberty, to purchase a little
temporary Safety, deserve neither Liberty nor Safety.
  - Benjamin Franklin