problem when two or more users access simultaneously?

From: Dag Gullberg <dag(dot)gullberg(at)telia(dot)com>
To: pgsql-php(at)postgresql(dot)org
Subject: problem when two or more users access simultaneously?
Date: 2004-08-12 17:04:39
Message-ID: 1092330279.4308.12.camel@hemma
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-php

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

Browse pgsql-php by date

  From Date Subject
Next Message Michelle Konzack 2004-08-14 15:15:30 How to create a new Table in prostgresql from a Webinterface
Previous Message Thom Dyson 2004-08-12 14:35:09 Re: blob size after pg_lo_open