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

Hi,

I'm facing a strange error, I never saw yet.

I'm trying to settle a replication between 2 nodes, each of them running PG8.3.7.

Slony is version 2.0.2.

<stdin>:59: PGRES_FATAL_ERROR select "_gvr".setAddTable(1, 1, 'public.mytable',
'mytable_pk', 'table public.mytable');  - ERROR:  function
pg_catalog.quote_literal(integer) is not unique
LINE 1: ... (' || pg_catalog.quote_literal('_gvr') || ',' || pg_catalog...
                                                             ^
HINT:  Could not choose a best candidate function. You might need to add
explicit type casts.
QUERY:  SELECT  'create trigger "_gvr_logtrigger"' || ' after insert or update
or delete on ' ||  $1  || ' for each row execute procedure "_gvr".logTrigger ('
|| pg_catalog.quote_literal('_gvr') || ',' || pg_catalog.quote_literal( $2 ) ||
',' || pg_catalog.quote_literal( $3 ) || ');'
CONTEXT:  PL/pgSQL function "altertableaddtriggers" line 53 at EXECUTE statement
SQL statement "SELECT  "_gvr".alterTableAddTriggers( $1 )"
PL/pgSQL function "setaddtable_int" line 109 at PERFORM
SQL statement "SELECT  "_gvr".setAddTable_int( $1 ,  $2 ,  $3 ,  $4 ,  $5 )"
PL/pgSQL function "setaddtable" line 37 at PERFORM

What could have caused such an issue?

I have two pg_catalog.quote_literal() functions:

 pg_catalog | quote_literal | text                        | anyelement
 pg_catalog | quote_literal | text                        | text

There's one thing I did, btw, it's adding implicit casts as described here:
http://wiki.postgresql.org/images/d/d1/Pg83-implicit-casts.sql

Cheers,
- --
Stéphane Schildknecht
PostgreSQLFr - http://www.postgresql.fr
-----BEGIN PGP SIGNATURE-----
Version: GnuPG v1.4.6 (GNU/Linux)
Comment: Using GnuPG with Mozilla - http://enigmail.mozdev.org

iD8DBQFKS3PMA+REPKWGI0ERAlDvAKDJOrtidQUUj/4ulGLDMVNCZrokUQCgzgH+
c4MvB6IhxZV/GBw4ck4x4Yc=
=CHuK
-----END PGP SIGNATURE-----