Horton

Thread

  1. General Bug Report: Handling of quoted identifiers and sequences

    Unprivileged user <nobody> — 1999-03-12T11:02:34Z

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

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