Weird error message in SQL function call

From: Vincenzo Romano <vincenzo(dot)romano(at)notorand(dot)it>
To: pgsql-general(at)postgresql(dot)org
Subject: Weird error message in SQL function call
Date: 2007-07-16 09:57:57
Message-ID: 200707161157.58084.Vincenzo.Romano@notorand.it
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

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().
In the syslog I see that this is labelled as error #0A000 "Feature not
supported".

Is there any hint?

--
Vincenzo Romano -= NotOrAnd.IT Information Technologies =-
tel +39 0823 454163 | cel +39 339 8083886 | fax +39 02 700506964
<Smooth seas never make experienced sailormen>

Browse pgsql-general by date

  From Date Subject
Next Message Vincenzo Romano 2007-07-16 10:03:43 Weird error message in SQL function call
Previous Message Koen Vermeer 2007-07-16 07:55:02 Re: Force SSL / username combination