From 90e0b668a4def471fe4cced06d5ca6605046f828 Mon Sep 17 00:00:00 2001 From: Bruce Momjian Date: Mon, 22 Nov 1999 18:05:47 +0000 Subject: [PATCH] Update TODO list. --- doc/TODO | 24 +++++------ doc/TODO.detail/array | 94 +++++++++++++++++++++++++++++++++++++++++++ 2 files changed, 106 insertions(+), 12 deletions(-) create mode 100644 doc/TODO.detail/array diff --git a/doc/TODO b/doc/TODO index 7d1ed48966..a76adb0425 100644 --- a/doc/TODO +++ b/doc/TODO @@ -1,6 +1,6 @@ TODO list for PostgreSQL ======================== -Last updated: Sat Nov 6 11:54:11 EST 1999 +Last updated: Mon Nov 22 13:02:03 EST 1999 Current maintainer: Bruce Momjian (pgman@candle.pha.pa.us) @@ -25,7 +25,7 @@ RESOURCES PARSER * Disallow inherited columns with the same name as new columns -* INSERT INTO ... SELECT with AS columns matching result columns problem +* -INSERT INTO ... SELECT with AS columns matching result columns problem * SELECT pg_class FROM pg_class generates strange error * Alter TABLE ADD COLUMN does not honor DEFAULT, add CONSTRAINT * Do not allow bpchar column creation without length @@ -36,13 +36,13 @@ PARSER * SELECT foo UNION SELECT foo is incorrectly simplified to SELECT foo * -INSERT ... SELECT ... GROUP BY groups by target columns not source columns(Tom) * -CREATE TABLE test (a char(5) DEFAULT text '', b int4) fails on INSERT(Tom) -* UNION with LIMIT fails +* -UNION with LIMIT fails * Unique index on base column not honored on inserts from inherited table INSERT INTO inherit_table (unique_index_col) VALUES (dup) should fail [inherit] -* 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] +* -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 ... UNION ... ORDER BY fails when sort expr not in result list * Be smarter about promoting types when UNION merges different data types * SELECT ... UNION ... GROUP BY fails if column types disagree @@ -50,7 +50,7 @@ PARSER * -select * from pg_class where oid in (0,-1) * have INTERSECT/EXCEPT prevent duplicates unless ALL is specified * prevent primary key of nine columns [primary] -* SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes +* -SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes * SELECT DISTINCT ON col1 col1 col2 FROM tab1 is broken [distinct] * -require SELECT DISTINCT target list to have all ORDER BY columns * -When using aggregates + GROUP BY, no rows in should yield no rows out(Tom) @@ -82,7 +82,7 @@ URGENT * Add referential integrity(Jan?)[primary] * Add OUTER joins, left and right[outer](Thomas, Bruce) * Allow long tuples by chaining or auto-storing outside db (chaining,large objs) -* Eliminate limits on query length +* -Eliminate limits on query length * Fix memory leak for expressions[memory](Tom?) * -Fix memory leak for aggregates(Tom) @@ -102,7 +102,7 @@ TYPES * Nchar (as distinguished from ordinary varchar), * Domain capability * Add STDDEV/VARIANCE() function for standard deviation computation/variance -* Allow compression of large fields or a compressed field type +* -Allow compression of large fields or a compressed field type * Large objects o Fix large object mapping scheme, own typeid or reltype(Peter) o Allow large text type to use large objects(Peter) @@ -199,14 +199,14 @@ MISC with after-row images(Vadim) [logging](Vadim) * Populate backend status area and write program to dump status data * Make oid use unsigned int more reliably, pg_atoi() -* Allow subqueries in target list +* -Allow subqueries in target list * Put sort files, large objects in their own directory * Do autocommit so always in a transaction block(?) * Show location of syntax error in query [yacc] * Redesign the function call interface to handle NULLs better [function] * Document/trigger/rule so changes to pg_shadow recreate pg_pwd [pg_shadow] * Missing optimizer selectivities for date, r-tree, etc. [optimizer] -* Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup +* -Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup * Overhaul bufmgr/lockmgr/transaction manager * Add PL/Perl(Mark Hollomon) * Make postgres user have a password by default @@ -281,7 +281,7 @@ SOURCE CODE * Add use of 'const' for variables in source tree * Fix C optimizer problem where fmgr_ptr calls return different types [alpha] * -Add needed includes and removed unneeded include files(Bruce) -* Make configure --enable-debug add -g on compile line +* -Make configure --enable-debug add -g on compile line * Does Mariposa source contain any other bug fixes? * Remove SET KSQO option if OR processing is improved(Tom) * rename 'createuser' to 'pg_createuser', and add 'pg_' to other commands diff --git a/doc/TODO.detail/array b/doc/TODO.detail/array new file mode 100644 index 0000000000..4b177e5fdc --- /dev/null +++ b/doc/TODO.detail/array @@ -0,0 +1,94 @@ +From owner-pgsql-hackers@hub.org Wed Nov 25 19:01:02 1998 +Received: from renoir.op.net (root@renoir.op.net [209.152.193.4]) + by candle.pha.pa.us (8.9.0/8.9.0) with ESMTP id TAA16399 + for ; Wed, 25 Nov 1998 19:01:01 -0500 (EST) +Received: from hub.org (majordom@hub.org [209.47.148.200]) by renoir.op.net (o1/$ Revision: 1.18 $) with ESMTP id SAA05250 for ; Wed, 25 Nov 1998 18:53:12 -0500 (EST) +Received: from localhost (majordom@localhost) + by hub.org (8.9.1/8.9.1) with SMTP id SAA17798; + Wed, 25 Nov 1998 18:49:38 -0500 (EST) + (envelope-from owner-pgsql-hackers@hub.org) +Received: by hub.org (TLB v0.10a (1.23 tibbs 1997/01/09 00:29:32)); Wed, 25 Nov 1998 18:49:07 +0000 (EST) +Received: (from majordom@localhost) + by hub.org (8.9.1/8.9.1) id SAA17697 + for pgsql-hackers-outgoing; Wed, 25 Nov 1998 18:49:06 -0500 (EST) + (envelope-from owner-pgsql-hackers@postgreSQL.org) +Received: from mail.enterprise.net (root@mail.enterprise.net [194.72.192.18]) + by hub.org (8.9.1/8.9.1) with ESMTP id SAA17650; + Wed, 25 Nov 1998 18:48:55 -0500 (EST) + (envelope-from olly@lfix.co.uk) +Received: from linda.lfix.co.uk (root@max01-040.enterprise.net [194.72.197.40]) + by mail.enterprise.net (8.8.5/8.8.5) with ESMTP id XAA20539; + Wed, 25 Nov 1998 23:48:52 GMT +Received: from linda.lfix.co.uk (olly@localhost [127.0.0.1]) + by linda.lfix.co.uk (8.9.1a/8.9.1/Debian/GNU) with ESMTP id XAA12089; + Wed, 25 Nov 1998 23:48:52 GMT +Message-Id: <199811252348.XAA12089@linda.lfix.co.uk> +X-Mailer: exmh version 2.0.2 2/24/98 (debian) +X-URL: http://www.lfix.co.uk/oliver +X-face: "xUFVDj+ZJtL_IbURmI}!~xAyPC"Mrk=MkAm&tPQnNq(FWxv49R}\>0oI8VM?O2VY+N7@F- + KMLl*!h}B)u@TW|B}6 +Sender: owner-pgsql-hackers@postgreSQL.org +Precedence: bulk +Status: ROr + +This was reported as a bug with the Debian package of 6.3.2; the same +behaviour is still present in 6.4. + +bray=> create table foo ( t text[]); +CREATE +bray=> insert into foo values ( '{"a"}'); +INSERT 201354 1 +bray=> insert into foo values ( '{"a","b"}'); +INSERT 201355 1 +bray=> insert into foo values ( '{"a","b","c"}'); +INSERT 201356 1 +bray=> select * from foo; +t +------------- +{"a"} +{"a","b"} +{"a","b","c"} +(3 rows) + +bray=> select t[1] from foo; +ERROR: type name lookup of t failed +bray=> select * from foo; +t +------------- +{"a"} +{"a","b"} +{"a","b","c"} +(3 rows) + +bray=> select foo.t[1] from foo; +t +- +a +a +a +(3 rows) + +bray=> select count(foo.t[1]) from foo; +pqReadData() -- backend closed the channel unexpectedly. + +-- +Oliver Elphick Oliver.Elphick@lfix.co.uk +Isle of Wight http://www.lfix.co.uk/oliver + PGP key from public servers; key ID 32B8FAA1 + ======================================== + "Let us therefore come boldly unto the throne of grace, + that we may obtain mercy, and find grace to help in + time of need." Hebrews 4:16 + + + + -- 2.40.0