Thread: fix pl/pgsql %type bug

fix pl/pgsql %type bug

From
Neil Conway
Date:
This patch fixes a bug with the new-in-7.3 support for schema-qualified
names for %TYPE variables in PL/PgSQL: the function that parses them
never calls plgsql_convert_ident(), so it will not work for any
identifier name that has double-quotes or mixed-case letters.

Unless anyone sees a problem, please apply this patch to both
REL7_3_STABLE and HEAD.

Cheers,

Neil
--
Neil Conway <neilc@samurai.com> || PGP Key ID: DB3C29FC



Attachment

Re: fix pl/pgsql %type bug

From
Tom Lane
Date:
Neil Conway <neilc@samurai.com> writes:
> This patch fixes a bug with the new-in-7.3 support for schema-qualified
> names for %TYPE variables in PL/PgSQL: the function that parses them
> never calls plgsql_convert_ident(), so it will not work for any
> identifier name that has double-quotes or mixed-case letters.

Patch applied, thanks!

            regards, tom lane