X-Original-To: pgsql-sql-postgresql.org@localhost.postgresql.org Received: from localhost (av.hub.org [200.46.204.144]) by postgresql.org (Postfix) with ESMTP id AA8699DC844 for ; Thu, 26 Jan 2006 03:10:03 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 05163-06 for ; Thu, 26 Jan 2006 03:10:03 -0400 (AST) Received: from svr4.postgresql.org (svr4.postgresql.org [66.98.251.159]) by postgresql.org (Postfix) with ESMTP id 1A6E69DC820 for ; Thu, 26 Jan 2006 03:09:59 -0400 (AST) Received: from ls405.htnet.hr (ls405.htnet.hr [195.29.150.97]) by svr4.postgresql.org (Postfix) with ESMTP id BAA0D5AF0BB for ; Thu, 26 Jan 2006 07:09:58 +0000 (GMT) Received: from ls422.t-com.hr (ls422.t-com.hr [195.29.150.237]) by ls405.htnet.hr (0.0.0/8.12.10) with ESMTP id k0Q79nSn019606; Thu, 26 Jan 2006 08:09:49 +0100 Received: from ls422.t-com.hr (localhost.localdomain [127.0.0.1]) by ls422.t-com.hr (Qmlai) with ESMTP id 2813D98803F; Thu, 26 Jan 2006 08:09:49 +0100 (CET) X-Envelope-Sender: mario.splivalo@mobart.hr X-Envelope-Sender: mario.splivalo@mobart.hr Received: from ls422.t-com.hr (localhost.localdomain [127.0.0.1]) by ls422.t-com.hr (Qmlai) with ESMTP id 235C5988043; Thu, 26 Jan 2006 08:09:49 +0100 (CET) Received: from 83-131-72-216.adsl.net.t-com.hr (83-131-72-216.adsl.net.t-com.hr [83.131.72.216]) by ls422.t-com.hr (Qmlai) with ESMTP id E316F8B8056; Thu, 26 Jan 2006 08:09:48 +0100 (CET) Subject: Re: Changing the transaction isolation level within the From: Mario Splivalo Reply-To: mario.splivalo@mobart.hr To: Jaime Casanova Cc: pgsql-sql@postgresql.org In-Reply-To: References: <1138198348.8828.32.camel@localhost.localdomain> Content-Type: text/plain Organization: Mob-Art Date: Thu, 26 Jan 2006 08:08:30 +0100 Message-Id: <1138259311.16164.0.camel@localhost.localdomain> Mime-Version: 1.0 X-Mailer: Evolution 2.4.1 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, score=0.08 required=5 tests=[AWL=0.080] X-Spam-Score: 0.08 X-Spam-Level: X-Archive-Number: 200601/172 X-Sequence-Number: 23961 On Wed, 2006-01-25 at 11:46 -0500, Jaime Casanova wrote: > you need to set the transaction level after the begin and before every > other statement... after the begin you have a select that invoke your > function so that set is not the first statement... But I can't do that inside of a function, right? Mari