Philip Hallstrom <philip@adhesivemedia.com> writes:
> test=# DROP OPERATOR ~ (NONE, INT2);
> ERROR: RemoveOperator: left unary operator '~' taking 'int2' does not exist
This is fixed in 7.1. I think in 7.0 you'll have to delete the pg_operator
row manually.
regards, tom lane