Re: Error while writing data

From: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>
To: Gaurav Anand <gaurav(dot)anand(at)saama(dot)com>
Cc: pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: Error while writing data
Date: 2022-10-21 12:19:11
Message-ID: CAKFQuwZpt_WRnVoSa=OkmqTRzY3u5-6qUaPtaA7g2_ch3twOiQ@mail.gmail.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

On Fri, Oct 21, 2022 at 5:07 AM Gaurav Anand <gaurav(dot)anand(at)saama(dot)com> wrote:

> Hi Team,
>
> Can you help me with this error
>
> ERROR: invalid byte sequence for encoding "UTF8": 0x00 Call
> getNextException to see other errors in the batch.
>

PostgreSQL does not permit storing the NUL character in a text data type
field.

David J.

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message jian he 2022-10-21 14:42:27 Re: Error while writing data
Previous Message Gaurav Anand 2022-10-21 12:07:38 Error while writing data