Re: [HACKERS] Beta for 4:30AST ... ?

Should be accurate. I usually make a release list after the feature
freeze/beta starts.

>
> Working on the Release Announcement now ... Bruce, how accurate is the
> current TODO list? If I go through it looking for all items marked as
> '-', I come up with the following list. Is it missing anything? I know
> not *everything* has to be listed, so I'm more afraid of listing something
> that shouldn't then not listing enough ...
>
> The beta1.tar.gz snapshot has been created ... I'll put out an
> announcement later tonight once I've heard back on this list, which also
> gives some of the mirror sites a chance to sync up, and Vince a chance to
> update the web site...
>
> =============================================
> RELIABILITY
>
> RESOURCES
>
> * -Disallow inherited columns with the same name as new columns
> * -Elog() does not free all its memory
> * -spinlock stuck problem when elog(FATAL) and elog(ERROR) inside bufmgr
> * -Recover or force failure when disk space is exhausted(Hiroshi)
>
> PARSER
>
> * -INSERT INTO ... SELECT with AS columns matching result columns problem
> * -Select a[1] FROM test fails, it needs test.a[1](Tom)
> * -Array index references without table name cause problems [array](Tom)
> * -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
> * -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,
> ORDER BY is applied only to the first SELECT
> * -select * from pg_class where oid in (0,-1)
> * -prevent primary key that exceeds max index columns [primary]
> * -SELECT COUNT('asdf') FROM pg_class WHERE oid=12 crashes
> * -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)
> * -Allow HAVING to use comparisons that have no aggregates(Tom)
> * -Allow COUNT(DISTINCT col))(TOm)
>
> VIEWS
>
> * -Views with spaces in view name fail when referenced
>
> MISC
>
> * -User who can create databases can modify pg_database table(Peter E)
> * -Fix btree to give a useful elog when key > 1/2 (page - overhead)(Tom)
> * -pg_dump should preserve primary key information
> * -database names with spaces fail
> * -insert of 0.0 into DECIMAL(4,4) field fails(Tom)
> * -* Interlock to prevent DROP DATABASE on a database with running
> backendsInterlock to prevent DROP DATABASE on a database with running
> backends
>
> ENHANCEMENTS
>
> URGENT
>
> * -Add referential integrity(Jan)[primary]
> * -Eliminate limits on query length
> * -Fix memory leak for aggregates(Tom)
>
> ADMIN
>
> * -Better interface for adding to pg_group(Peter E)
> * -Generate postmaster pid file and remove flock/fcntl lock
> code[flock](Tatsuo)
>
> TYPES
>
> * -Add BIT, BIT VARYING
> * -Allow pg_descriptions when creating tables
> * -Allow pg_descriptions when creating types, columns, and functions
> * -Allow LOCALE to use indexes in regular expression searches(Tom)
> * -Allow array on int8[](Thomas)
> * -Add index on NUMERIC/DECIMAL type(Jan)
> * -Make Absolutetime/Relativetime int4 because time_t can be int8 on some
> ports
> * -Make type equivalency apply to aggregates
>
> INDEXES
>
> * -Permissions on indexes, prevent them(Peter E)
> * -Allow indexing of LIKE with localle character sets
> * -Allow indexing of more than eight columns
>
> COMMANDS
>
> * -Add ALTER TABLE DROP/ALTER COLUMN feature(Peter E)
> * -Move LIKE index optimization handling to the optimizer(Tom)
>
> CLIENTS
>
> * -Allow flag to control COPY input/output of NULLs
> * -Allow psql \copy to allow delimiters
> * -Add a function to return the last inserted oid, for use in psql
> scripts (Peter E)
> * -Allow psql to print nulls as distinct from "" [null]
>
> MISC
>
> * -Certain indexes will not shrink, i.e. oid indexes with many
> inserts(Vadim)
> * -Allow WHERE restriction on ctid(Hiroshi)
> * -Allow PQrequestCancel() to terminate when in waiting-for-lock state
> * -Allow subqueries in target list(Tom)
> * -Document/trigger/rule so changes to pgshadow recreate pgpwd
> [pg_shadow]
> * -Overhaul mdmgr/smgr to fix double unlinking and double opens, cleanup
> * -Add PL/Perl(Mark Hollomon)
> * -Add option for postgres user have a password by default(Peter E)
>
> PERFORMANCE
>
> FSYNC
>
> * -Prevent fsync in SELECT-only queries(Vadim)
>
> INDEXES
>
> * -Convert function(constant) into a constant for index use(Bernard
> Frankpitt)
> * -Make index creation use psort code, because it is now faster(Tom)
> * -Allow creation of sort temp tables > 1 Gig
> * -Create more system table indexes for faster cache lookups
> * -fix indexscan() so it does leak memory by not requiring caller to
> free(Tom)
> * -Improve btbinsrch() to handle equal keys better, remove
> btfirsteq()(Tom)
> * -Allow optimizer to prefer plans that match ORDER BY(Tom)
>
> CACHE
>
> * -elog() flushes cache, try invalidating just entries from current xact,
> perhaps using invalidation cache
>
> MISC
>
> * -Fix memory exhaustion when using many OR's [cnfify](Tom)
> * -Process const = const parts of OR clause in separate pass(Bernard
> Frankpitt)
> * -fix memory leak in cache code when non-existant table is referenced In
> WHERE tab1.x=3 AND tab1.x=tab2.y, add tab2.y=3
> * -pass atttypmod through parser in more cases [atttypmod]
> * -remove duplicate type in/out functions for disk and net
>
> SOURCE CODE
>
> * -Add needed includes and removed unneeded include files(Bruce)
> * -Make configure --enable-debug add -g on compile line
> * -Pre-generate lex and yacc output so not required for install
>
> ==================================================
> On Mon, 21 Feb 2000, Tom Lane wrote:
>
> > Don Baccus <dhogaza(at)pacifier(dot)com> writes:
> > >> Think we'll have to
> > >> leave it unfixed till Thomas gets back.
> >
> > > That would be plenty of time to get it in for the real 7.0 release.
> >
> > I don't like shipping betas with broken pg_dump; that makes life
> > unreasonably difficult for beta testers, if we have to force another
> > initdb before release. So I put in a quick hack solution: don't print
> > the column alias list at all unless there is a table alias. This makes
> > the rule's FROM clause conform to ANSI syntax. If you actually did
> > write
> > create view foo as SELECT alias FROM table table (alias);
> > then it will dump as
> > create view foo as SELECT table.realcolname AS alias FROM table;
> > but there's no harm done. Better solution needed but I'll let Thomas
> > provide it.
> >
> > And now, it's 4:30 PM AST and we are outta here ... right Marc?
> >
> > regards, tom lane
> >
>
> Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy
> Systems Administrator @ hub.org
> primary: scrappy(at)hub(dot)org secondary: scrappy(at){freebsd|postgresql}.org
>
>
> ************
>

--
Bruce Momjian | http://www.op.net/~candle
pgman(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