Re: TODO updates - Mailing list pgsql-hackers

From Bruce Momjian
Subject Re: TODO updates
Date
Msg-id 199911221803.NAA06011@candle.pha.pa.us
Whole thread Raw
In response to TODO updates  (Tom Lane <tgl@sss.pgh.pa.us>)
Responses Re: [HACKERS] Re: TODO updates  (The Hermit Hacker <scrappy@hub.org>)
List pgsql-hackers
> The following TODO items seem to be taken care of in current sources,
> but aren't marked done in TODO:

Thanks. I have trouble figuring out which fixes I hear about go with
which items.  I also forget they are on there.


> 
> PARSER
> 
> * INSERT INTO ... SELECT with AS columns matching result columns problem
> * UNION with LIMIT fails
> * CREATE TABLE x AS SELECT 1 UNION SELECT 2 fails
> * CREATE TABLE test(col char(2) DEFAULT user) fails in length restriction
> * mismatched types in CREATE TABLE ... DEFAULT causes problems [default]
> * SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes

Thanks.  Done.

> 
> URGENT
> 
> * Eliminate limits on query length
> 
> (Not quite done, but close enough to put a dash on it...)

Marked.

> 
> TYPES
> 
> * Allow compression of large fields or a compressed field type
> 
> Jan just created a compressed text type, so this is partly done.
> We speculated a little about adding a lower-level mechanism that would
> compress whole tuples, so maybe this item should be replaced by one
> mentioning that idea (it wouldn't belong in the TYPES section though).

Marked.  Let someone ask for tuple compression.

> 
> MISC
> 
> * Allow subqueries in target list

Marked.

> 
> * Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup
> 
> Is this one done, or do we still have issues there?  I think it's a lot
> better than it used to be, anyway...

Marked.

> 
> SOURCE CODE
> 
> * Make configure --enable-debug add -g on compile line

Marked.

Thanks.  Updated.

--  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
 


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: System cache index cleanup
Next
From: Lamar Owen
Date:
Subject: Re: [HACKERS] Re: postgres RPM build on Suse linux 6.2