============================================================================
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
--------------------------------------------------------------------------