problem with PostgreSQL and LAN

From: "Jacek Witczak" <yacol(at)venus(dot)wmid(dot)amu(dot)edu(dot)pl>
To: <pgsql-hackers(at)postgresql(dot)org>
Subject: problem with PostgreSQL and LAN
Date: 1999-10-18 14:25:53
Message-ID: 000101bf1974$b55af100$3200090a@yacol.linux.net
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers

Hi all,
my problem is simple but very frustrating,

I wrote some program under Windows 95 (MS VC++ 4.0).
This program uses MFC ODBC classes (CRecordset and CDatabase) to
cooperate with my PostgreSQL 6.3 (installed on RedHat 5.1 linux) via
psqlodbc driver.
I can connect to my databse, I can scroll, update, insert or delete records.
Everything's fine.
Problem starts when more than one user has access to the database.

Example:

Person A runs my program, connects to PostgreSQL database and opens
tables. Everything works fine.
Person B runs my program,connects to PostgreSQL database and opens
tables. Also everything works fine.
Both persons can scroll records and read their contents without any problem.

Now, let's say, Person A wants to make some modifications (or even add new
record)
to some records in some table. My program's execution stops and waits until
Person B exits application (!!!!!!).

ps ax command on my Linux server shows that there are two postgres processes
running with
some command line options (it's OK since there're 2 persons logged in).
And of course, there's also postmaster process running (with -i command line
option specified).
What's the reason of such a strange behavior? It seems, that postgres locks
entire database
and makes any updates impossible. Could any1 help me with that?
I'd appreciate any help...

yacol

Browse pgsql-hackers by date

  From Date Subject
Next Message Tom Lane 1999-10-18 14:34:52 Re: [HACKERS] sort on huge table
Previous Message Thomas Lockhart 1999-10-18 13:42:18 Re: [HACKERS] Tr: Functions documentations