[Bucardo-general] Bucardo error

[Danil Rakevich]

I have tried this:

RETURN 'Tables processed: ' || total::text;

it works.

Thank you for your response.

P.s.: In my environment "SELECT version();" returns:

"PostgreSQL 9.4.8 on x86_64-unknown-linux-gnu, compiled by gcc (Debian 
4.9.2-10) 4.9.2, 64-bit"


On 09/22/2016 05:26 PM, Greg Sabino Mullane wrote:
>> RETURN 'Tables processed: ' ||
>> to_char(total,'99999999999999999999999999999999999999');
> ...
>> DBD::Pg::st pg_result failed: ERROR:  operator is not unique: unknown ||
>> integer
> I think this might be solved easier with a force-cast to text like so:
>
> RETURN 'Tables processed: '::text || total;
>
> Could you see if that is a valid solution for your version of Postgres?
>

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160922/3e21497f/attachment.html>