Re: BUG #10500: Cannot restore from a dump when some function is used in public shcema

Andres Freund a écrit :
> Hi,
>
> On 2014-06-02 16:14:27 +0000, nicolas@cybercat.ca wrote:
>> The pg_restore or psql won't create the index in the last sql, despite the
>> fact that the public schema is specified to reference the function.
> What exactly do you mean with "won't create"? Does it generate an error?
> If so, what's that exactly?

Yes, sorry, here it is :

ERROR:  function unaccent(text) does not exist
LIGNE 1 :  SELECT unaccent(lower($1));
                   ^
ASTUCE : No function matches the given name and argument types. You
might need to add explicit type casts.
REQUÊTE :  SELECT unaccent(lower($1));
CONTEXTE : SQL function "cyunaccent" during inlining

********** Error **********

ERROR: function unaccent(text) does not exist
SQL state: 42883
Hint: No function matches the given name and argument types. You might
need to add explicit type casts.
Context: SQL function "cyunaccent" during inlining