From: Andreas Pflug <pgadmin@pse-consulting.de>
To: Alexandr S <sasha@in.crimea.ua>
Cc: pgadmin-support@postgresql.org
Subject: Re: [BUGS] bug reporting
Date: Fri, 10 Oct 2003 18:18:57 +0200
Message-ID: <3F86DBF1.2030508@pse-consulting.de> (raw)
In-Reply-To: <3F8659C7.801@in.crimea.ua>
References: <3F7D8B18.3060108@in.crimea.ua>
<3F7E046B.9060003@pse-consulting.de>
<3F8659C7.801@in.crimea.ua>
Alexandr S wrote:
> Next bug.
> --with full russian version of Pgadmin 3.1 (with russian title of
> column and russian inserted data) : there is problem when selecting,
> inserting relatively large block of data (for example , excerpt of
> some text about 100 words size and more). Pgadmin suddenly ends to
> work and then I have to start pgadmin again, but fortunately data don
> t loose. And pgadmin don t export any russian data to *.csv or
> *.dat - pgadmin suddenly ends to work without saving any data. As I
> understood, there is patch that solve this problems, so I hope new
> version of pgadmin will appear as soon as possible.
Hi Alexandr,
There's no patch pending, how did you try to insert the data? Can you
supply samples of data, so we can see what's going wrong?
>
> --with full english version of Pgadmin : this problems absent , but
> there is one thing that I don t understand and don t like me. When
> exporting relatively large block of data (text with, for example, 100
> words size) pgadmin saves to *.csv only little part of data in the
> end of which follows ".." . So pgadmin don t safe full content of
> row. Is it right behavior? How can I safe full content of a row?
The column size of the Query Tool is limited, you can change the setting
in options. Anyhow, if the data is larger than 511, windows will
truncate it.
The next version of pgAdmin3 will include a "execute to file", which
won't suffer any truncation (until the disk is full :-)
>
> --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
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: pgadmin@pse-consulting.de, sasha@in.crimea.ua, pgadmin-support@postgresql.org
Subject: Re: [BUGS] bug reporting
In-Reply-To: <3F86DBF1.2030508@pse-consulting.de>
* 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