Re: How to update stavaluesN columns in pg_statistics (type anyarry)

Keith Hayden <keith(dot)c(dot)hayden(at)googlemail(dot)com> writes:
> I tried the following:
> update pg_type set typalign = 'd' where typname = 'int4'

Not int4, _int4 (that is, array of int4).

> then
> update pg_statistic set stavalues1 = array[1,10,20,30,40,50,60,70,80,90,100]
> where starelid = 24751

> this failed with:
> ERROR: table row type and query-specified row type do not match
> DETAIL: Table has type anyarray at ordinal position 18, but query expects
> integer[].

Yeah, I remember hitting that too but I don't recall what I did about
it. I was in a hurry and only looking for a one-off solution, so I
might've just removed that error check from my working build :-(

regards, tom lane