Skip site navigation (1) Skip section navigation (2)

Re: [NOVICE] encoding problems

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Cliff Nieuwenhuis <cliff(at)nieusite(dot)com>
Cc: pgsql-novice(at)postgresql(dot)org, pgsql-hackers(at)postgresql(dot)org
Subject: Re: [NOVICE] encoding problems
Date: 2008-03-11 16:41:35
Message-ID: 23804.1205253695@sss.pgh.pa.us (view raw or flat)
Thread:
Lists: pgsql-hackerspgsql-novicepgsql-patches
Cliff Nieuwenhuis <cliff(at)nieusite(dot)com> writes:
> I'm not sure how to ask this question.  I have written a function, and with 
> PostgreSQL 8.0.13 I can do a "\df+" and see something like this under Source 
> Code:
> 	DECLARE
> 		result text;	
> ...

> 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?

			regards, tom lane

In response to

Responses

pgsql-novice by date

Next:From: JoshuaDate: 2008-03-11 17:25:54
Subject: simple question concerning plpgsql and SQL Functions
Previous:From: Cliff NieuwenhuisDate: 2008-03-11 15:10:15
Subject: encoding problems

pgsql-hackers by date

Next:From: Bruce MomjianDate: 2008-03-11 17:03:19
Subject: Re: Autovacuum vs statement_timeout
Previous:From: Zdenek KotalaDate: 2008-03-11 16:41:07
Subject: Re: [PATCHES] Fix for large file support (nonsegment mode support)

pgsql-patches by date

Next:From: Zdenek KotalaDate: 2008-03-11 17:07:21
Subject: Re: Remove FATAL from pg_lzdecompress
Previous:From: Zdenek KotalaDate: 2008-03-11 16:41:07
Subject: Re: [PATCHES] Fix for large file support (nonsegment mode support)

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group