Function in PostgreSQL

Started by Sachin Srivastavaover 10 years ago2 messagesgeneral
Jump to latest
#1Sachin Srivastava
ssr.teleatlas@gmail.com

Hi,

Do you know if it is possible to create a function in postgres that has
errors in the syntax of the creation sql? It would help our conversion
process if we could get all of our various functions present in postgres
even if they aren’t in 100% working shape. Is there any way to ignore
errors on object creation?

Please suggest?

Regards,

SS

#2Laurenz Albe
laurenz.albe@cybertec.at
In reply to: Sachin Srivastava (#1)
Re: Function in PostgreSQL

Sachin Srivastava wrote:

Do you know if it is possible to create a function in postgres that has errors in the syntax of the
creation sql? It would help our conversion process if we could get all of our various functions
present in postgres even if they aren’t in 100% working shape. Is there any way to ignore errors on
object creation?

I am not 100% sure what you mean, but does

SET check_function_bodies=off;

fix your problem?

Yours,
Laurenz Albe

--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general