Zdenek Kotala wrote:
> Tom Lane napsal(a):
> >Zdenek Kotala <Zdenek.Kotala@Sun.COM> writes:
> >>I prepared patch which use oid output function instead regproc output.
> >>This change works only for COPY TO command.
> >
> >This is not a bug and we're not going to fix it, most especially not
> >like that.
>
> OK, The behavior of regproc type is described in the documentation, but
> if we don't fix it, than Some error message like "Regproc data type is
> not supported by COPY TO command" could be useful. Because you find that
> something is wrong when you want to restore data back and it should be
> too late.
But it works as "expected". If the approach you suggest would be one we
would take, then it should emit the same error on SELECT as well,
shouldn't we?
I think the problem is that regproc COPY is not useful to you for your
particular use case. But there are workarounds, like the one I
suggested and you promptly ignored.
--
Alvaro Herrera http://www.CommandPrompt.com/
The PostgreSQL Company - Command Prompt, Inc.