Re: insert data with invalid input syntax for integer:"42P01"

From: Scott Ribe <scott_ribe(at)elevated-dev(dot)com>
To: Pepe TD Vo <pepevo(at)yahoo(dot)com>
Cc: "David G(dot) Johnston" <david(dot)g(dot)johnston(at)gmail(dot)com>, Pgsql-admin <pgsql-admin(at)lists(dot)postgresql(dot)org>
Subject: Re: insert data with invalid input syntax for integer:"42P01"
Date: 2019-02-11 21:08:59
Message-ID: 50A3423C-3BCB-493B-9168-7339BBF5305E@elevated-dev.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-admin

> On Feb 11, 2019, at 2:02 PM, Pepe TD Vo <pepevo(at)yahoo(dot)com> wrote:
>
> for the 'E, I did learn it encode binary data into a textual representation and converts zero bytes and high bit set bytes to octal and doubles backslashes.

Once again, why are you removing it? What do you think happens to octal sequences and doubled backslashes when you do that???

In response to

Browse pgsql-admin by date

  From Date Subject
Next Message David G. Johnston 2019-02-11 21:28:29 Re: insert data with invalid input syntax for integer:"42P01"
Previous Message Pepe TD Vo 2019-02-11 21:02:13 Re: insert data with invalid input syntax for integer:"42P01"