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

Re: Support for %TYPE in CREATE FUNCTION

From: Pascal Scheffers <pascal(at)scheffers(dot)net>
To: Jan Wieck <JanWieck(at)Yahoo(dot)com>
Cc: Ian Lance Taylor <ian(at)airs(dot)com>, Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>, Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>, <pgsql-hackers(at)postgresql(dot)org>
Subject: Re: Support for %TYPE in CREATE FUNCTION
Date: 2001-06-01 06:15:39
Message-ID: Pine.LNX.4.32L2.0106010800530.21797-100000@io (view raw, whole thread or download thread mbox)
Lists: pgsql-hackerspgsql-patches

I've been following this discussion with interest. As a member of the
OpenACS community I'd like to see the %TYPE feature in PG ASAP. I also
understand the reluctance of some of the PG team members in implementing
something that is not anywhere near 'perfect'.

I like Jans' (and Ian?) suggestion of ONLY doing resolution at create
time, as a full 'tracking-the-current-definition' seems to too tough for
now. I think it will be very acceptable to a lot of us out there to have
to drop and re-create our own dependancies. A lot of times, the changes
may not require recoding of the function (except for languages like C).
For OpenACS, schema changes on production machines will mostly be managed
by upgrade sql scripts. Although not 'perfect', having to drop and
recreate functions during upgrade are only minor problems.

>     AND  expect  it  to  do  more  than that.  So a NOTICE at the
>     actual usage, telling that  x%TYPE  for  y  got  resolved  to
>     basetype  z  and will currently NOT follow later changes to x
>     should do it.

So if you could implement it like that, we will be VERY happy.

Pascal Scheffers

In response to


pgsql-hackers by date

Next:From: Hannu KrosingDate: 2001-06-01 06:28:36
Subject: Re: Imperfect solutions
Previous:From: Bruce MomjianDate: 2001-06-01 04:45:45
Subject: Re: Imperfect solutions

pgsql-patches by date

Next:From: Joe ConwayDate: 2001-06-01 06:31:51
Subject: Fw: Isn't pg_statistic a security hole - Solution Proposal
Previous:From: Bruce MomjianDate: 2001-06-01 04:47:15
Subject: Re: Patch to remove sort files, temp tables, unreferenced files

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