Re: Simplifying identification of temporary tables

Поиск
Список
Период
Сортировка
От Merlin Moncure
Тема Re: Simplifying identification of temporary tables
Дата
Msg-id 6EE64EF3AB31D5448D0007DD34EEB3415C2DA8@Herge.rcsinc.local
обсуждение исходный текст
Ответ на Simplifying identification of temporary tables  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> That would respond to the abstraction concern in a more complete
> fashion.  I thought about that one too, but felt that the ability to
> look at the whole pg_class row (and not only check existence) had some
> value.  Also, I've seen people doing things like
>     ... where relname LIKE 'pattern' and ...
> which still works with the namespace OID function but would not work
> with a does_temp_table_exist() function.  I wouldn't object to doing
> both this and the OID function, though.  Do you have a proposal for
> the exact spelling of the exists() function?

I guess pg_temp_table_exists(text) is the most straightforward.

Merlin


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

Предыдущее
От: David Fetter
Дата:
Сообщение: Re: Toward pg_upgrade
Следующее
От: Simon Riggs
Дата:
Сообщение: Re: [Bizgres-general] A Guide to Constraint Exclusion