"Jasbinder Singh Bali" <jsbali@gmail.com> writes:
> In one of my trigger functions, i'm trying to catch invalid ip address
> exception
> CREATE OR REPLACE FUNCTION func_client_socket()
> RETURNS "trigger" AS
> $BODY$
> DECLARE
> ip_address_present int4;
> BEGIN
> ip_address_present = 1;
> SELECT inet(NEW.canonical_name);
> EXCEPTION WHEN invalid_text_representation THEN
> ip_address=0;
> END;
> $BODY$
> LANGUAGE 'plpgsql' VOLATILE;
> when i run this function, it gives me the followin error
> ERROR: syntax error at or near "EXCEPTION" at character 1343
> which is the line where I have the EXCEPTION clause.
When I run the function as given, it doesn't complain about the
EXCEPTION, but it does complain about the misspelled variable name
on the next line. Maybe you miscounted lines? It'd be worth your
while to update to a more recent PG version that gives better-localized
syntax error messages. 8.1 or 8.2 will say something like
ERROR: syntax error at or near "ip_address" at character 1
QUERY: ip_address=0
CONTEXT: SQL statement in PL/PgSQL function "func_client_socket" near line 7
LINE 1: ip_address=0
^
regards, tom lane