John Scalia <jayknowsunix@xxxxxxxxx> writes: > You are correct, though, Tom, that the hstore extension is 1.1. Is there > some other, not =>, construct I should be using? The hstore(text,text) function replaces that. > Curiously, I just checked > my personal sandbox database (9.5) and the hstore there is 1.3, but like I > said earlier the update succeeds on that one. That's pretty hard to believe, because 9.5 disallows => as an operator name altogether. I still suspect that you have got a search path problem. You might try, eg, "\do ||" in psql and see whether hstore || is listed or not. Also check which schema \dx says the hstore extension is in in each database. regards, tom lane -- Sent via pgsql-admin mailing list (pgsql-admin@xxxxxxxxxxxxxx) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-admin