Richard Huxton wrote:
Karl Denninger wrote:
The problem is that I was holding the ts_vector in a column in the
table with a GIST index on that column. This fails horribly under
8.3; it appears to be ok on the reload but as there is a trigger on
updates any update or insert fails immediately with a data mistype
complaint.
Are you sure you've not got an old definition of tsvector/tsquery or
some such? I've got a tsvector column in a table, updated from a
trigger with a gist index and it's fine. That's all created for 8.3
though, not dumped/restored from 8.2
Quite sure; I just did it "by the book". The simple fix was to get rid
of that and re-write the queries, which I've now done.
Karl Denninger (karl@xxxxxxxxxxxxx)
http://www.denninger.net
---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings
