Re: [HACKERS] memory destruction in 6.4u

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