problems restoring a dump : CREATE CAST? (postgis)

Поиск
Список
Период
Сортировка
От Pedro Salazar
Тема problems restoring a dump : CREATE CAST? (postgis)
Дата
Msg-id 1049975860.1769.40.camel@vitoria.intra.cet.pt
обсуждение исходный текст
Ответы Re: problems restoring a dump : CREATE CAST? (postgis)  (Pedro Salazar <pedro-b-salazar@ptinovacao.pt>)
Re: problems restoring a dump : CREATE CAST? (postgis)  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-admin
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


В списке pgsql-admin по дате отправления:

Предыдущее
От: "A.Bhuvaneswaran"
Дата:
Сообщение: Re: HELP please..
Следующее
От: Pedro Salazar
Дата:
Сообщение: Re: Windows XP - ODBC