Keith Hayden <keith.c.hay...@googlemail.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
--
Sent via pgsql-general mailing list (pgsql-general@postgresql.org)
To make changes to your subscription:
http://www.postgresql.org/mailpref/pgsql-general
