Re: Input data for column is not compatible with data type

From: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
To: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>, Postgres General <pgsql-general(at)postgresql(dot)org>
Subject: Re: Input data for column is not compatible with data type
Date: 2016-02-10 21:26:56
Message-ID: 56BBAB20.7070107@aklaver.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On 02/10/2016 11:56 AM, drum(dot)lucas(at)gmail(dot)com wrote:
> Hi all
>
> I'm having this error message:
>
> Input data for column `%1$s` is not compatible with data type

The above, from looking at the link below, looks like part of the query.

If that is so I am guessing the back ticks are causing the problem.

If not what is the actual error message and what is creating it?

>
>
> But I was unable to find the table which is having this issue....
>
> Would be possible someone help me with that?
> Thanks
>
> Complete error link:
> https://bitbucket.org/snippets/lucaspossamai/7r9yX
>
> Query link:
> https://bitbucket.org/snippets/lucaspossamai/rbpk4/edit/

--
Adrian Klaver
adrian(dot)klaver(at)aklaver(dot)com

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Adrian Klaver 2016-02-10 21:27:39 Re: Input data for column is not compatible with data type
Previous Message Andy Colson 2016-02-10 20:56:37 Re: Test CMake build