"Stéphane A. Schildknecht" <stephane.schildknecht at postgresqlfr.org> writes:
> lio bod a écrit :
>> Hello world,
>>  
>> Still having fun with supplied shell scripts :
>>  
>> After setting env variales, i made work configure-replication.sh
>>  
>>>/tmp/slonytest-temp.Q17311/create_set.slonik
>>>/tmp/slonytest-temp.Q17311/create_set.slonik:29: ERROR: syntax error at
>> or near snum
>>  
>> The file create_set.slonik looks like that :
>>  
>> [.../...]
>> set add table (id=2, set id=1, origin=1, fully qualified
>> name='public.mytable1', comment='mycluster table public.mytable1');
>> set add sequence (id=1, set id=1, origin=1, fully qualified
>> name='public.mysequence1', comment='mycluster sequence
>> public.mysequence1'); snum=2
>> [.../...]
>>  
>> Where does the 'snum=2' comes from?
>
> It's a bug in the script. A carriage return has disappeared on line 150.
>
> You should have
>
> 150c150,151
> <     echo "set add sequence (id=${snum}, set id=1, origin=1, fully qualified
> name='${seq}', comment='${CLUSTER} sequence ${seq}');" >> $SETUPSET
> snum=`expr ${snum} + 1`
> ---
>>     echo "set add sequence (id=${snum}, set id=1, origin=1, fully qualified
> name='${seq}', comment='${CLUSTER} sequence ${seq}');" >> $SETUPSET
>>     snum=`expr ${snum} + 1`

Fixed in REL_1_2_STABLE; it's evidently fine in CVS HEAD...
-- 
select 'cbbrowne' || '@' || 'ca.afilias.info';
<http://dba2.int.libertyrms.com/>
Christopher Browne
(416) 673-4124 (land)