Re: problems restoring a dump : CREATE CAST? (postgis)

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