Re: BUG #2917: spi_prepare doesn't accept typename aliases

Поиск
Список
Период
Сортировка
От Andrew Dunstan
Тема Re: BUG #2917: spi_prepare doesn't accept typename aliases
Дата
Msg-id 45B92227.9060704@dunslane.net
обсуждение исходный текст
Ответ на Re: BUG #2917: spi_prepare doesn't accept typename aliases  (Tom Lane <tgl@sss.pgh.pa.us>)
Список 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 по дате отправления:

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: BUG #2917: spi_prepare doesn't accept typename aliases such as 'integer'
Следующее
От: Alvaro Herrera
Дата:
Сообщение: Re: autovacuum process handling