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
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 |