Re: Weird error message in SQL function call - Mailing list pgsql-general

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