From: Alexandr S <sasha@in.crimea.ua>
To: Andreas Pflug <pgadmin@pse-consulting.de>
Cc: pgadmin-support@postgresql.org
Subject: Re: bug reporting
Date: Tue, 14 Oct 2003 09:40:50 +0400
Message-ID: <3F8B8C62.7080503@in.crimea.ua> (raw)
In-Reply-To: <3F8A7ACC.30601@pse-consulting.de>
References: <3F7D8B18.3060108@in.crimea.ua>
<3F7E046B.9060003@pse-consulting.de>
<3F8659C7.801@in.crimea.ua>
<3F86DBF1.2030508@pse-consulting.de>
<3F8A6172.3020605@in.crimea.ua>
<3F8A7ACC.30601@pse-consulting.de>
Andreas Pflug wrote:
> Then I have to open pgadmin again. Fortunately data didn t lose. Then
> I open Query Tool and type: "SELECT * from mytable;" . Result of
> the query is right. Then I try to export data but I cann t do that
> because pgadmin suddenly shut down without saving any data.
>
>> text_s is attached to this letter.
>
>
> What format is this? I can't display it with any tool correctly.
> Please use Notepad and Save-As some Unicode format.
>
Hi
----It can be usually opened with Opera or Mozilla Firebird having set
before Character Coding to windows-1251. May be fonts don t support
russian language. Any way with text_s_unicode in unicode there is the
same problem: I can t export such data from Query Window ( Pgadmin 3.1)
to file.
>
>
>>
>>>> --when inserting large block of text , data often aligns along one
>>>> long line, so its hard to view such data. It would be better if
>>>> data take the form of sell like , for example, Pgaccess does.
>>>
>>>
>>>
>>>
>>>
>>> Don't know how you'd like it. Some kind of autowrap? You could split
>>> lines:
>>>
>>> INSERT INTO mytable(foo, bar) VALUES (1, 'this is my line ||
>>> ' and this too'
>>>
>>>
>>> Regards,
>>> Andreas
>>>
>> ---Yes, some kind of autowrap. Of course I can mannually split line
>> , but users here usually do such way: ctrl-c from MS Word and ctrl-v
>> into pgadmin, so data often align along one long line.
>
>
> ?????? Inserting data from Word ?????
> pgAdmin3 is no text editing tool, and we won't try to interpret the
> data. I don't know how you're trying to use pgAdmin3, but it may be
> out of the scope of this tool (notice the name, it's about
> ADMINistration, not for extensively editing data).
>
----Why not? Let it be. What another tool should I use to insert data to
postgresql? Pgadmin already can be excellently used for such operations.
Not editing , but just coping from notepad to Pgadmin. Else I have to
create my own program using PHP , etc ...
Attachments:text_s_unicode.txt (text/plain, 7.0K) download
ÿþ !!/- !- !(: ',. ,# + # +? AB>@8O >1@5B5=8O =57028A8<>AB8 =0H8< 3>AC40@AB2>< 405B 1>30B59H89 <0B5@80; 4;O >?@545;5=8O 40;L=59H59 ?>;8B8G5A:>9 AB@0B5388 #:@08=K. 5 A5:@5B, GB> 2> 2B>@>9 ?>;>28=5 X V I I 2. C:@08=A:85 B5@@8B>@88 AB0;8 0@5=>9 :@>2>?@>;8B=KE 2>9= <564C 0?04>< 8 >AB>:><, ?@5A;54>202H8E F5;L 70E20B0 F5=B@0 2@>?K. ?@8G8=>9 B><C 2 =5<0;>9 AB5?5=8 ?>A;C68;8 @07=>3;0A8O 2 AB0=5 C:@08=A:>9 AB0@H8=K 8 =5>?@545;5==>ABL 2=5H=5?>;8B8G5A:>3> :C@A0. >4>1=0O A8BC0F8O, ?> <>5<C <=5=8N, A:;04K205BAO 8 =0 A>2@5<5==>< MB0?5. >AB>O==>5 CG0AB85 #:@08=K 2 :>=:C@5=F88 >AB>:0 8 0?040 AD>@<8@>20;> 4;O =0H53> 3>AC40@AB20 AB0BCA « 1CD5@=>97>=K» =59B@0;L=>3> ?@>AB@0=AB20, =5 O2;ONI53>AO A0<>AB>OB5;L=K<. BAN40 8 >BACBAB285 >A=>2>?>;030NI53> D0:B>@0 2 >?@545;5=88 3>AC40@AB25==>9 ?>;8B8:8. 0 <>9 273;O4, 8<5==> MB8< >1JOA=O5BAO AB@5<;5=85 #:@08=K AD>@<8@>20BL AB@0B538G5A:>5 ?0@B=5@AB2> A 1 9 45@6020<8 <8@0. A>1K5 2708<>>B=>H5=8O A B0:8< :>;8G5AB2>< 3>AC40@AB2 A2845B5;LAB2CNB >1 >BACBAB288 :>=F5?BC0;L=>3> ?>4E>40 2 D>@<8@>20=88 3>AC40@AB25==KE ?@8>@8B5B>2. >?KB05<AO 2KO28BL =081>;55 CAB>9G82K5 25:B>@K @0728B8O >B=>H5=89 #:@08=K A <8@>2K< A>>1I5AB2><, 5@2K9 25:B>@. 2@>?59A:89 !>N7 AB@5<8BAO 45@60BL #:@08=C 2 8;;N788 8=B53@0F88, ?>445@6820O 52@>?59A:89 2K1>@ =0H53> 3>AC40@AB20. 4=>2@5<5==> ! 0:B82=> ?@>428305B A2>8 M:>=><8G5A:85 8=B5@5AK =0 C:@08=A:>< @K=:5, ?@8=8<0O CG0AB85 2 ?@820B870F88 C:@08=A:8E ?@54?@8OB89, 8A?>;L7CO 55 B@0=A?>@B=K5 2>7<>6=>AB8. @8 MB>< ! B>@<>78B 2ABC?;5=85 #:@08=K 2> A5<8@=CN B>@3>2CN >@30=870F8N. :0:8E- B> 4@C38E ?@54;>65=89 A> AB>@>=K !, :@><5 AB0BCA0 « AB@0=K- A>A54:8» , ?>:0 >6840BL =5 ?@8E>48BAO. B>@>9 25:B>@. !>548=5==K5 (B0BK 8<5NB 8=CN ?>78F8N. @8 ?><>I8 <8@>2KE ! <5@8:0 A>7405B >1@07 #:@08=K :0: 3>AC40@AB20, :>B>@><C >G5=L 40;5:> 4> 2ABC?;5=8O 2 !, @5F545=BK A ?@8<5=5=85< A0=:F89 F A T F , @074CBK9 A:0=40; A « :>;LGC30<8» =0=5A;8 A5@L57=K9 C40@ ?> 8<846C #:@08=K :0: ?>B5=F80;L=> A8;L=>3> 52@>?59A:>3> 3>AC40@AB20. !;54>20B5;L=>, #:@08=0 2K=C645=0 AG8B0BLAO A !( :0: A « M:A?5@B>< ?> ?>AB@>5=8N 45<>:@0B8G5A:>3> >1I5AB20» . "@5B89 25:B>@. >AA8O >AB05BAO =081>;55 AB018;L=K< A53<5=B>< @5H5=8O M:>=><8G5A:8E ?@>1;5< #:@08=A:>3> 3>AC40@AB20. >A:>;L:C 2@>?0 =5 ?CA:05B C:@08=A:85 B>20@K =0 A2>9 @K=>:, #:@08=0 >1O70=0 ?@>42830BL 8E =0 @K=>: @>AA89A:89, 2KABC?0BL 70 A>740=85 7>=K A2>1>4=>9 B>@3>2;8 ( !") , @><5 B>3>, ?@8 2>7=8:=>25=88 ;N1>3> ?>;8B8G5A:>3> :@878A0 C:@08=A:85 ?>;8B8:8 =0G8=0NB 8A:0BL ?>445@6:C 2 >A:25. #:@08=A:89 ?@57845=B 2 :>=F5 O=20@O 2 0 0 3 3>40 AB0; ?@54A540B5;5< !>25B0 3;02 3>AC40@AB2 ! . C<05BAO, MB> @0F8>=0;L=K9 H03, ?>72>;ONI89 >BAB0820BL =0F8>=0;L=K5 8=B5@5AK. 52>;L=> =0?@0H8205BAO 2K2>4 > B><, GB> 2> 2@5<O ?>;8B8G5A:>9 AB018;L=>AB8 #:@08=0 >@85=B8@C5BAO =0 ! 8 !(, 0 2 :@878A=KE A8BC0F8OE =0 >AA8N. >AA8O, :>=5G=>, AB@5<8BAO 8A?>;L7>20BL ?>4>1 =CN 381:>ABL 4;O @5H5=8O A>1 AB25==KE ?@>1;5<. >4>1=0O ?>;8B8:0, ?> <>5<C <=5=8N, ?@82>48;0 : 35>AB@0B538G5A:> <C ?@>83@KHC #:@08=K 8 45 7>@85=B0F88 >1I5AB20. 5@> OB=>, #:@08=0 ?>4>H;0 : B>9 G5@B5, :>340 =5>1E>48<> G5B :> >?@545;8BL A2>N AB@0B538N 8 B0:B8:C. ;02=>5 2 40==>9 A8BC0F88 <0:A8<0;L=> CG8 BK20BL C:@08=A:85 =0F8> =0;L=K5 8=B5@5AK. !, 8 >A A8O, 8 !( 64CB >B #:@08=K @5H8B5;L=KE 459AB289. @578 45=B #:@08=K A45;0; ?5@2K9 H03 2 MB>< =0?@02;5=88, G5B:> >1>7=0G82 2 A2>5< >A;0=88 :C@A =0 2E>645=85 2 548=CN 2@>?C: « ABL 0:A8><0 52 @>?59A:89 ?CBL @0728B8O, 4>A B865=85 52@>?59A:8E AB0=40@B>2» . >A;54CNB ;8 70 MB8< 4@C 385 H038? . % + , :0=4840B 8AB>@8G5A:8E =0C:. 3. !8<D5@>?>;L.
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-bugs@postgresql.org
Cc: sasha@in.crimea.ua, pgadmin@pse-consulting.de, pgadmin-support@postgresql.org
Subject: Re: bug reporting
In-Reply-To: <3F8B8C62.7080503@in.crimea.ua>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox