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

Поиск
Список
Период
Сортировка
От James Robinson
Тема 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...
Дата
Msg-id A15E86F8-AF62-4A04-BC0D-5E9F97F9FD45@socialserve.com
обсуждение исходный текст
Ответы Re: 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...  (Martijn van Oosterhout <kleptog@svana.org>)
Список 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


В списке pgsql-general по дате отправления:

Предыдущее
От: "Tarabas (Manuel Rorarius)"
Дата:
Сообщение: PG 8.2.0 - TSearch2 "Wrong affix file format"
Следующее
От: Martijn van Oosterhout
Дата:
Сообщение: Re: 8.2.0 psql \df+ output mangled a bit relative to 8.1.4 ...