General Bug Report: Handling of quoted identifiers and sequences
============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================
Your name : Stefan Wehner
Your email address : wehner@digital-security.com
Category : runtime: back-end: SQL
Severity : serious
Summary: Handling of quoted identifiers and sequences
System Configuration
--------------------
Operating System : Linux 2.0.36
PostgreSQL version : 6.4.2
Compiler used : gcc
Hardware:
---------
Versions of other tools:
------------------------
--------------------------------------------------------------------------
Problem Description:
--------------------
Quoted Identifiers will not work with sequences
This includes SERIAL !
--------------------------------------------------------------------------
Test Case:
----------
create table "AA" ( x int4 , y serial );
insert into "AA" (x) values (1);
--------------------------------------------------------------------------
Solution:
---------
in src/backend/parser/parse_function.c there is the
handling routine for nextval etc.
there is an unconditional lowercasing there that will need
to be fixed for quoted identifiers
--------------------------------------------------------------------------
Problem Description:
--------------------
Quoted Identifiers will not work with sequences
This includes SERIAL !--------------------------------------------------------------------------
Test Case:
----------
create table "AA" ( x int4 , y serial );
insert into "AA" (x) values (1);--------------------------------------------------------------------------
Solution:
---------
in src/backend/parser/parse_function.c there is the
handling routine for nextval etc.
there is an unconditional lowercasing there that will need
to be fixed for quoted identifiers
This was fixed in 6.5.
--
Bruce Momjian | http://www.op.net/~candle
maillist@candle.pha.pa.us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026