Concurrent access related issue.

On Sat, Jun 05, 2004 at 00:21:08 -0700,
Bhavin Patel <bhawin13@indiatimes.com> wrote:

Hi

i have one table
2 user tires to select records from that table.
1st user select some records
2nd tries to select some records .
so second user is not able to see records selected by 1st user.
till operation is not completed by 1st user on selected records.

Can you sugest somthing that solve my problem

Normal selects don't block each other. Are you doing SELECT FOR UPDATE's?

You haven't really told us what you are trying to do, so it is hard to
tell you how to fix things. A higher level description of what you are
doing, actual sample commands and a description of the symptoms and why
they are causing a problem for your higher level task woud help people
answer your question.

I'm trying to build 7.4.2 on OS X 10.3.4, with --enable-thread-safey, and
configure gives me this error:

checking pthread.h usability... yes
checking pthread.h presence... yes
checking for pthread.h... yes
configure: error:
Cannot enable threads on your platform.
Please report your platform threading info to the PostgreSQL mailing lists
so it can be added to the next release. Report all compile flags, link
flags,
functions, or libraries required for threading support.
See the comment at the top of src/port/thread.c for more information.

--
Scott Ribe
scott_ribe@killerbytes.com
http://www.killerbytes.com/
(303) 665-7007 voice

And you are not doing what the message says.

---------------------------------------------------------------------------

Scott Ribe wrote:

I'm trying to build 7.4.2 on OS X 10.3.4, with --enable-thread-safey, and
configure gives me this error:

checking pthread.h usability... yes
checking pthread.h presence... yes
checking for pthread.h... yes
configure: error:
Cannot enable threads on your platform.
Please report your platform threading info to the PostgreSQL mailing lists
so it can be added to the next release. Report all compile flags, link
flags,
functions, or libraries required for threading support.
See the comment at the top of src/port/thread.c for more information.

--
Scott Ribe
scott_ribe@killerbytes.com
http://www.killerbytes.com/
(303) 665-7007 voice

---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to majordomo@postgresql.org

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  pgman@candle.pha.pa.us               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073