problem with pgadmin query tool EOL sequences

Поиск
Список
Период
Сортировка
От rdelong
Тема problem with pgadmin query tool EOL sequences
Дата
Msg-id 000001c73380$94240ed0$0201a8c0@CREAMERS
обсуждение исходный текст
Список pgadmin-support
Hi,

I'm using pgadmin 1.6 on win2k and xp.  Is there any way to control the EOL
sequences sent by the query tool?
I'd like to configure the tool to use \n as the EOL character instead of
\r\n.

If I define multi-line pl/r functions using the pgadmin
III query tool (either v 1.2 or 1.6), then calling those functions causes a
server disconnect (whether they are called via a query through pgadmin III
or inside psql).

If I define an identical function using psql on the console, then it works
fine.

If I do a select prosrc from pg_catalog.pg_proc for "identical"
functions where one was defined in psql and the other in pgadmin III, I see
the following:

Function defined using psql (this version works):
prosrc
----------------
x<-rnorm(100);
as.vector(x);

Function defined usgin pgadmin III (this version causes a database
disconnect);
prosrc
----------------
x<-rnorm(100);\r
as.vector(x);\r


Thanks, Rob.



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

Предыдущее
От: "Milen A. Radev"
Дата:
Сообщение: SQL Window's Title
Следующее
От: Erwin Brandstetter
Дата:
Сообщение: v.1.6.2: issue with truncated column comments.