-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

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,
- --
Stéphane Schildknecht
PostgreSQLFr - http://www.postgresql.fr
Dalibo - http://www.dalibo.com
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFJSQaTA+REPKWGI0ERAnh1AJ4jtcpjRxV1R1kD9VAs0Fj0WnLSswCgxqt+
7mkmHoO3dW52ppmSWPmuWhM=
=vj9F
-----END PGP SIGNATURE-----