Re: troubles with postgresql 7.0.2

Поиск
Список
Период
Сортировка
От Diana Cionoiu
Тема Re: troubles with postgresql 7.0.2
Дата
Msg-id Pine.LNX.4.30.0105031259010.743-100000@tudor.softwaresolutions.ro
обсуждение исходный текст
Ответ на Re: troubles with postgresql 7.0.2  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-general
> Diana Cionoiu <diana@softwaresolutions.ro> writes:
> >         $mimuv = pg_exec ($conn, "SELECT idl from ldi where categoria=" .
> > $categorie. " and denumirea LIKE '%" . $denumirea . "%' and
> > substr(dataemiterii,1,2) LIKE '%" . $luna ."%' and
> > substr(dataemiterii,3,2) LIKE '%" . $zi . "%' and substr(dataemiterii,5,4)
> > LIKE '%" . $an . "%' and descriere LIKE '%" . $descriere . "%' and
> > organemitent LIKE '%" . chop($organ) . "%' and publicat LIKE '%" .
> > chop($tippub) ."%' and tipdocument LIKE '%" . chop($tipdoc). "%'" );
>
> > second executed after first, give me the error message.
>
> Possibly you are running into the LIKE-at-end-of-memory bug identified
> last July (see rev 1.37 at
> http://www.postgresql.org/cgi/cvsweb.cgi/pgsql/src/backend/utils/adt/like.c).
> Please update to 7.0.3 ... or even better, 7.1, but 7.0.3 wouldn't force
> you into a database dump/reload ... and see if you still see the
> problem.

Thank you very much.
Was the time to use a newer postgresql, i will start to port everything
now on 7.1, witch i have it in tests since 2 weeks ago.

>             regards, tom lane

Diana Cionoiu


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

Предыдущее
От: Lamar Owen
Дата:
Сообщение: Re: Ideal hardware configuration for pgsql
Следующее
От: "Albertson, Chris"
Дата:
Сообщение: RE: Database in RAM