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

From: "drum(dot)lucas(at)gmail(dot)com" <drum(dot)lucas(at)gmail(dot)com>
To: Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(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:35:21
Message-ID: CAE_gQfVH0vSd0xfRcRr7tKs0_fg_AmQtPogj08dFNjjGahB-Kg@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

yep..

thank you for your replly.

The problem is a code problem. Not in the DB.

Thank you.

Lucas Possamai

- kinghost.co.nz
<http://forum.kinghost.co.nz/memberlist.php?mode=viewprofile&u=2&sid=e999f8370385657a65d41d5ff60b0b38>
- DigitalOcean <https://m.do.co/c/a0d31c597a03>

On 11 February 2016 at 10:27, Adrian Klaver <adrian(dot)klaver(at)aklaver(dot)com>
wrote:

> On 02/10/2016 12:11 PM, David G. Johnston wrote:
>
>> On Wed, Feb 10, 2016 at 12:56 PM, drum(dot)lucas(at)gmail(dot)com
>> <mailto:drum(dot)lucas(at)gmail(dot)com> <drum(dot)lucas(at)gmail(dot)com
>> <mailto: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
>>
>>
>> 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/
>>
>>
>> ​For those who come later please, if at all possible, write
>> self-contained emails.
>>
>
> In that vein the second link is non-functional:(
>
>
>> David J.​
>>
>>
>
> --
> Adrian Klaver
> adrian(dot)klaver(at)aklaver(dot)com
>

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Thomas Munro 2016-02-10 21:41:57 Re: pg_multixact issues
Previous Message Adrian Klaver 2016-02-10 21:27:39 Re: Input data for column is not compatible with data type