Keith Hayden <keith.c.hayden@xxxxxxxxxxxxxx> 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@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
