Re: psql and bytea

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: psql and bytea
Дата
Msg-id 8509.1053010073@sss.pgh.pa.us
обсуждение исходный текст
Ответ на Re: psql and bytea  (Féliciano Matias <feliciano.matias@free.fr>)
Ответы Re: psql and bytea  (Féliciano Matias <feliciano.matias@free.fr>)
Список pgsql-general
=?ISO-8859-1?Q?F=E9liciano?= Matias <feliciano.matias@free.fr> writes:
> one=3D> -- this is not the original size (20M : 20971520).
> I don't have any problems with smaller files (10Mo is always fine).
> All of this is used with postgresql 7.3.2 shipped with Red Hat Linux 9 .

Hmm.  There used to be some off-by-one type bugs in psql's
variable-substitution code, but those were fixed long before 7.3.2.
In any case, it's hard to see why such a problem would only arise
when you got past 10Mb string lengths.

I couldn't duplicate the problem here, so I'm going to suggest that
maybe you have a hardware problem?  Perhaps there's a flaky RAM chip in
an area of memory that doesn't get used until you push up the size
of psql quite a bit.  It'd be worth running memtest86 for awhile to
check.

            regards, tom lane

В списке pgsql-general по дате отправления:

Предыдущее
От: "Henrik Steffen"
Дата:
Сообщение: Re: sub-select
Следующее
От: "Johnson, Shaunn"
Дата:
Сообщение: sql and timestamp variable