Re: vacuum and row type - Mailing list pgsql-hackers

From Teodor Sigaev
Subject Re: vacuum and row type
Date
Msg-id 4DE7B956.1010803@sigaev.ru
Whole thread Raw
In response to Re: vacuum and row type  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: vacuum and row type
List 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 by date:

Previous
From: Tom Lane
Date:
Subject: Re: Please test peer (socket ident) auth on *BSD
Next
From: Robert Haas
Date:
Subject: Re: pgpool versus sequences