X-Original-To: pgsql-students-postgresql.org@localhost.postgresql.org Received: from localhost (mx1.hub.org [200.46.208.251]) by postgresql.org (Postfix) with ESMTP id 066D79FA5E9 for ; Wed, 31 May 2006 13:25:18 -0300 (ADT) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.208.251]) (amavisd-new, port 10024) with ESMTP id 68859-08 for ; Wed, 31 May 2006 13:25:12 -0300 (ADT) X-Greylist: delayed 00:39:23.568229 by SQLgrey- Received: from sa3.bezeqint.net (sa3.bezeqint.net [192.115.104.17]) by postgresql.org (Postfix) with ESMTP id 4013E9FA5E1 for ; Wed, 31 May 2006 13:25:11 -0300 (ADT) Received: from localhost (unknown [127.0.0.1]) by sa3.bezeqint.net (Bezeq International SMTP out Mail Server) with ESMTP id A4E8333F1B for ; Wed, 31 May 2006 18:45:41 +0300 (IDT) Received: from sa3.bezeqint.net ([127.0.0.1]) by localhost (sa3.bezeqint.net [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 18453-09 for ; Wed, 31 May 2006 18:45:37 +0300 (IDT) Received: from llord (unknown [88.155.93.181]) by sa3.bezeqint.net (Bezeq International SMTP out Mail Server) with ESMTP for ; Wed, 31 May 2006 18:45:37 +0300 (IDT) From: "Tzahi Fadida" To: Subject: Questions Date: Wed, 31 May 2006 18:45:47 +0200 Message-ID: <037b01c684d1$ab072000$0b00a8c0@llord> MIME-Version: 1.0 Content-Type: text/plain; charset="us-ascii" Content-Transfer-Encoding: 7bit X-Mailer: Microsoft Office Outlook 11 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1506 Thread-Index: AcaE0arIeet8jHZiT1aXo0QuR/dtQA== X-Virus-Scanned: amavisd-new at bezeqint.net X-Virus-Scanned: Maia Mailguard 1.0.1 X-Spam-Status: No, hits=0.243 tagged_above=0 required=5 tests=BAYES_00, INFO_TLD, RAZOR2_CHECK, SPF_NEUTRAL X-Spam-Level: X-Archive-Number: 200605/3 X-Sequence-Number: 3 First, Good luck to everyone. I have a postgresql question. My C function can run for a very very long time on some inputs and reiterate on relations using SPI. Basically, I open portals and cursors to relations and use tuplestores. Also note that I always open the relations in READ ONLY mode using SPI. I have a great need to identify a tuple uniquely so my prototype uses the CTID field for that purpose. The question is, can the CTID field change throughout the run of my function due to some other processes working on the relation? Or because of command bounderies it is pretty much secured inside an implicit transaction. The problem wasn't so great if I didn't want to exploit indices in the relations (but I do and does), since after you issue a SELECT that uses indices, all you can rely on is the CTID to uniquely identify a tuple. The other solution is to temporarily duplicate the relations but I don't like this very much. Regards, Tzahi. -- Tzahi Fadida Blog: http://tzahi.blogsite.org | Home Site: http://tzahi.webhop.info WARNING TO SPAMMERS: see at http://members.lycos.co.uk/my2nis/spamwarning.html