X-Original-To: pgsql-admin-postgresql.org@localhost.postgresql.org Received: from localhost (neptune.hub.org [200.46.204.2]) by svr1.postgresql.org (Postfix) with ESMTP id 8563BD1B4BE for ; Sun, 25 Jan 2004 16:25:37 +0000 (GMT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (neptune.hub.org [200.46.204.2]) (amavisd-new, port 10024) with ESMTP id 07559-01 for ; Sun, 25 Jan 2004 12:25:05 -0400 (AST) Received: from ndl1mr1-a-fixed.sancharnet.in (ndl1mr1-a-fixed.sancharnet.in [61.0.0.45]) by svr1.postgresql.org (Postfix) with ESMTP id 4C5BCD1B493 for ; Sun, 25 Jan 2004 12:25:05 -0400 (AST) Received: from conversion-daemon.ndl1mr1-a-fixed.sancharnet.in by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) id <0HS200I01062AY@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Sun, 25 Jan 2004 21:54:52 +0530 (IST) Received: from sancharnet.in ([61.0.95.125]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HS200ANC098T8@ndl1mr1-a-fixed.sancharnet.in>; Sun, 25 Jan 2004 21:54:51 +0530 (IST) Date: Sun, 25 Jan 2004 22:01:45 +0530 From: "V i s h a l Kashyap @ [Sai Hertz And Control Systems]" Subject: Re: Selects query inside function must read commited data In-reply-to: <1075047334.1491.16.camel@linda.lfix.co.uk> To: Oliver Elphick Cc: pgsql-admin@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <4013EF71.9080603@sancharnet.in> Organization: Sai Hertz And Control Systems MIME-version: 1.0 Content-type: multipart/alternative; boundary="Boundary_(ID_XELk17fbJwzEuhT1uOpTrA)" X-Accept-Language: en-us, en User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US; rv:1.6b) Gecko/20031205 Thunderbird/0.4 References: <40138377.2070503@sancharnet.in> <1075047334.1491.16.camel@linda.lfix.co.uk> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/199 X-Sequence-Number: 12062 This is a multi-part message in MIME format. --Boundary_(ID_XELk17fbJwzEuhT1uOpTrA) Content-type: text/plain; charset=us-ascii; format=flowed Content-transfer-encoding: 7BIT Dear Oliver Elphick , >>If I am not wrong PostgreSQL select statements works on committed data >>thus the new >>inserted data at #3 must not be available to sai_func_b() till #5 >> >> > >No. All operations by a single transaction are visible inside the >transaction. Therefore an encapsulated function can see anything already >done in the whole transaction. A function must be entirely inside a >transaction and cannot start a transaction, so there can never be any >problem about this. > > Loads of thanks for the kind reply . Would be greatefull if you kindly post some links/refrences to support your answer for the said. Thanks one again . -- Regards, Vishal Kashyap ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* I Know you believe my words so logon to Jabber.org and add vishalkashyap@jabber.org to your roster. OR Seek Me at 264360076 ~*~*~*~*~*~*~*~* I am usually called as Vishal Kashyap but my Girlfriend calls me as Vishal CASH UP. This is because others identify me because of my generosity but my Girlfriend identify me because of my CASH. ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* --Boundary_(ID_XELk17fbJwzEuhT1uOpTrA) Content-type: text/html; charset=us-ascii Content-transfer-encoding: 7BIT Dear Oliver Elphick  ,
If I am not wrong PostgreSQL select statements works on committed data
thus the new
inserted data at #3 must not be available to sai_func_b() till #5
    

No.  All operations by a single transaction are visible inside the
transaction. Therefore an encapsulated function can see anything already
done in the whole transaction.  A function must be entirely inside a
transaction and cannot start a transaction, so there can never be any
problem about this.
  
Loads of thanks  for the kind reply .
Would be greatefull if you kindly post some links/refrences to support your answer for the said.
Thanks one again .


-- 
Regards,
Vishal Kashyap

~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
I Know you believe my words so logon to Jabber.org
and add vishalkashyap@jabber.org to your roster.
                     OR
Seek Me at 264360076                                 
~*~*~*~*~*~*~*~*
I am usually called as Vishal Kashyap
but my Girlfriend calls me as Vishal CASH UP.
This is because others identify me because of my generosity
but my Girlfriend identify me because of my CASH.
~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*
--Boundary_(ID_XELk17fbJwzEuhT1uOpTrA)--