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
_______________________________________________
Slony1-general mailing list
[email protected]
http://lists.slony.info/mailman/listinfo/slony1-general
