Re: [GENERAL] ERROR: type " " does not exist

Поиск
Список
Период
Сортировка
От Alexander Farber
Тема Re: [GENERAL] ERROR: type " " does not exist
Дата
Msg-id CAADeyWiRqpYqZn1cushfefs9rQahUbqHKNbffU44o5=egLDf2Q@mail.gmail.com
обсуждение исходный текст
Ответ на Re: [GENERAL] ERROR: type " " does not exist  (Adrian Klaver <adrian.klaver@aklaver.com>)
Список pgsql-general
Дерево обсуждения
Good evening everyone,

I apologize for the delay in replying and that you had to "reverse engineer" my question.

This turned out indeed to be a special char problem.

On MBA with macOS Sierra 10.12.5 I am using Postgres 9.5.4.1 of postgresapp.com.

At the psql prompt I had copy-pasted:

words=> SELECT 1, 'You have resigned ' || 1 || ':' || 1;
ERROR:  type " " does not exist
LINE 1: SELECT 1, 'You have resigned ' || 1 || ':' || 1;
                                              ^
After I removed the "white space" char before ':', everything worked.

In vi (after \e) I could see that special char by typing %!xxd

00000000: 5345 4c45 4354 2031 2c20 2759 6f75 2068  SELECT 1, 'You h
00000010: 6176 6520 7265 7369 676e 6564 2027 207c  ave resigned ' |
00000020: 7c20 3120 7c7c c2a0 273a 2720 7c7c 2031  | 1 ||..':' || 1
00000030: 3b0a                                     ;.

Thank you.

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

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: [GENERAL] pg_upgrade --link on Windows
Следующее
От: Martin Goodson
Дата:
Сообщение: [GENERAL] Repmgr + pgbouncer - Notification of master promotion to applicationlevel ...