manifoldcf-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Karl Wright <daddy...@gmail.com>
Subject Re: performInsert() postgres json
Date Thu, 02 Jan 2020 13:56:33 GMT
The Basetable abstraction doesn't recognize specialty column types like
JSON; it's got a limited set of types it knows about, and that is by design
so multiple implementations can be written for different databases.

Karl


On Thu, Jan 2, 2020 at 8:49 AM SREEJITH va <va.sreejith@gmail.com> wrote:

> Hi Karl and Team,
>
> I have a situation  where I have to call *performInsert(parameterMap,
> null)*  on a postgres database table with json column. I am getting below
> error during the insert.
>
>
> *column "XXXXX" is of type json but expression is of type character
> varying  Hint: You will need to rewrite or cast the expression.*
>
> Is there any way I can achieve this using Basetable api?
>
>
> --
> Regards
> -Sreejith
>

Mime
View raw message