Re: [HACKERS] Bug report: PL/pgSQL and mixed case table/field names.

Bruce Momjian wrote:

> Can someone comment on this?
>
> > ============================================================================
> > POSTGRESQL BUG REPORT TEMPLATE
> > ============================================================================
> >
> >
> > Your name : Billy G. Allie
> > Your email address : Bill(dot)Allie(at)mug(dot)org
> > [...]
> >
> > Please enter a FULL description of your problem:
> > ------------------------------------------------
> > PL/pgSQL functions will fail to run if a table with a mixed case name is
> > used/referenced.
> >
> >
> > Please describe a way to repeat the problem. Please try to provide a
> > concise reproducible example, if at all possible:
> > ----------------------------------------------------------------------
> > $ psql mug <test.func
> > CREATE FUNCTION "In_Committees" ("int4" ) RETURNS "text" AS '
> > DECLARE
> > committee_rec "Committees"%ROWTYPE;
> > BEGIN
> > SELECT * INTO committee_rec FROM Committees WHERE CommitteeID = $1;
> > IF NOT FOUND THEN
> > RETURN ''FALSE'';
> > END IF;
> > RETURN ''TRUE'';
> > END;' LANGUAGE 'plpgsql';
> > CREATE
> >
> > select "In_Committees" (2);
> > NOTICE: plpgsql: ERROR during compile of In_Committees near line 2
> > ERROR: parse error at or near """
> > EOF
> > $

Sure :-(

PL/pgSQL's scanner/parser does not handle double quoted
syntax for case mixed object names. Not a real bug, just a
lack. Please add to TODO.

Jan

--

#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#======================================== jwieck(at)debis(dot)com (Jan Wieck) #