Обсуждение: BUG #7726: Can't paste sqls size>4096 to psql console.

The following bug has been logged on the website:

Bug reference:      7726
Logged by:          Xie Jilei
Email address:      xjl@99jsj.com
PostgreSQL version: 9.1.0
Operating system:   Debian/testing
Description:        =


1. Copy 4095 chars of sql statements to clipboard.
2. Open psql in gnome-terminal, and paste the script from the clipboard
3. No problem.

4. Copy 5005 chars of sql statements to clipboard
5. Paste to psql.
6. Only appx 4096 chars are pasted, but it's not the head part. Something
just wrong. Some statements are broken.

Le lundi 3 décembre 2012 08:17:28, xjl@99jsj.com a écrit :
> The following bug has been logged on the website:
>
> Bug reference:      7726
> Logged by:          Xie Jilei
> Email address:      xjl@99jsj.com
> PostgreSQL version: 9.1.0
> Operating system:   Debian/testing
> Description:
>
> 1. Copy 4095 chars of sql statements to clipboard.
> 2. Open psql in gnome-terminal, and paste the script from the clipboard
> 3. No problem.
>
> 4. Copy 5005 chars of sql statements to clipboard
> 5. Paste to psql.
> 6. Only appx 4096 chars are pasted, but it's not the head part. Something
> just wrong. Some statements are broken.

Are you able to reproduce with another terminal, like 'konsole' ?

--
Cédric Villemain +33 (0)6 20 30 22 52
http://2ndQuadrant.fr/
PostgreSQL: Support 24x7 - Développement, Expertise et Formation

xjl@99jsj.com writes:
> 1. Copy 4095 chars of sql statements to clipboard.
> 2. Open psql in gnome-terminal, and paste the script from the clipboard
> 3. No problem.

> 4. Copy 5005 chars of sql statements to clipboard
> 5. Paste to psql.
> 6. Only appx 4096 chars are pasted, but it's not the head part. Something
> just wrong. Some statements are broken.

This is going to be the fault of your terminal program, not psql.
psql doesn't even know that you're pasting something rather than just
typing it manually.

            regards, tom lane