Re: troubles with postgresql 7.0.2

Diana Cionoiu <diana(at)softwaresolutions(dot)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.

regards, tom lane