Claire McLister <[EMAIL PROTECTED]> writes:
> Thanks. So, the hack we did is okay then? Does using the substring
> function de-TOAST it?
Yeah, that should work till we think of a proper fix.
regards, tom lane
---(end of broadcast)---
Thanks. So, the hack we did is okay then? Does using the substring
function de-TOAST it?
On Feb 4, 2006, at 11:24 AM, Tom Lane wrote:
Claire McLister <[EMAIL PROTECTED]> writes:
This was all working fine until E.Value became some large strings
with some occasional funny characters.
The h
Claire McLister <[EMAIL PROTECTED]> writes:
> This was all working fine until E.Value became some large strings
> with some occasional funny characters.
> The hack that solved the problem was:
> R.Field := substring(E.Value from 1);
> This is a complete hack, so I'd like to find out what i
Thanks.
Actually, I had read the FAQ, and was correctly using the 'EXECUTE'
form of creating a temporary table. (If that had been the problem, it
would not have been working for a while.)
It turns out, the problem was a strange one. The function was
returning a set of records and one of t
Read the FAQ.
---
Claire McLister wrote:
> Hi,
>
> I'm using a pgsql function that begins by creating a temporary
> table, does some processing, and then drops the temporary table just
> before exiting. It has been w
Hi,
I'm using a pgsql function that begins by creating a temporary
table, does some processing, and then drops the temporary table just
before exiting. It has been working fine for a while now, but
suddenly complains for some calls that "Relation with OID" does not
exist, at the point w
