<html>
<head>
</head>
<body>Hallo<br />
<br />
I guess this is a postgresql issue, but wanted to check here first.<br />
<br />
The function REASSIGN OWNED <br />
http://www.postgresql.org/docs/8.4/interactive/sql-reassign-owned.html<br />
<br />
returns error when PostGIS is installed. I found that it is the operator classes and operator familys giving the error.<br />
<br />
the operator classes gives:<br />
ERROR: unexpected classid 2616<br />
<br />
and the operator families gives:<br />
ERROR: unexpected classid 2753<br />
<br />
There is no problem to change the owner by altering the objects, so if I want to assign all objects to user postgres and first run:<br />
<br />
<br />
ALTER OPERATOR CLASS btree_geography_ops USING btree OWNER TO postgres;<br />
ALTER OPERATOR CLASS btree_geometry_ops USING btree OWNER TO postgres;<br />
ALTER OPERATOR CLASS gist_geography_ops USING gist OWNER TO postgres; <br />
ALTER OPERATOR CLASS gist_geometry_ops USING gist OWNER TO postgres;<br />
<br />
ALTER OPERATOR FAMILY btree_geography_ops USING btree OWNER TO postgres;<br />
ALTER OPERATOR FAMILY btree_geometry_ops USING btree OWNER TO postgres;<br />
ALTER OPERATOR FAMILY gist_geography_ops USING gist OWNER TO postgres; <br />
ALTER OPERATOR FAMILY gist_geometry_ops USING gist OWNER TO postgres;<br />
<br />
then I can run :<br />
<br />
REASSIGN OWNED BY nicklas TO postgres;<br />
<br />
without any errors.<br />
<br />
I have only tried this with <br />
postgresql 8.4.4<br />
<br />
with PostGIS 1.5.1<br />
<br />
Is it a postgresql problem solely? What makes me wonder is that I tried a few searches with google and didn't get anything about it at a first sight. If it is postgresql I expect to find it mentioned all over internet, but I on't understand how it could be a postgis problem either.<br />
<br />
I will also put a ticket about that we are not droping the operator families with postgis_uninstall.sql<br />
<br />
Thanks<br />
Nicklas<br />
<br />
</body>
</html>