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:08:07 |
Message-ID: | 199903121108.GAA92873@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
--------------------------------------------------------------------------
From | Date | Subject | |
---|---|---|---|
Next Message | Bruce Momjian | 1999-03-14 18:19:27 | Re: [BUGS] SQL optimisation dead loop |
Previous Message | Unprivileged user | 1999-03-12 11:02:34 | General Bug Report: Handling of quoted identifiers and sequences |