Re: troubles with postgresql 7.0.2 - Mailing list pgsql-general

From Diana Cionoiu
Subject Re: troubles with postgresql 7.0.2
Date
Msg-id Pine.LNX.4.30.0105031259010.743-100000@tudor.softwaresolutions.ro
Whole thread Raw
In response to Re: troubles with postgresql 7.0.2  (Tom Lane <tgl@sss.pgh.pa.us>)
List 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 by date:

Previous
From: Lamar Owen
Date:
Subject: Re: Ideal hardware configuration for pgsql
Next
From: "Albertson, Chris"
Date:
Subject: RE: Database in RAM