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

---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster

Reply via email to