[Bucardo-general] Bucardo error

Greg Sabino Mullane greg at endpoint.com
Thu Sep 22 14:26:07 UTC 2016


> 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?

-- 
Greg Sabino Mullane greg at endpoint.com
End Point Corporation
PGP Key: 2529 DF6A B8F7 9407 E944  45B4 BC9B 9067 1496 4AC8

-------------- next part --------------
A non-text attachment was scrubbed...
Name: signature.asc
Type: application/pgp-signature
Size: 163 bytes
Desc: not available
URL: <https://mail.endcrypt.com/pipermail/bucardo-general/attachments/20160922/d0812838/attachment.sig>


More information about the Bucardo-general mailing list