On 3 October 2016 at 14:12, Tom Lane <t...@sss.pgh.pa.us> wrote: > Benedikt Grundmann <bgrundm...@janestreet.com> writes: > > I just tried this again. This time from 9.2.17 to 9.5.4 and pg_upgrade > > chokes with this: > > > > [root@igm-dbc-001 upgrade-logs]# tail pg_upgrade_dump_16416.log > > pg_restore: [archiver (db)] could not execute query: ERROR: syntax error > > at or near "=>" > > LINE 1: CREATE OPERATOR => ( > > ^ > > Command was: CREATE OPERATOR => ( > > PROCEDURE = "tconvert", > > LEFTARG = "text", > > RIGHTARG = "text" > > ); > > You're going to need to manually drop that operator from the source > database, as "=>" isn't a legal operator name anymore. This appears > to be left over from a pre-9.0 version of hstore. > > regards, tom lane >
Thanks for the quick reply. How do I do that however? Without dropping the extension itself that is: postgres=# select * from pg_operator where oprname = '=>'; (0 rows) postgres=# \c proddb_testing psql (9.5.4, server 9.2.17) You are now connected to database "proddb_testing" as user "as-proddb". proddb_testing=# select * from pg_operator where oprname = '=>'; -[ RECORD 1 ]+--------- oprname | => oprnamespace | 2200 oprowner | 10 oprkind | b oprcanmerge | f oprcanhash | f oprleft | 25 oprright | 25 oprresult | 144920 oprcom | 0 oprnegate | 0 oprcode | tconvert oprrest | - oprjoin | - proddb_testing=# drop operator => (text, text); ERROR: cannot drop operator =>(text,text) because extension hstore requires it HINT: You can drop extension hstore instead. Is it possible that I need to do some form of hstore extension upgrade dance?
