From: | Pedro Salazar <pedro-b-salazar(at)ptinovacao(dot)pt> |
---|---|
To: | pgsql-admin <pgsql-admin(at)postgresql(dot)org> |
Subject: | problems restoring a dump : CREATE CAST? (postgis) |
Date: | 2003-04-10 11:57:40 |
Message-ID: | 1049975860.1769.40.camel@vitoria.intra.cet.pt |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)ptinovacao(dot)pt
PGP:0E129E31D803BC61
From | Date | Subject | |
---|---|---|---|
Next Message | Pedro Salazar | 2003-04-10 12:16:45 | Re: Windows XP - ODBC |
Previous Message | A.Bhuvaneswaran | 2003-04-10 09:57:43 | Re: HELP please.. |