Обсуждение: Copying / inserting new row in edit grid fails

Hi developers! Hi Dave!

Testing the new snapshot: pgAdmin III 1.7.0 (Jun 22 2007, rev:
6379:6385). Client Win XP, host: Debian Sarge / PG 8.1.8

I have noticed a shortcoming in the edit grid. When I copy a row and
insert it as new, the algorithm bails on the first '\n' in a text-field.
The rest of the data is not inserted.
I guess you have to escape line breaks.
BTW, I enter these line breaks by pressing <shift><enter> in Windows.


Regards
Erwin

Erwin Brandstetter wrote:
> Hi developers! Hi Dave!
>
> Testing the new snapshot: pgAdmin III 1.7.0 (Jun 22 2007, rev:
> 6379:6385). Client Win XP, host: Debian Sarge / PG 8.1.8
>
> I have noticed a shortcoming in the edit grid. When I copy a row and
> insert it as new, the algorithm bails on the first '\n' in a text-field.
> The rest of the data is not inserted.
> I guess you have to escape line breaks.
> BTW, I enter these line breaks by pressing <shift><enter> in Windows.

Hi Erwin,

Copying strings with \n's requires Result Copy Quoting to be enabled. If
there are no quotes around the strings, we have no way to tell where the
end is (remember, you can copy multiple rows as well).

Regards, Dave

Hi Dave!

dpage@postgresql.org wrote:
> Erwin Brandstetter wrote:
>
>> Hi developers! Hi Dave!
>>
>> Testing the new snapshot: pgAdmin III 1.7.0 (Jun 22 2007, rev:
>> 6379:6385). Client Win XP, host: Debian Sarge / PG 8.1.8
>>
>> I have noticed a shortcoming in the edit grid. When I copy a row and
>> insert it as new, the algorithm bails on the first '\n' in a text-field.
>> The rest of the data is not inserted.
>> I guess you have to escape line breaks.
>> BTW, I enter these line breaks by pressing <shift><enter> in Windows.
>>
>
> Hi Erwin,
>
> Copying strings with \n's requires Result Copy Quoting to be enabled. If
> there are no quotes around the strings, we have no way to tell where the
> end is (remember, you can copy multiple rows as well).
>

Yeah, I can confirm that it works alright with Result Copy Quoting
enabled. I could have thought of this myself, actually.
It might be a bit tricky for the run-of-the-mill user, though, to
realize the consequences of this setting.

Would it be helpful to amend the help-text? Like this ..

    * *Result copy quoting* - This option specifies how the fields
      should be quoted when copied to the clipboard from the result
      list. Quoting can be applied to string columns only (i.e. numeric
      columns will not be quoted) or all columns regardless of data type.
      Disabling this option may prevent copying and pasting rows in the
      edit grid from functioning properly if special characters like
      line breaks are involved.


Regards
Erwin

On Thu, July 5, 2007 5:28 pm, Erwin Brandstetter wrote:

> Would it be helpful to amend the help-text? Like this ..
>
>     * *Result copy quoting* - This option specifies how the fields
>       should be quoted when copied to the clipboard from the result
>       list. Quoting can be applied to string columns only (i.e. numeric
>       columns will not be quoted) or all columns regardless of data type.
>       Disabling this option may prevent copying and pasting rows in the
>       edit grid from functioning properly if special characters like
>       line breaks are involved.

Yep, done - thanks (as always!).

Regards, Dave