The following bug has been logged online: Bug reference: 2791 Logged by: Raman Dabhade Email address: [EMAIL PROTECTED] PostgreSQL version: 8.1 Operating system: Win XP Description: Error while commiting Details:
ERROR: SPI_execute_plan failed executing query "commit": SPI_ERROR_TRANSACTION CONTEXT: PL/pgSQL function "processrecords" line 4 at SQL statement When executing following procedure: CREATE OR REPLACE FUNCTION processRecords() RETURNS int8 AS $BODY$ declare begin commit ; return 0; end; $BODY$ LANGUAGE 'plpgsql' VOLATILE; ---------------------------(end of broadcast)--------------------------- TIP 9: In versions below 8.0, the planner will ignore your desire to choose an index scan if your joining column's datatypes do not match