Philip Warner ([EMAIL PROTECTED]) reports a bug with a severity of 2
The lower the number the more severe it is.
Short Description
opaque->internal translation required for 7.2 dumps
Long Description
Dumping from 7.2 using 7.3 gives:
CREATE FUNCTION postgis_gist_sel (opaque, oid, opaque, integer) RETURNS double
precision
AS '/var/lib/pgsql7.2.1/lib/contrib/libpostgis.so.0.7', 'postgis_gist_sel'
LANGUAGE "C";
...
CREATE OPERATOR && (
PROCEDURE = geometry_overlap,
LEFTARG = geometry,
RIGHTARG = geometry,
COMMUTATOR = &&,
RESTRICT = postgis_gist_sel,
JOIN = positionjoinsel
);
Which results in the following error:
ERROR: OperatorDef: function postgis_gist_sel(internal, oid, internal, integer) does
not exist
pg_restore: [archiver (db)] could not execute query: ERROR: OperatorDef: function
postgis_gist_sel(internal, oid, internal, integer
) does not exist
This is similar to the problems we had earlier with opaque->internal conversions.
It also highlights another problem: that the full path name of objects is used when
dumping functions. Should this not be installation-relative, if it is in the install
tree?
Sample Code
No file was uploaded with this report
---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to [EMAIL PROTECTED] so that your
message can get through to the mailing list cleanly
