Re: [NOVICE] Regression test : pg_conversion validation - Mailing list pgsql-novice

From neha khatri
Subject Re: [NOVICE] Regression test : pg_conversion validation
Date
Msg-id CAFO0U+_hXZLwkQ3KxD4hzWP0xx_vpqEBOpZDdvH_S4RiJcr47Q@mail.gmail.com
Whole thread Raw
In response to Re: [NOVICE] Regression test : pg_conversion validation  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [NOVICE] Regression test : pg_conversion validation
List pgsql-novice

 On Mon, Feb 13, 2017 at 6:27 PM, Tom Lane <tgl@sss.pgh.pa.us> wrote:
neha khatri <nehakhatri5@gmail.com> writes:
> It looks like this validation might not reflect the correct behaviour for a
> well defined conproc for certain encodings.
> e.g. Consider LATIN1 as src_encoding and EBCDIC as dst_encoding in the
> above query.

Um ... well, that's already a bridge too far.  Postgres does not support
any encodings that aren't ASCII supersets, and the possibility that we
would do so in future isn't measurably different from zero.  There's too
much code that depends on that assumption, and too little benefit to
getting rid of it.

If you can show a problem case that doesn't involve EBCDIC, then I'm
all ears.


Can't find another encoding, that isn't superset of ASCII.
But how PostgreSQL deals with data movement from EBCDIC machine to
ASCII machine. Would it be the applications responsibility to appropriately 
convert before such transfer happens?

Regards,
Neha 

pgsql-novice by date:

Previous
From: Tom Lane
Date:
Subject: Re: [NOVICE] Regression test : pg_conversion validation
Next
From: Carol Walter
Date:
Subject: Re: [NOVICE] Regression test : pg_conversion validation