Re: Some unknown error in a function - Mailing list pgsql-general

From Tom Lane
Subject Re: Some unknown error in a function
Date
Msg-id 1906.1171043391@sss.pgh.pa.us
Whole thread Raw
In response to Some unknown error in a function  ("Jasbinder Singh Bali" <jsbali@gmail.com>)
List pgsql-general
"Jasbinder Singh Bali" <jsbali@gmail.com> writes:
> I run this function using
> select sp_insert_tbl_vrfy_mx(55,'jas','xyz.com','192.168.0.105', '
> mail.xyz.com,'mxrecoredmxjdlkfjdk')
> and get the following error:-

> CONTEXT:  SQL statement "SELECT   $1  =' '"
> PL/pgSQL function "sp_insert_tbl_vrfy_mx" line 12 at if

You didn't show us the actual error message, but I suppose it's unhappy
that ' ' is not a legal inet value.

            regards, tom lane

pgsql-general by date:

Previous
From: Richard Broersma Jr
Date:
Subject: Re: Modifying a foreign key constraint?
Next
From: "Chandra Sekhar Surapaneni"
Date:
Subject: Re: Some unknown error in a function