| From: | Matthias Apitz <guru(at)unixarea(dot)de> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)lists(dot)postgresql(dot)org |
| Subject: | Re: DBD::Pg exorts char columns with trailing blanks |
| Date: | 2019-10-18 14:42:26 |
| Message-ID: | 20191018144226.GA2930@c720-r342378 |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
El día viernes, octubre 18, 2019 a las 03:01:58p. m. +0200, Tom Lane escribió:
> Matthias Apitz <guru(at)unixarea(dot)de> writes:
> > When we export char columns with our Perl tools, they come out with trailing blanks (in Sybase they don't). Can this be suppressed?
>
> Switch to varchar, perhaps?
>
> regards, tom lane
Sometimes people does not know, what they propose. We have a historical
25 years grown ILS which runs on top of Sybase, Oracle, Informix ... and
should now be ported to PostgreSQL. We can't simple switch internal
table structures and adopt some 10.000.000 lines of code (or debug while
it is now crashing).
Thanks anyway.
matthias
--
Matthias Apitz, ✉ guru(at)unixarea(dot)de, http://www.unixarea.de/ +49-176-38902045
Public GnuPG key: http://www.unixarea.de/key.pub
3. Oktober! Wir gratulieren! Der Berliner Fernsehturm wird 50
aus: https://www.jungewelt.de/2019/10-02/index.php
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Adrian Klaver | 2019-10-18 14:51:18 | Re: DBD::Pg exorts char columns with trailing blanks |
| Previous Message | Adrian Klaver | 2019-10-18 14:20:12 | Re: connection timeout with psycopg2 |