General Bug Report: Handling of quoted identifiers and sequences

From: Unprivileged user <nobody>
To: pgsql-bugs(at)postgresql(dot)org
Subject: General Bug Report: Handling of quoted identifiers and sequences
Date: 1999-03-12 11:02:34
Message-ID: 199903121102.GAA92292@hub.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


============================================================================
POSTGRESQL BUG REPORT TEMPLATE
============================================================================

Your name : Stefan Wehner
Your email address : wehner(at)digital-security(dot)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

--------------------------------------------------------------------------

Browse pgsql-bugs by date

  From Date Subject
Next Message Unprivileged user 1999-03-12 11:08:07 General Bug Report: Handling of quoted identifiers and sequences
Previous Message FRANCOIS 1999-03-10 15:44:32 gmake: *** [all] Error 2