Re: executing user-defined functions - Mailing list pgsql-general

From Tom Lane
Subject Re: executing user-defined functions
Date
Msg-id 28052.970726856@sss.pgh.pa.us
Whole thread Raw
In response to executing user-defined functions  (oberpwd@anubis.network.com (Wade D. Oberpriller))
List pgsql-general
oberpwd@anubis.network.com (Wade D. Oberpriller) writes:
> I was wondering if PostgreSQL protects itself when executing user-defined
> functions?

User-written functions coded in C are insecure by definition; it's up
to you to get them right.  The other available programming languages
are considerably safer.

> We are building an app where we want 3rd parties to be able to give us their
> data, and give us functions to check their data. We will insert the data into
> our database and run their functions when needed. However we don't want their
> functions to take down our system.

Don't accept C functions then...

            regards, tom lane

pgsql-general by date:

Previous
From: Tom Lane
Date:
Subject: Re: -F option, RAM usage, more...
Next
From: Tom Lane
Date:
Subject: Re: CIDR index use for '<<' operator