Skip site navigation (1) Skip section navigation (2)

Re: PL/pgSQL RENAME functionality in TODOs

From: Bruce Momjian <bruce(at)momjian(dot)us>
To: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
Cc: imad <immaad(at)gmail(dot)com>, pgsql-hackers <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: PL/pgSQL RENAME functionality in TODOs
Date: 2007-01-31 04:24:10
Message-ID: 200701310424.l0V4OAi20588@momjian.us (view raw or flat)
Thread:
Lists: pgsql-hackers
URL added to TODO.  (I didn't have URLs in there at the time).

---------------------------------------------------------------------------

Tom Lane wrote:
> imad <immaad(at)gmail(dot)com> writes:
> > "Fix RENAME to work on variables other than OLD/NEW"
> > I can rename just any variable declared in a PL block apart from
> > OLD/NEW. Is the TODOs list out of sync or I am missing the point here?
> 
> Really?  It looks pretty broken to me still:
> 
> regression=# create function foo() returns int as $$
> regression$# declare
> regression$#   x int := 1;
> regression$#   rename x to y;
> regression$# begin
> regression$#   return y;
> regression$# end;$$ language plpgsql;
> ERROR:  syntax error at or near "x"
> LINE 4:   rename x to y;
>                  ^
> 
> See old discussion here:
> http://archives.postgresql.org/pgsql-hackers/2002-03/msg00591.php
> 
> 			regards, tom lane
> 
> ---------------------------(end of broadcast)---------------------------
> TIP 1: if posting/reading through Usenet, please send an appropriate
>        subscribe-nomail command to majordomo(at)postgresql(dot)org so that your
>        message can get through to the mailing list cleanly

-- 
  Bruce Momjian   bruce(at)momjian(dot)us
  EnterpriseDB    http://www.enterprisedb.com

  + If your life is a hard drive, Christ can be your backup. +

In response to

Responses

pgsql-hackers by date

Next:From: Pavan DeolaseeDate: 2007-01-31 05:48:30
Subject: Re: stack usage in toast_insert_or_update()
Previous:From: Bruce MomjianDate: 2007-01-31 04:16:28
Subject: Re: [PATCHES] pg_standby

Privacy Policy | About PostgreSQL
Copyright © 1996-2014 The PostgreSQL Global Development Group