Search Postgresql Archives

Re: how to check SQLSTATE

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Hugo <htakada@xxxxxxxxx> writes:
> Hi again, thanks for your guidance, this is the error I got trying to save
> my fuction:
> ERROR:  unrecognized exception condition "no_data"
> CONTEXT:  compile of PL/pgSQL function "fn_verificar_aportes_socio" near
> line 36

NO_DATA isn't an error condition, only a warning, thus there is no case
in which an exception block would trap it.  So plpgsql doesn't bother to
recognize it.

			regards, tom lane


[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux