Gayathri TK wrote:
> Hi all,
>
> I am trying to create a User-defined function(UDF) which takes filename
> as input.. the function reads the file containig sql queries and
> executes them in background using libq functions (PGconnectDb, PQexec
> etc..).
> But when i tried creating a UDF using 'CREATE OR REPLACE FUNCTION' , i
> get the following error:
Should you not be using SPI to run queries if this is inside PostgreSQL?
See chapter 39 "Server Programming Interface" for details.
--
Richard Huxton
Archonet Ltd