[BUGS] A memory leak. Postgres 7.4. Mac OS. X Server

2004-05-28 Thread PAviles
Hi, we have a postgresql 7.4 database server on an  X Server with Mac OS 10.3.3, 7F45 The server  possess two CPU's, 4 Gb in memory, and an adequate space on disk. The service run fine in the majority of time. But, we see the memory go down, bit by bit. (A memory leak). No errors are produced, bu

[BUGS] Select For Update bug???

2002-07-29 Thread paviles
Hi, I'm encountered a problem with a select for update sentence with postgresql. If I use...: begin transaction; select * from employees where status = 'A' limit 1 for update; ... The problem, in the previous sentence, is block every record on employees, although we want one record, we want limi

[BUGS] Bug #722: SELECT FOR UPDATE bug

2002-07-29 Thread paviles
Pablo Aviles 27/07/2002 10:58         To:        Tom Lane <[EMAIL PROTECTED]>         cc:                 Subject:        Re: [BUGS] Bug #722: SELECT FOR UPDATE bugLink    Hi, we are use Postgresql 7.3. The case in questions is: we have many clients (pc's) of postgresql. Every client try to