8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...

From: James Robinson <jlrobins(at)socialserve(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...
Date: 2006-12-21 15:25:02
Message-ID: A15E86F8-AF62-4A04-BC0D-5E9F97F9FD45@socialserve.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

With a database loaded into 8.2.0 from a dump from an 8.1.4 server,
"\df+ foo()", where foo()'s body has embedded tabs shows up with
those tabs escaped, whereas under 8.1.4 they were emitted verbatim:

Is there a trick to getting old behaviour back? It seems to happen
regardless of client_encoding setting (either SQL_ASCII or latin1).
Thanks!

8.2.0:
social=# \df+ housing.update_terse_listing_by_unit()

List of functions
Schema | Name | Result data type | Argument
data types | Owner | Language |
Source code | Description
---------+------------------------------+------------------
+---------------------+--------+----------
+-----------------------------------------------------------------------
----------------+-------------
housing | update_terse_listing_by_unit | "trigger"
| | social | plpgsql
|
|

: BEGIN

: \x09if TG_OP = 'UPDATE' then

: \x09\x09update housing.terse_listing
set last_modified = now() where id = NEW.id;

: \x09else

: \x09\x09insert into
housing.terse_listing (id, last_modified) values (NEW.id, now());

: \x09end if;

: \x09return null;

: END;

:
(1 row)

8.1.4:

social=# \df+ housing.update_terse_listing_by_unit()


List of functions
Schema | Name | Result data type | Argument
data types | Owner | Language
|
Source
code
| Description
---------+------------------------------+------------------
+---------------------+--------+----------
+-----------------------------------------------------------------------
------------------------------------------------------------------------
------------------------------------------------------------------------
----------+-------------
housing | update_terse_listing_by_unit | "trigger"
| | social | plpgsql |
BEGIN
if TG_OP = 'UPDATE' then
update housing.terse_listing set last_modified = now
() where id = NEW.id;
else
insert into housing.terse_listing (id,
last_modified) values (NEW.id, now());
end if;
return null;
END;
|

----
James Robinson
Socialserve.com

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Martijn van Oosterhout 2006-12-21 15:31:29 Re: 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...
Previous Message Brandon E Hofmann 2006-12-21 15:19:58 Website Hosting Service and Security