Re: [HACKERS] [GENERAL] select statement against pg_stats returns inconsistent data

2004-02-24 Thread Tom Lane
Christopher Kings-Lynne <[EMAIL PROTECTED]> writes: > Has anyone given any thought as to whether dumping and restoring > pg_statistic is worthwhile? Why? You can reconstruct it with a simple "ANALYZE" command. Dumping and restoring would mean nailing down cross-version assumptions about what it

Re: [HACKERS] [GENERAL] select statement against pg_stats returns inconsistent data

2004-02-24 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > anyarray has been defined this way since 7.3 -- any concerns there? I don't think so --- we weren't trying to use it as an actual column datatype back then. 7.4 has a problem though :-( ... this is one of the "damn I wish we'd caught that before release" o

Re: [HACKERS] [GENERAL] select statement against pg_stats returns inconsistent data

2004-02-24 Thread Tom Lane
Shelby Cain <[EMAIL PROTECTED]> writes: > The select statements return different data for > most_commons_vals depending on whether n_distinct is > included in the select clause or not. > I only seem to get the behavior below against int8 > columns - but I haven't interated through every > conceivab