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
Hello,
We have recently migrated to Postgres 8 (not sure of exactly
which build). We have noticed that a few functions that were working previously
are no longer behaving as expected. One function in particular is giving
me a strange result.
The function giving us the problem is much
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
"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
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 Postgres 8 (not sure of exactly which
build). We have noticed that a
