Re: [HACKERS] User Level Lock question

2002-03-17 Thread Nicolas Bazin
- Original Message - From: "Lance Ellinghaus" <[EMAIL PROTECTED]> To: "Tom Lane" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Saturday, March 16, 2002 6:54 AM Subject: Re: [HACKERS] User Level Lock question > I know it does not sound like

Re: [HACKERS] User Level Lock question

2002-03-15 Thread Greg Copeland
On Fri, 2002-03-15 at 21:45, Lance Ellinghaus wrote: > The application actually does not want nor need a consistent view of the > data. It is expecting that records that are locked will not be viewed at > all. The locks are normally held for VERY short periods of time. The fact > that the applicat

Re: [HACKERS] User Level Lock question

2002-03-15 Thread Lance Ellinghaus
e acts compared to a REAL RDBMS. If this application was coded with a RDBMS in mind, things would be much easier. Lance - Original Message - From: "Neil Conway" <[EMAIL PROTECTED]> To: "Lance Ellinghaus" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent:

Re: [HACKERS] User Level Lock question

2002-03-15 Thread Greg Copeland
On Fri, 2002-03-15 at 16:24, Neil Conway wrote: > On Fri, 2002-03-15 at 14:54, Lance Ellinghaus wrote: > > I know it does not sound like something that would need to be done, but here > > is why I am looking at doing this... > > > > I am trying to replace a low level ISAM database with PostgreSQL

Re: [HACKERS] User Level Lock question

2002-03-15 Thread Neil Conway
On Fri, 2002-03-15 at 14:54, Lance Ellinghaus wrote: > I know it does not sound like something that would need to be done, but here > is why I am looking at doing this... > > I am trying to replace a low level ISAM database with PostgreSQL. The low > level ISAM db allows locking a record during a

Re: [HACKERS] User Level Lock question

2002-03-15 Thread Greg Copeland
an do it with the supplied routines. > > Does this make any more sense now or have I made it that much more > confusing? > > Lance > > - Original Message - > From: "Tom Lane" <[EMAIL PROTECTED]> > To: "Lance Ellinghaus" <[EMAIL PROTECTED

Re: [HACKERS] User Level Lock question

2002-03-15 Thread Lance Ellinghaus
To: "Lance Ellinghaus" <[EMAIL PROTECTED]> Cc: <[EMAIL PROTECTED]> Sent: Friday, March 15, 2002 9:11 AM Subject: Re: [HACKERS] User Level Lock question > "Lance Ellinghaus" <[EMAIL PROTECTED]> writes: > > Is there an easy way to test the lock on a user le

Re: [HACKERS] User Level Lock question

2002-03-15 Thread Tom Lane
"Lance Ellinghaus" <[EMAIL PROTECTED]> writes: > Is there an easy way to test the lock on a user level lock without actually > issuing the lock? Why would you ever want to do such a thing? If you "test" the lock but don't actually acquire it, someone else might acquire the lock half a microsecon