Обсуждение: General Bug Report: Handling of quoted identifiers and sequences

Поиск
Список
Период
Сортировка

General Bug Report: Handling of quoted identifiers and sequences

От
Unprivileged user
Дата:
============================================================================
                        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

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

Re: [BUGS] General Bug Report: Handling of quoted identifiers and sequences

От
Bruce Momjian
Дата:
> 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