parser error when trying to connect to postges db from tomcat

Grepping through the PostgreSQL source I can't find anything; perhaps
someone on -interfaces has a better idea...

On Wed, Apr 19, 2006 at 03:34:10PM +0000, danish.siddiqui@hovservices.com wrote:

Hi,
Im getting this error when I try to connect to a postgresql database
from a web application running on tomcat....

the error is from the postgersql logs

ERROR: No parser with id 17555

The error below is from tomcat logs:
-------
(executing StatementCallback): encountered
SQLException [ERROR: No parser with id 17555]; nested exception is
org.postgresql.util.PSQLException: ERROR: No parser with id 17555
-------

Please advise...Iv been trying to find an answer for a long time
Thanks

--
Danish Siddiqui

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings

--
Jim C. Nasby, Sr. Engineering Consultant jnasby@pervasive.com
Pervasive Software http://pervasive.com work: 512-231-6117
vcard: http://jim.nasby.net/pervasive.vcf cell: 512-569-9461

On Wed, Apr 19, 2006 at 03:34:10PM +0000, danish.siddiqui@hovservices.com wrote:

Hi,
Im getting this error when I try to connect to a postgresql database
from a web application running on tomcat....

the error is from the postgersql logs

ERROR: No parser with id 17555

Jim C. Nasby wrote:

Grepping through the PostgreSQL source I can't find anything; perhaps
someone on -interfaces has a better idea...

My first guess would be a user-defined function doing
RAISE EXCEPTION 'No parser with ...'

or something similar.

--
Alvaro Herrera http://www.CommandPrompt.com/
PostgreSQL Replication, Consulting, Custom Development, 24x7 support

Alvaro Herrera <alvherre@commandprompt.com> writes:

On Wed, Apr 19, 2006 at 03:34:10PM +0000, danish.siddiqui@hovservices.com wrote:

ERROR: No parser with id 17555

Jim C. Nasby wrote:

Grepping through the PostgreSQL source I can't find anything; perhaps
someone on -interfaces has a better idea...

Not sure what you're grepping, but I see two hits in contrib/tsearch2
...

pgsql/contrib/tsearch2/ts_cfg.c: ts_error(ERROR, "No parser with id %d", id);
pgsql/contrib/tsearch2/wparser.c: ts_error(ERROR, "No parser with id %d", id);

Now, what tsearch2 thinks a "parser" is I have no idea, but it seems
like the OP probably has a misconfigured tsearch2 installation.

regards, tom lane