Re: strange plpgsql error

From: Ralikwen <Balazs(dot)Klein(at)gmail(dot)com>
To: pgsql-general(at)postgresql(dot)org
Subject: Re: strange plpgsql error
Date: 2009-10-12 15:08:40
Message-ID: 25857385.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general


Dunno, if it was a documented behavior it should fail both on on 8.1 Linux
and on 8.4 Windows, but it only fails on 8.4 Windows.

I will try to create a clear test.

Merlin Moncure-2 wrote:
>
> On Sun, Oct 11, 2009 at 6:21 PM, SunWuKung <Ralikwen(at)hotmail(dot)com> wrote:
>>
>> Yep,
>> it is probably a bug though.
>
> It's not...it's just the way plpgsql works. I prefix all my local
> variables in plpgsql with an underscore to prevent these kinds of
> conflicts.
>
> merlin
>
> --
> Sent via pgsql-general mailing list (pgsql-general(at)postgresql(dot)org)
> To make changes to your subscription:
> http://www.postgresql.org/mailpref/pgsql-general
>
>

--
View this message in context: http://www.nabble.com/strange-plpgsql-error-tp25847709p25857385.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Bruce Momjian 2009-10-12 15:13:23 Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints
Previous Message Teodor Sigaev 2009-10-12 15:07:33 Re: Re: [GENERAL] contrib/plantuner - enable PostgreSQL planner hints