Re: troubles with postgresql 7.0.2

> 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