Thread: 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