Re: PL/PGSQL: Dynamic Record Introspection

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us>
Cc: uol(at)freenet(dot)de, Neil Conway <neilc(at)samurai(dot)com>, PostgreSQL-patches <pgsql-patches(at)postgresql(dot)org>
Subject: Re: PL/PGSQL: Dynamic Record Introspection
Date: 2006-05-30 14:13:00
Message-ID: 23544.1148998380@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-hackers pgsql-patches

Bruce Momjian <pgman(at)candle(dot)pha(dot)pa(dot)us> writes:
> It seems like a cool feature.

The fundamental problem with it is that plpgsql isn't designed to deal
with dynamically changing data types. The patch as submitted contained
some hacks that sort of dealt with this in some cases (I don't think it
covered them all), but really some serious thought is going to have to
go into making that work. It'd be good to do, because the existing
RECORD-variable feature already creates cases where it's needed; but
AFAICS it's not something that can be fixed off-the-cuff.

regards, tom lane

In response to

Responses

Browse pgsql-hackers by date

  From Date Subject
Next Message Devrim GUNDUZ 2006-05-30 14:14:02 Re: plperl's ppport.h out of date?
Previous Message Tom Lane 2006-05-30 14:08:03 Re: plperl's ppport.h out of date?

Browse pgsql-patches by date

  From Date Subject
Next Message uol 2006-05-30 15:23:42 Re: PL/PGSQL: Dynamic Record Introspection
Previous Message Bruce Momjian 2006-05-30 14:09:31 Re: [PATCH] Round 2: Magic block for modules