Skip site navigation (1) Skip section navigation (2)

Postgresq 8,1 hangs when running function

From: "ben sewell" <mosherben(at)gmail(dot)com>
To: pgsql-novice(at)postgresql(dot)org
Subject: Postgresq 8,1 hangs when running function
Date: 2006-08-21 09:38:01
Message-ID: bf6c74d80608210238i6c95c904yc4dd00fbabe8ba9c@mail.gmail.com (view raw or flat)
Thread:
Lists: pgsql-novice
Hi guys,
I'm running postgresql 8.1 on a P4 3.0GHz,480 MB RAM, 160GB SCSI hard drive
on Windows XP. Postgres has been crashing when I have tried testing my
reports function, which i leads me to believe it is something in the
function because doing normal select statements works fine. Can anyone check
my code before I ask my boss if I could restart the server, as a restart
means 20 mins work lost for employees? Just for reference, tblnewbusiness
containts just under 8,000 records,

Cheers,
Ben

Any recommendations are welcome to sort this problem out.

Attachment: reports_sp.txt
Description: text/plain (7.7 KB)

Responses

pgsql-novice by date

Next:From: Sean DavisDate: 2006-08-21 10:53:00
Subject: Re: Postgresq 8,1 hangs when running function
Previous:From: Damian CDate: 2006-08-21 01:34:07
Subject: Re: pg_dump output goes to stderr, not stdout?!?

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group