Thread: Infinite loop crashes server

hi all,

i am using PostgreSQL 7.3.2 on redhat linux 9.

there is problem when executing pl/pg sql functions.

if the function enter an infinite loop. the server is hanged.

cannot cancel the query.

the linux itself is hanged.i cannot kill postgres process.

i have to reboot the machine manually..

waited for a long time for completion. but no result .

when ever there is an infinite loop happened

the system have to be restarted. unfortunately it happened many time

during development of the pl/pg sql function.

is it a bug in postgres. or is it configuration problem?

when the system is hanged disk access is 100%. the harddisk read indicator does not stop.

 

is there a solution for this problem..

pls help

regards

jinujose