error code invalid_input_syntax

From: Rainer Leo <leo(at)workfile(dot)de>
To: pgsql-sql(at)postgresql(dot)org
Subject: error code invalid_input_syntax
Date: 2006-01-12 08:43:59
Message-ID: loom.20060112T094211-926@post.gmane.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: 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

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message Dirk Jagdmann 2006-01-12 11:49:27 Re: foreign keys with on delete cascade and triggers
Previous Message Tom Lane 2006-01-12 03:02:21 Re: foreign keys with on delete cascade and triggers