Postgres Pro
Downloads
Home   >   mailing lists

Re: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions - Mailing list pgsql-general

From Tom Lane
Subject Re: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions
Date
Msg-id 7060.974996008@sss.pgh.pa.us
Whole thread Raw
In response to Enum type emulation: problem with opaque type in PL/pgSQL functions  (Max Fonin <fonin@ziet.zhitomir.ua>)
Responses Re: [HACKERS] Enum type emulation: problem with opaque type in PL/pgSQL functions  (Max Fonin <fonin@ziet.zhitomir.ua>)
List pgsql-general
Tree view 
Max Fonin <fonin@ziet.zhitomir.ua> writes:
> I guess the problem is that PL/pgSQL doesn't handle opaque type correctly.

No it doesn't, which is not surprising considering that opaque isn't
really a type at all.  The error message could be improved though :-(

Currently I believe that the only way to write datatype I/O routines
is to do it in C, because what they really need to deal in is C-style
strings, and those are not an SQL-level type.

            regards, tom lane

pgsql-general by date:

Previous
From: "Pankaj Soni"
Date:
Subject: Pro. Regarding Arrays.
Next
From: Peter Eisentraut
Date:
Subject: Re: can't get user authentication to work - HELP!