Re: BUG #2917: spi_prepare doesn't accept typename aliases - Mailing list pgsql-hackers

From Andrew Dunstan
Subject Re: BUG #2917: spi_prepare doesn't accept typename aliases
Date
Msg-id 45B92227.9060704@dunslane.net
Whole thread Raw
In response to Re: BUG #2917: spi_prepare doesn't accept typename aliases  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-hackers
Tom Lane wrote:
> Andrew Dunstan <andrew@dunslane.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



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: BUG #2917: spi_prepare doesn't accept typename aliases such as 'integer'
Next
From: Alvaro Herrera
Date:
Subject: Re: autovacuum process handling