From: | Martijn van Oosterhout <kleptog(at)svana(dot)org> |
---|---|
To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
Cc: | Cliff Nieuwenhuis <cliff(at)nieusite(dot)com>, pgsql-novice(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org |
Subject: | Re: [NOVICE] encoding problems |
Date: | 2008-03-12 08:16:27 |
Message-ID: | 20080312081627.GB28311@svana.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers pgsql-novice pgsql-patches |
On Tue, Mar 11, 2008 at 12:41:35PM -0400, Tom Lane wrote:
> > If I create the same function on my computer running PostgreSQL 8.3.0 and try
> > the \df+ then the Source Code shows:
>
> > \x09DECLARE
> > \x09\x09result text;
> > ...
>
> That's not an encoding problem, that's an intentional behavioral change
> in the way that psql formats strings for display.
>
> I guess it's a bit annoying if you were hoping that tabs would be useful
> for pretty-printing purposes. Should we reconsider what's done with a
> tab in mbprint.c?
At the time that patch was introduced there was discussion about this.
The problem being that psql has no idea what will actually happen to
the cursor when it emits a tab. You can guess but in the end we decided
it was more important to have the display not messed up than displaying
tabs as is.
The other alternative is to convert tabs to spaces on output. Can't
remember why we didn't do that.
Have a nice day,
--
Martijn van Oosterhout <kleptog(at)svana(dot)org> http://svana.org/kleptog/
> Please line up in a tree and maintain the heap invariant while
> boarding. Thank you for flying nlogn airlines.
From | Date | Subject | |
---|---|---|---|
Next Message | Magnus Hagander | 2008-03-12 08:22:28 | Re: Re: [COMMITTERS] pgsql: Add: > o Add SQLSTATE severit yto PGconn return status > > |
Previous Message | Magnus Hagander | 2008-03-12 08:15:06 | Re: [ADMIN] 8.2.4 patches? (fwd) |
From | Date | Subject | |
---|---|---|---|
Next Message | Cliff Nieuwenhuis | 2008-03-12 14:21:27 | Re: [HACKERS] encoding problems |
Previous Message | Cliff Nieuwenhuis | 2008-03-11 19:07:40 | Re: encoding problems |
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 2008-03-12 13:11:48 | Re: BUG #3681: fillers are NULL in pgbench |
Previous Message | Tom Lane | 2008-03-12 05:16:32 | Re: bug in numeric_power() function |