X-Original-To: pgsql-php-postgresql.org@localhost.postgresql.org Received: from localhost (unknown [200.46.204.144]) by svr1.postgresql.org (Postfix) with ESMTP id 2CEAD5E37D0 for ; Thu, 12 Aug 2004 14:03:27 -0300 (ADT) Received: from svr1.postgresql.org ([200.46.204.71]) by localhost (av.hub.org [200.46.204.144]) (amavisd-new, port 10024) with ESMTP id 50505-09 for ; Thu, 12 Aug 2004 17:03:21 +0000 (GMT) Received: from av1-1-sn4.m-sp.skanova.net (av1-1-sn4.m-sp.skanova.net [81.228.10.116]) by svr1.postgresql.org (Postfix) with ESMTP id 7F1C15E46C0 for ; Thu, 12 Aug 2004 14:03:15 -0300 (ADT) Received: by av1-1-sn4.m-sp.skanova.net (Postfix, from userid 502) id 1817837EB9; Thu, 12 Aug 2004 19:03:13 +0200 (CEST) Received: from smtp2-1-sn4.m-sp.skanova.net (smtp2-1-sn4.m-sp.skanova.net [81.228.10.183]) by av1-1-sn4.m-sp.skanova.net (Postfix) with ESMTP id 07E0337E43 for ; Thu, 12 Aug 2004 19:03:13 +0200 (CEST) Received: from [192.168.100.2] (h117n2fls31o806.telia.com [217.210.1.117]) by smtp2-1-sn4.m-sp.skanova.net (Postfix) with ESMTP id E2A3F37E47 for ; Thu, 12 Aug 2004 19:03:12 +0200 (CEST) Subject: problem when two or more users access simultaneously? From: Dag Gullberg To: pgsql-php@postgresql.org Content-Type: text/plain Organization: Message-Id: <1092330279.4308.12.camel@hemma> Mime-Version: 1.0 X-Mailer: Ximian Evolution 1.2.2 (1.2.2-5) Date: 12 Aug 2004 19:04:39 +0200 Content-Transfer-Encoding: 7bit X-Virus-Scanned: by amavisd-new at hub.org X-Spam-Status: No, hits=0.1 tagged_above=0.0 required=5.0 tests=RCVD_IN_SORBS X-Spam-Level: X-Archive-Number: 200408/22 X-Sequence-Number: 2910 Hi, I am building a site where users log in and access tables in two diffrent schema. I'm using PHP 4.3 and PostgreSQL 7.4 and I have problems with involontary logouts since the users credentials cannot be verified when reloading the main page of the application. Typically this occurs when users are involved in similar activity, dealing with the same tables. All transactions are handled through the same postgres-user and are all done through plpgsql-scripts. I am yet not *sure* that the problem is with the database, I am exploring different possibilities. My questions are: Are there any known problems with concurrency and if so are there any tricks or such to solve or bypass this problem? Any takers? regards /Dag