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@xxxxxxxxxxx> 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@xxxxxxxxxxxxxx) > 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. -- Sent via pgsql-general mailing list (pgsql-general@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general