| From: | "Nigel J(dot) Andrews" <nandrews(at)investsystems(dot)co(dot)uk> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: Casting |
| Date: | 2003-04-10 08:12:37 |
| Message-ID: | Pine.LNX.4.21.0304100910090.19529-100000@ponder.fairway2k.co.uk |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general pgsql-hackers |
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(at)investsystems(dot)co(dot)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,
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Peter Nixon | 2003-04-10 09:22:06 | Re: Delete large amount of records and INSERT (with indexes) goes VERY slow |
| Previous Message | Shridhar Daithankar | 2003-04-10 06:23:22 | Re: pg_dump / pg_dumpall / memory issues |
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Sailesh Krishnamurthy | 2003-04-10 08:53:36 | Re: Bit Filters |
| Previous Message | Hannu Krosing | 2003-04-10 07:59:42 | Re: Bit Filters |