Re: [HACKERS] Re: TODO updates - Mailing list pgsql-hackers

one of the things I remember seeing discussed, and wonder about current
status on:
removal of the whole pg_vlock requirement on vacuum?

last I recall, MVCC eliminated that requirement, and also made it easier
to do a vacuum on 'live tables'?

On Mon, 22 Nov 1999, Bruce Momjian wrote:

> > 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, Pennsylvania 19026
> 
> ************
> 

Marc G. Fournier                   ICQ#7615664               IRC Nick: Scrappy
Systems Administrator @ hub.org 
primary: scrappy@hub.org           secondary: scrappy@{freebsd|postgresql}.org