BUG #3376: Erro : COMMIT

From: "Felipe Nogueira" <fbnogueira(at)gmail(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #3376: Erro : COMMIT
Date: 2007-06-08 13:36:18
Message-ID: 200706081336.l58DaIhL060744@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 3376
Logged by: Felipe Nogueira
Email address: fbnogueira(at)gmail(dot)com
PostgreSQL version: 8.2.4
Operating system: Windows 2003
Description: Erro : COMMIT
Details:

PostgreSQL 8.2.4 on i686-pc-mingw32, compiled by GCC gcc.exe (GCC) 3.4.2
(mingw-special).

I have the following function

CREATE OR REPLACE FUNCTION "public"."data" (integer, integer) RETURNS
integer AS
$body$
DECLARE
vDATA integer;
BEGIN
COMMIT;
END;
$body$
LANGUAGE 'plpgsql' STABLE CALLED ON NULL INPUT SECURITY INVOKER;

When I execute i have the error

ERROR: SPI_execute_plan failed executing query "COMMIT":
SPI_ERROR_TRANSACTION
CONTEXT: PL/pgSQL function "data" line 4 at SQL statement

I saw at Internet this bug was already reported.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Heikki Linnakangas 2007-06-08 13:54:08 Re: BUG #3376: Erro : COMMIT
Previous Message Alvaro Herrera 2007-06-07 19:02:01 Re: [PATCHES] [BUGS] BUG #3326: Invalid lower bound of autovacuum_cost_limit