error code invalid_input_syntax - Mailing list pgsql-sql

From Rainer Leo
Subject error code invalid_input_syntax
Date
Msg-id loom.20060112T094211-926@post.gmane.org
Whole thread Raw
Responses Re: error code invalid_input_syntax
List pgsql-sql
I wrote a function which generates SQL statements
for INSERTs and UPDATEs, in which I cast the values
to the correct datatype.

Now I want to catch

ERROR:  invalid input syntax for integer: "i"

but although I tried quite a few I can't find the right
error code for this exception.

Is it possible that this error can not be caught?


Thanks
Leo



pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: foreign keys with on delete cascade and triggers
Next
From: Dirk Jagdmann
Date:
Subject: Re: foreign keys with on delete cascade and triggers