Re: [HACKERS] Re: TODO updates

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

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