| From: | Andrew Dunstan <andrew(at)dunslane(dot)net> |
|---|---|
| To: | Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> |
| Cc: | PostgreSQL-development <pgsql-hackers(at)postgresql(dot)org> |
| Subject: | Re: BUG #2917: spi_prepare doesn't accept typename aliases |
| Date: | 2007-01-25 21:33:27 |
| Message-ID: | 45B92227.9060704@dunslane.net |
| Views: | Whole Thread | Raw Message | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-hackers |
Tom Lane wrote:
> Andrew Dunstan <andrew(at)dunslane(dot)net> writes:
>
>>> I see that SQL level prepare calls regprocin() to resolve type names,
>>> so maybe we should that for the PLs when calling SPI_prepare as well.
>>>
>> Of course, that should be regtypein()
>>
>
> [ squint... ] build_regtype_array seems a rather stupid bit of code.
> How many hundreds of cycles is it expending to convert an OID to an OID?
>
>
>
Yeah, you're right. I should have squinted too ;-)
Well, I am open to suggestions on what to do about this. I really think
we should support use of standard type aliases in the PLs.
cheers
andrew
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Alvaro Herrera | 2007-01-25 21:34:52 | Re: autovacuum process handling |
| Previous Message | Tom Lane | 2007-01-25 21:24:54 | Re: BUG #2917: spi_prepare doesn't accept typename aliases such as 'integer' |