Обсуждение: problems restoring a dump : CREATE CAST? (postgis)

Greetings,

I'm using postgis functions in my database, and I'm getting errors
restoring the database. I already identified the line problems, and it
can reproduced just creating a database and running the postgis.sql
procedures.

The following statements are taken from the postgis.sql file, and they
work just fine when running it:

CREATE CAST ( chip AS geometry ) WITH FUNCTION geometry(chip) AS
IMPLICIT;
CREATE CAST ( geometry AS box3d ) WITH FUNCTION box3d(geometry) AS
IMPLICIT;
CREATE CAST ( geometry AS box ) WITH FUNCTION box(geometry) AS IMPLICIT;
CREATE CAST ( box3d AS geometry ) WITH FUNCTION geometry(box3d) AS
IMPLICIT;
CREATE CAST ( text AS geometry) WITH FUNCTION geometry(text) AS
IMPLICIT;
CREATE CAST ( wkb AS bytea ) WITH FUNCTION bytea(wkb) AS IMPLICIT;
CREATE CAST ( box3d AS box ) WITH FUNCTION box3dtobox(box3d);

The following lines are the errors I'm getting when restoring the dump
file:
ERROR:  parser: parse error at or near "." at character 20
ERROR:  parser: parse error at or near "." at character 20
ERROR:  parser: parse error at or near "." at character 20
ERROR:  parser: parse error at or near "." at character 20
ERROR:  parser: parse error at or near "." at character 28
ERROR:  parser: parse error at or near "." at character 20
ERROR:  parser: parse error at or near "." at character 20

The lines below are the statements in the dump file that I think are
throwing that errors:

--
-- TOC entry 217 (OID 21062)
-- Name: gist_geometry_ops; Type: OPERATOR CLASS; Schema: public; Owner:
postgres
--
--
-- TOC entry 218 (OID 21038)
-- Name: geometry (public.chip); Type: CAST; Schema: public; Owner:
--
CREATE CAST (public.chip AS public.geometry) WITH FUNCTION geometry
(public.chip) AS IMPLICIT;

--
-- TOC entry 219 (OID 21039)
-- Name: box3d (public.geometry); Type: CAST; Schema: public; Owner:
--
CREATE CAST (public.geometry AS public.box3d) WITH FUNCTION box3d
(public.geometry) AS IMPLICIT;

--
-- TOC entry 220 (OID 21040)
-- Name: box (public.geometry); Type: CAST; Schema: public; Owner:
--
CREATE CAST (public.geometry AS box) WITH FUNCTION box (public.geometry)
AS IMPLICIT;

--
-- TOC entry 221 (OID 21041)
-- Name: geometry (public.box3d); Type: CAST; Schema: public; Owner:
--
CREATE CAST (public.box3d AS public.geometry) WITH FUNCTION geometry
(public.box3d) AS IMPLICIT;

--
-- TOC entry 222 (OID 21042)
-- Name: geometry (text); Type: CAST; Schema: public; Owner:
--
CREATE CAST (text AS public.geometry) WITH FUNCTION geometry (text) AS
IMPLICIT;

--
-- TOC entry 223 (OID 21043)
-- Name: bytea (public.wkb); Type: CAST; Schema: public; Owner:
--
CREATE CAST (public.wkb AS bytea) WITH FUNCTION bytea (public.wkb) AS
IMPLICIT;

--
-- TOC entry 224 (OID 21044)
-- Name: box3dtobox (public.box3d); Type: CAST; Schema: public; Owner:
--
CREATE CAST (public.box3d AS box) WITH FUNCTION box3dtobox
(public.box3d);


Please, anyone had reproduced these errors? What it means? Is there a
workaround? Can I dump just schema tables and data from a specified
schema that could avoids me restore the public postgis functions/tables,
doing it manually before? (could be a possible workaround... no?)


thanks,
Pedro Salazar.
--
PS
pedro-b-salazar@ptinovacao.pt
PGP:0E129E31D803BC61

Hi,

I forgot to mention that I'm using Postgresql 7.3.2 and Postgis 0.7.4.

regards,
Pedro Salazar.

On Thu, 2003-04-10 at 12:57, Pedro Salazar wrote:
> Greetings,
>
> I'm using postgis functions in my database, and I'm getting errors
> restoring the database. I already identified the line problems, and it
> can reproduced just creating a database and running the postgis.sql
> procedures.
>
> The following statements are taken from the postgis.sql file, and they
> work just fine when running it:
(...)
> The following lines are the errors I'm getting when restoring the dump
> file:
(...)
> The lines below are the statements in the dump file that I think are
> throwing that errors:
>
(...)
> Please, anyone had reproduced these errors? What it means? Is there a
> workaround? Can I dump just schema tables and data from a specified
> schema that could avoids me restore the public postgis functions/tables,
> doing it manually before? (could be a possible workaround... no?)

--
PS
pedro-b-salazar@ptinovacao.pt
PGP:0E129E31D803BC61

Pedro Salazar <pedro-b-salazar@ptinovacao.pt> writes:
> The following lines are the errors I'm getting when restoring the dump
> file:
> ERROR:  parser: parse error at or near "." at character 20

This is a backend bug --- the grammar isn't prepared to accept qualified
type names in CREATE CAST.  There is a fix in CVS for 7.3.3, or for the
moment you could just edit out "public." in the dump's CREATE CAST
commands.

            regards, tom lane