Re: contrib/lo and restoring databases

Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us> writes:

> Doug McNaught <doug(at)mcnaught(dot)org> writes:
> > pg_restore: creating CAST oid (public.lo)
> > pg_restore: [archiver (db)] could not execute query: ERROR: parser: parse error at or near "." at character 132
> > pg_restore: *** aborted because of error
>
> > This looks like a bug in pg_dump or pg_restore to me.
>
> No, I think the command is perfectly reasonable; the problem is the
> backend parser isn't prepared for a qualified typename in CREATE CAST.
> This is a bug that's fixed in CVS:

Cool, I'll grab the branch tip and give it a shot. Have to upgrade
Bison too but that won't kill me...

Thanks as always for your help!

-Doug