Re: [HACKERS] select statement against pg_stats returns - Mailing list pgsql-general

From Christopher Kings-Lynne
Subject Re: [HACKERS] select statement against pg_stats returns
Date
Msg-id 403C1F78.9070308@familyhealth.com.au
Whole thread Raw
In response to Re: select statement against pg_stats returns inconsistent data  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-general
> 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" ones, since it can't easily be fixed without
> initdb.  Reminds me that I need to get to work on making pg_upgrade
> viable again.

Has anyone given any thought as to whether dumping and restoring
pg_statistic is worthwhile?

eg. some sort of ALTER TABLE..SET STATISTICS (1.0, 3.3, 'asdf',....)
command?

Chris


pgsql-general by date:

Previous
From: jack_turer@yahoo.com (jack turer)
Date:
Subject: Re: pg_dump and pg_dumpall fail when trying to backup database
Next
From: "Humble Geek"
Date:
Subject: PLSQL Question regarding multiple inserts