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

From: Bruce Momjian <maillist(at)candle(dot)pha(dot)pa(dot)us>
To: Stefan Wehner <wehner(at)digital-security(dot)com>
Cc: pgsql-bugs(at)postgreSQL(dot)org
Subject: Re: [BUGS] General Bug Report: Handling of quoted identifiers and sequences
Date: 1999-07-07 02:20:38
Message-ID: 199907070220.WAA00472@candle.pha.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

> 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(at)candle(dot)pha(dot)pa(dot)us | (610) 853-3000
+ If your life is a hard drive, | 830 Blythe Avenue
+ Christ can be your backup. | Drexel Hill, Pennsylvania 19026

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Bruce Momjian 1999-07-07 18:10:03 Re: [BUGS] General Bug Report: GROUP BY with NULL not done properly(Oracle8 & DB/2 do this completely different)
Previous Message B. Prashanth 1999-07-05 04:43:28 Query