Added to TODO:
* views with spaces in view name fail when referenced
> Tatsuo Ishii wrote:
> >
> > While investigating a user's complaint, I have found some memory
> > destructions in 6.4 source using purify.
> >
> > (1) parser/gram.y:fmtId()
> >
> > It writes n+3 bytes into n+1 byte-long memory area if mixed case or
> > non-ascii identifiers given.
>
> Could that be also the cause for the two bugs that I have been reported
> some time ago occuring when object names contain spaces ?
>
> PostgreSQL 6.4 on RedHat Linux i386, 2.0.36 Kernel
>
> THE FIRST ONE
> =============
> test=>create table students (id int4, name text);
> CREATE
> test=> create view "my view" as select * from students;
> CREATE
> test=> select * from "my view";
> ERROR: nodeRead: Bad type 0
>
>
> THE SECOND ONE
> ==============
> test=> create sequence student_id;
> CREATE
> test=> create table "my students" (id int4 default
> nextval('student_id'), name text);
> ERROR: my: Table does not exist.
>
> --
> Constantin Teodorescu
> FLEX Consulting Braila, ROMANIA
>
>
-- 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,
Pennsylvania19026