Stéphane A. Schildknecht wrote:
> -----BEGIN PGP SIGNED MESSAGE-----
> Hash: SHA1
>
> Stéphane A. Schildknecht a écrit :
>   
>> Hi,
>>
>> I'm trying to upgrade from slony 1.2 branch to 2.0 branch.
>>
>> configure, make and make install went fine.
>>
>> I then tried to execute the update functions part, but got an error message.
>>
>> Here's what I did :
>>
>> opt/appli/slony1-2.0/bin/slonik <<_EOF_
>>         #--
>>         # Inclusion du fichier <preamble>
>>         #--
>>         include </opt/appli/slony1/etc/test2.preamble>
>>
>>         #--
>>         # Mise à jours des schémas
>>
>>         #--
>>         try{
>>            update functions ( id=1 );
>>            update functions ( id=2 );
>>            update functions ( id=3 );
>>         }
>>         on error { echo 'Mise à jour schémas Slony : KO' ;}
>>         on success { echo 'Mise à jour schémas Slony : OK' ; }
>>
>> _EOF_
>>
>> And the message I get :
>> <stdin>:10: loading of file /usr/share/postgresql/8.3/slony1_funcs.sql:
>> PGRES_FATAL_ERROR ERREUR:  le type « _test2.vactables » n'existe pas
>> ERREUR:  le type « _test2.vactables » n'existe pas
>> <stdin>:15: Mise à jour schémas Slony : KO
>>
>> PostgreSQL is version 8.3.5, slony version was 1.2.14.
>>
>> In fact, I did some search, and I guess trouble is at loading slony1_func.sql,
>> while trying to create fonction TablesToVacuum () as it returns a setof
>> @NAMESPACE at .vactables, but, that type can't exist, as it is created by a call
>> to upgradeSchema.
>>
>> Should the loading of that file being done in two times ? Once for creation of
>> the type, second for creation of functions using it ?
>>
>> Best regards,
>>     
>
>   
I had a similar issue: 
http://lists.slony.info/pipermail/slony1-general/2008-November/009016.html 
-- in the end, we opted to stay with 1.2.x.

-salman