Re: vacuum and row type

Поиск
Список
Период
Сортировка
От Teodor Sigaev
Тема Re: vacuum and row type
Дата
Msg-id 4DE7B956.1010803@sigaev.ru
обсуждение исходный текст
Ответ на Re: vacuum and row type  (Tom Lane <tgl@sss.pgh.pa.us>)
Ответы Re: vacuum and row type  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-hackers
> I think we could just let this code assume success for type RECORD.  It
> won't affect VACUUM/ANALYZE, since there are (for reasons that should
> now be obvious) no table or index columns of anonymous composite types.
Of course, it's impossible to store anonymous composite type anywhere, but
we still have possibility to use it in ORDER BY at least, following query works 
on HEAD but fails with patch:

select ROW(1, n) as r from generate_series(1,5) as n order by r;


> What I was thinking last night is that it'd be smart to move all this
> logic into the typcache, instead of repeating all the work each time we

Agree

-- 
Teodor Sigaev                                   E-mail: teodor@sigaev.ru
  WWW: http://www.sigaev.ru/
 


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

Предыдущее
От: Tom Lane
Дата:
Сообщение: Re: Please test peer (socket ident) auth on *BSD
Следующее
От: Robert Haas
Дата:
Сообщение: Re: pgpool versus sequences