Re: Proposal: variant of regclass

Поиск
Список
Период
Сортировка
От Tatsuo Ishii
Тема Re: Proposal: variant of regclass
Дата
Msg-id 20131205.102932.2007985347169965826.t-ishii@sraoss.co.jp
обсуждение исходный текст
Ответ на Re: Proposal: variant of regclass  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> Tatsuo Ishii <ishii@sraoss.co.jp> writes:
>> I would like to add a variant of regclass, which is exactly same as
>> current regclass except it does not raise an error when the target
>> table is not found. Instead it returns InvalidOid (0).
> 
> I've sometimes thought we should just make all the reg* input converters
> act that way.  It's not terribly consistent that they'll happily take
> numeric inputs that don't correspond to any existing OID.  And more
> often than not, I've found the throw-an-error behavior to be annoying
> not helpful.
> 
> In any case, -1 for dealing with this only for regclass and not the
> other ones.

I'm happy with changing reg* at the same time. Will come up with the
modified proposal.

Best regards,
--
Tatsuo Ishii
SRA OSS, Inc. Japan
English: http://www.sraoss.co.jp/index_en.php
Japanese: http://www.sraoss.co.jp



В списке pgsql-hackers по дате отправления:

Предыдущее
От: Peter Geoghegan
Дата:
Сообщение: Re: Performance optimization of btree binary search
Следующее
От: Peter Eisentraut
Дата:
Сообщение: Re: Re: [BUGS] BUG #7873: pg_restore --clean tries to drop tables that don't exist