Vincenzo Romano wrote:
Hi all.
I've got this error message while running an SQL function:
---- BEGIN
psql:filtb.sql:1029: ERROR: COMMIT is not allowed in a SQL function
CONTEXT: SQL function "f_relazione" during startup
funzione SQL "f_relazione" istruzione 1
---- END
Of course, I have no COMMIT command either in the function itself or
in any other function called by f_relazione().
Seeing as you are reading in a large .sql file, I'd look for a quoting
error - if the closing quote for the function-body isn't correct it'll
run on, and then encounter a COMMIT further down the file.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 2: Don't 'kill -9' the postmaster
