Interessting problem

Поиск
Список
Период
Сортировка
Искать
От
ohp@pyrenet.fr
Тема
Interessting problem
Дата
в 18:17:35
Msg-id
Pine.UW2.4.53.0305191355070.3345@server.pyrenet.fr
Список
Дерево обсуждения
Interessting problem ohp@pyrenet.fr
Re: Interessting problem "Jim C. Nasby" <jim@nasby.net>
Hi every one.

One of my customer has made a big mistake on one of his databases and that
made me think (a little bit)

The mistake was really simple: he wrote a plpgsql function that looped
indefinitly.

I have restarted the database and every think went back normal but I
wonder how a joe user could stop his own backend. (this wasn't triggered
by psql but on the web by php).

The fact that the postgres user owns all the backend makes it impossible
for ordinary users to kill their backend or have I missed something?

Is there a solution?

-- 
Olivier PRENANT         	Tel:	+33-5-61-50-97-00 (Work)
Quartier d'Harraud Turrou           +33-5-61-50-97-01 (Fax)
31190 AUTERIVE                      +33-6-07-63-80-64 (GSM)
FRANCE                      Email: ohp@pyrenet.fr
------------------------------------------------------------------------------
Make your life a dream, make your dream a reality. (St Exupery)

В списке pgsql-hackers по дате отправления
От: Martijn van Oosterhout
Дата:
Сообщение: Re: Feature suggestions (long)
От: Zeugswetter Andreas SB SD
Дата:
Сообщение: Re: Feature suggestions (long)
FAQ