On 3 October 2016 at 14:12, Tom Lane <tgl@xxxxxxxxxxxxx> wrote:
Benedikt Grundmann <bgrundmann@xxxxxxxxxxxxxx> 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?
