Re: RES: 8.2.4 selects make applications wait indefinitely

Поиск
Список
Период
Сортировка
От Tomasz Ostrowski
Тема Re: RES: 8.2.4 selects make applications wait indefinitely
Дата
Msg-id 20071015071025.GA28698@batory.org.pl
обсуждение исходный текст
Ответ на RES: 8.2.4 selects make applications wait indefinitely  ("Carlos H. Reimer" <carlos.reimer@opendb.com.br>)
Список pgsql-general
On Thu, 11 Oct 2007, Carlos H. Reimer wrote:

> the problem happens with many machines where our Visual Basic
> applications is running. After debuging the application we discovered that
> the problem was always with "select *" statements.

I'd try locally:

$ psql -c 'select * from table where pk=1' [dbname] [username]

then locally:

$ psql -h localhost -c 'select * from table where pk=1' [dbname] [username]

then locally

$ psql -h [IP_eth0] -c 'select * from table where pk=1' [dbname] [username]

then I'd use a local network computer with a clear operating system,
like Fedora Live CD, because this can be caused by, for example, some
kind of intrusion detection system, which accidentally triggers on
data in this row.

Regards
Tometzky
--
...although Eating Honey was a very good thing to do, there was a
moment just before you began to eat it which was better than when you
were...
                                                      Winnie the Pooh

В списке pgsql-general по дате отправления:

Предыдущее
От: "Chris Velevitch"
Дата:
Сообщение: Using case expressions in update set clause
Следующее
От: "Albe Laurenz"
Дата:
Сообщение: Re: Will UPDATE lock if FROM refers to target table?