Re: Casting - Mailing list pgsql-general

From Nigel J. Andrews
Subject Re: Casting
Date
Msg-id Pine.LNX.4.21.0304100910090.19529-100000@ponder.fairway2k.co.uk
Whole thread Raw
In response to Re: Casting  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general

Thanks Tom,

I thought that was something you were thinking about/putting on a list to do
later. As usual the speed of fixes being given is amazing.

I'll see if I can apply it later today or tomorrow, I need to move to 7.3.2 as
well so I can try it out then.


--
Nigel J. Andrews


On Wed, 9 Apr 2003, Tom Lane wrote:
> "Nigel J. Andrews" <nandrews@investsystems.co.uk> writes:
> > mydb=> select cast('truE'::text as boolean);
> > WARNING:  Error occurred while executing PL/pgSQL function text_to_bool
> > WARNING:  line 4 at select into variables
> > ERROR:  CopyQuerySnapshot: no snapshot has been set
>
> I've applied the attached patch to fix this.
>
>             regards, tom lane
>
> *** REL7_3/src/backend/parser/parse_coerce.c.orig    Thu Oct 24 18:09:00 2002
> --- REL7_3/src/backend/parser/parse_coerce.c    Wed Apr  9 22:47:57 2003
> ***************
> *** 226,251 ****
>                   result = (Node *) makeRelabelType(result, targetTypeId, -1,


pgsql-general by date:

Previous
From: Shridhar Daithankar
Date:
Subject: Re: pg_dump / pg_dumpall / memory issues
Next
From: Olleg Samojlov
Date:
Subject: Re: pl/pgsql and global variables