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 77EE1D1D485 for ; Sun, 25 Jan 2004 10:43:22 +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 49681-06 for ; Sun, 25 Jan 2004 06:42:52 -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 15218D1D34E for ; Sun, 25 Jan 2004 06:42:47 -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 <0HS100601KF16I@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Sun, 25 Jan 2004 16:12:42 +0530 (IST) Received: from sancharnet.in ([61.0.95.111]) by ndl1mr1-a-fixed.sancharnet.in (iPlanet Messaging Server 5.2 HotFix 1.17 (built Jun 23 2003)) with ESMTPA id <0HS100EM1KF3YH@ndl1mr1-a-fixed.sancharnet.in> for pgsql-admin@postgresql.org; Sun, 25 Jan 2004 16:12:42 +0530 (IST) Date: Sun, 25 Jan 2004 16:19: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: <40138377.2070503@sancharnet.in> Cc: pgsql-admin@postgresql.org Reply-To: aspire420@hotpop.com Message-id: <40139F49.80205@sancharnet.in> Organization: Sai Hertz And Control Systems MIME-version: 1.0 Content-type: text/plain; format=flowed; charset=ISO-8859-1 Content-transfer-encoding: 7BIT 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> X-Virus-Scanned: by amavisd-new at postgresql.org X-Archive-Number: 200401/197 X-Sequence-Number: 12060 > > Would like to receive your kind attention and enormous knowledge on > the following This tickles me > > I have a function So what ? > sai_func_a() > Which does as follows and in the same order: > 1. Retrieves the latest record from the table test_sai > (By latest I mean the record corresponding to max primary key of > the table) > 2. Increments date as received from test_sai.current_date > as my_new_date := test_sai.current_date + 1 ; > 3. Inserts the new date into the same table test_sai > 4. Calls another function sai_func_b() > Now inside sai_func_b() > 1. Does as #1 of above > 2. Works on the date in the last record. > 3. Returns success code to sai_func_a() > 5. The sai_func_a() finishes the work > > Now My question : No one is intrested in your question and thus no answers > Since sai_func_a() which encapsulates the function sai_func_b has not > completed yet till #4 or #5 > then how does the function sai_func_b reads the new data since it is > not committed yet. > > 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 > > Server Specs: > 1. version > --------------------------------------------------------------------------------------------------------- > PostgreSQL 7.3.4 on i686-pc-linux-gnu, compiled by GCC gcc (GCC) 3.2.2 > 20030222 (Red Hat Linux 3.2.2-5) > 2.Both functions are plpgsql and are not triggers > > > > If you need more information kindly ask for the same. Yes, I need one Why did you ask this question ? -- Regards, Vishal Kashyap ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~* I Know you believe my words so logon to Jabber.org and add vishalkashyap@jabber.org to your roster. ~*~*~*~*~*~*~*~* 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. ~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*~*