From: | "Billy G(dot) Allie" <Bill(dot)Allie(at)mug(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Cc: | pgsql-hackers(at)postgresql(dot)org, jwieck(at)debis(dot)com |
Subject: | Bug report: PL/pgSQL and mixed case table/field names. |
Date: | 1998-12-03 01:56:25 |
Message-ID: | 199812030156.UAA28335@bgalli.mug.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Billy G. Allie
Your email address : Bill(dot)Allie(at)mug(dot)org
System Configuration
---------------------
Architecture (example: Intel Pentium) : Intel i486DX2
Operating System (example: Linux 2.0.26 ELF) : UnixWare 7.0.1
PostgreSQL version (example: PostgreSQL-6.4) : PostgreSQL-6.4
Compiler used (example: gcc 2.8.0) : Optimizing C Compilation Sys.
(CCS) 3.2 08/18/98 (u701)
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
$
If you know how this problem might be fixed, list the solution below:
---------------------------------------------------------------------
--
____ | Billy G. Allie | Domain....: Bill(dot)Allie(at)mug(dot)org
| /| | 7436 Hartwell | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie(at)email(dot)msn(dot)com
|/ |LLIE | (313) 582-1540 |
--
____ | Billy G. Allie | Domain....: Bill(dot)Allie(at)mug(dot)org
| /| | 7436 Hartwell | Compuserve: 76337,2061
|-/-|----- | Dearborn, MI 48126| MSN.......: B_G_Allie(at)email(dot)msn(dot)com
|/ |LLIE | (313) 582-1540 |
From | Date | Subject | |
---|---|---|---|
Next Message | John Polstra | 1998-12-03 02:24:33 | Re: New Linux/libc5 CVSup client |
Previous Message | Tatsuo Ishii | 1998-12-03 01:35:33 | Re: [HACKERS] Questions on using multi-byte character in a field of a table (BIG5) |