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

Re: pasting into psql garbles text

From: Роман Маширов <mrj(at)nandu(dot)ru>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: Merlin Moncure <mmoncure(at)gmail(dot)com>, Greg Stark <gsstark(at)mit(dot)edu>, PostgreSQL General <pgsql-general(at)postgresql(dot)org>
Subject: Re: pasting into psql garbles text
Date: 2009-06-29 08:49:22
Message-ID: 4A488012.7040008@nandu.ru (view raw or flat)
Thread:
Lists: pgsql-general
<!DOCTYPE html PUBLIC "-//W3C//DTD HTML 4.01 Transitional//EN">
<html>
<head>
  <meta content="text/html;charset=UTF-8" http-equiv="Content-Type">
</head>
<body bgcolor="#ffffff" text="#000000">
In my case (FreeBSD 6 and 7) psql does not freezes, but for some reason
part of pasted code get corrupted when size of the code relatively big.
It seems like some timeout used, or buffer overflows:<br>
<br>
1. locally with xterm for the first time pasting function of 9K:<br>
base=&gt; create or replace function football_recalc_match_stat(bigint)
returns void as $$<br>
    declare <br>
<br>
&lt; here i see rows 1-52 of function without 'base$&gt;' prefix &gt;<br>
<br>
                where football_match = match and match_event_type in
(3, 12)base$&gt;     declare <br>
base$&gt;         match alias for $1;<br>
<br>
&lt; here i see rows 1-117 of function with 'base$&gt;' prefix &gt;<br>
&lt; here i see rows 166-till the end of the func with 'base$&gt;'
prefix&gt;<br>
<br>
and got error in function body at the row 118.<br>
<br>
<br>
2-10 locally and via ssh to localhost with xterm -- no problem.<br>
<br>
<br>
11 - to remote host via ssh with xterm<br>
base=&gt; create or replace function football_recalc_match_stat(bigint)
returns void as $$<br>
    declare <br>
<br>
&lt; here i see rows 1-52 of function without 'base$&gt;' prefix &gt;<br>
<br>
                where football_match = match and match_event_type in
(3, 12)sovsport$&gt;     declare <br>
base$&gt;         match alias for $1;<br>
<br>
&lt; here i see rows 1-23 of function with 'base$&gt;' prefix, last row
truncated &gt;<br>
base$&gt;<br>
and that's all<br>
<br>
<br>
11 stable reproduced for several times with problems on the same rows.<br>
<br>
uname -a<br>
FreeBSD  6.3-RELEASE-p2 FreeBSD 6.3-RELEASE-p2 #0: Wed Sep  3 09:41:48
MSD 2008 i386<br>
<br>
set | grep LANG<br>
LANG=ru_RU.UTF-8<br>
<br>
pkg_info -r postgresql-client-8.2.7<br>
Information for postgresql-client-8.2.7:<br>
<br>
Depends on:<br>
Dependency: libiconv-1.11_1<br>
Dependency: gettext-0.16.1_3<br>
<br>
<br>
Tom Lane wrote:
<blockquote cite="mid:19349(dot)1246137153(at)sss(dot)pgh(dot)pa(dot)us" type="cite">
  <pre wrap="">Merlin Moncure <a class="moz-txt-link-rfc2396E" href="mailto:mmoncure(at)gmail(dot)com">&lt;mmoncure(at)gmail(dot)com&gt;</a> writes:
  </pre>
  <blockquote type="cite">
    <pre wrap="">I'm starting to feel like my problems start appearing at a very fixed
size (like you, a few hundred or so).   Do you see this in other
programs (bash, vim, etc)? or only psql?
    </pre>
  </blockquote>
  <pre wrap=""><!---->
I've only noticed it in psql, but there are not that many other programs
that I tend to paste lots of input into.

(experiments...)  Hmm, and another interesting thing is that it only
seems to happen on my HPUX system, which is (intentionally) running a
pretty ancient version of readline ... 4.2a looks like.  My Fedora 10
box with readline 5.2 eats the same amount of pasted text without
indigestion.  What readline version are you using?

			regards, tom lane

  </pre>
</blockquote>
<br>
</body>
</html>


Attachment: unknown_filename
Description: text/html (3.1 KB)

In response to

pgsql-general by date

Next:From: Albe LaurenzDate: 2009-06-29 08:49:33
Subject: Unexpected behaviour of date_part
Previous:From: Sim ZacksDate: 2009-06-29 06:02:30
Subject: Re: Free OLAP software for Postgres databas

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