TODO updates - Mailing list pgsql-hackers

From Tom Lane
Subject TODO updates
Date
Msg-id 24622.943286411@sss.pgh.pa.us
Whole thread Raw
Responses Re: TODO updates
List pgsql-hackers
The following TODO items seem to be taken care of in current sources,
but aren't marked done in TODO:

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

URGENT

* Eliminate limits on query length

(Not quite done, but close enough to put a dash on it...)

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

MISC

* Allow subqueries in target list

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

SOURCE CODE

* Make configure --enable-debug add -g on compile line
        regards, tom lane


pgsql-hackers by date:

Previous
From: Bruce Momjian
Date:
Subject: Re: [HACKERS] cache question
Next
From: Zeugswetter Andreas SEV
Date:
Subject: AW: [HACKERS] psql & regress tests