Re: [SQL] Issue with UPDATE statement on v8

2005-09-23 Thread Michael Fuhr
On Thu, Sep 22, 2005 at 11:22:22AM -0500, Kenneth Hutchinson wrote: > UPDATE t_summary > SETavailability = 7 > WHERE oid = 28245084 > > When this query is executed (within a function or without) the database > will simply hang. If the UPDATE is turned into a SELECT, the query > works jus

Re: [SQL] Issue with UPDATE statement on v8

2005-09-22 Thread Rajesh Kumar Mallah
On 9/23/05, Kenneth Hutchinson <[EMAIL PROTECTED]> wrote: > Hello, > > I'm sorry if this has been sent to the community multiple times. I am > not able to determine whether my posts have gotten through. If you have > rec'd this multiple times, please let me know. > > We have recently migrated to

Re: [SQL] Issue with UPDATE statement on v8

2005-09-22 Thread Tom Lane
"Kenneth Hutchinson" <[EMAIL PROTECTED]> writes: > UPDATE t_summary > SETavailability = 7 > WHERE oid = 28245084 > When this query is executed (within a function or without) the database > will simply hang. Is it really hung, or just taking an awfully long time? If the backend is consum