Re: [HACKERS] Beta for 4:30AST ... ? - Mailing list pgsql-hackers

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@pacifier.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@hub.org           secondary: scrappy@{freebsd|postgresql}.org 
> 
> 
> ************
> 


--  Bruce Momjian                        |  http://www.op.net/~candle pgman@candle.pha.pa.us               |  (610)
853-3000+  If your life is a hard drive,     |  830 Blythe Avenue +  Christ can be your backup.        |  Drexel Hill,
Pennsylvania19026