Thread
-
Update Open Items list
Bruce Momjian <maillist@candle.pha.pa.us> — 1999-05-12T12:55:37Z
Some items completed and removed. --------------------------------------------------------------------------- Default of '' causes crash in some cases shift/reduce conflict in grammar, SELECT ... FOR [UPDATE|CURSOR] create table "AA" ( x int4 , y serial ); insert into "AA" (x) values (1); fails SELECT 1; SELECT 2 fails when sent not via psql, semicolon problem SELECT * FROM test WHERE test IN (SELECT * FROM test) fails with strange error CREATE OPERATOR *= (leftarg=_varchar, rightarg=varchar, procedure=array_varchareq); fails, varchar is reserved word, quotes work CLUSTER failure if vacuum has not been performed in a while Improve Subplan list handling Allow Subplans to use efficient joins(hash, merge) with upper variable Improve NULL parameter passing into functions Table with an element of type inet, will show "0.0.0.0/0" as "00/0" When creating a table with either type inet or type cidr as a primary,unique key, the "198.68.123.0/24" and "198.68.123.0/27" are considered equal Allow ESCAPE '\' at the end of LIKE for ANSI compliance, or rewrite the LIKE handling by rewriting the user string with the supplied ESCAPE Fix leak for expressions?, aggregates? Improve LIMIT processing by using index to limit rows processed Allow "col AS name" to use name in WHERE clause? Is this ANSI? Works in GROUP BY Update reltuples from COPY command nodeResults.c and parse_clause.c give compiler warnings Move LIKE index optimization handling to the optimizer? MVCC locking, deadlock, priorities? Make sure pg_internal.init generation can't cause unreliability SELECT ... WHERE col ~ '(foo|bar)' works, but CHECK on table always fails CREATE INDEX zman_index ON test (date_trunc( 'day', zman ) datetime_ops) fails index can't store constant parameters, allow SQL function indexes? Have hashjoins use portals, not fixed-size memory DROP TABLE leaves INDEX file descriptor open ALTER TABLE ADD COLUMN to inherited table put column in wrong place resno's, sublevelsup corrupt when reaching rewrite system crypt_loadpwdfile() is mixing and (mis)matching memory allocation protocols, trying to use pfree() to release pwd_cache vector from realloc() 3 = sum(x) in rewrite system is a problem Do we want pg_dump -z to be the default? pg_dump of groups fails pg_dump -o -D does not work, and can not work currently, generate error? pg_dump does not preserver NUMERIC precision, psql \d should show precision dumping out sequences should not be counted in pg_dump display CREATE VIEW ignores DISTINCT? ORDER BY mixed with DISTINCT causes duplicates CREATE TABLE t1 (a int4, b int4); CREATE VIEW v1 AS SELECT b, count(b) FROM t1 GROUP BY b; SELECT count FROM v1; fails Markup sql.sgml, Stefan's intro to SQL Markup cvs.sgml, cvs and cvsup howto Add figures to sql.sgml and arch-dev.sgml, both from Stefan Include Jose's date/time history in User's Guide (neat!) Generate Admin, User, Programmer hardcopy postscript DROP TABLE/RENAME TABLE doesn't remove extended files, *.1, *.2 Multi-segment indexes? Vacuum of tables >2 gigs - NOTICE: Can't truncate multi-segments relation Make Serial its own type? Add support for & operator store binary-compatible type information in the system somewhere add ability to add comments to system tables using table/colname combination process const=const parts of OR clause in separate pass make oid use oidin/oidout not int4in/int4out in pg_type.h, make oid use unsigned int more reliably, pg_atoi() -- Bruce Momjian | http://www.op.net/~candle maillist@candle.pha.pa.us | (610) 853-3000 + If your life is a hard drive, | 830 Blythe Avenue + Christ can be your backup. | Drexel Hill, Pennsylvania 19026
-
Re: [HACKERS] Update Open Items list
Thomas Lockhart <lockhart@alumni.caltech.edu> — 1999-05-12T14:19:09Z
> create table "AA" ( x int4 , y serial ); insert into "AA" (x) values (1); fails I see the "AA" problem, and was just working in that code. Will look at it. > SELECT 1; SELECT 2 fails when sent not via psql, semicolon problem I'm almost certain that this is from changes introduced by Stefan's EXCEPT patches. There are some rules in gram.y which handle multiple statements, and he commented them out to get rid of shift/reduce conflicts he introduced :( - Thomas -- Thomas Lockhart lockhart@alumni.caltech.edu South Pasadena, California -
Re: [HACKERS] Update Open Items list
Jan Wieck <jwieck@debis.com> — 1999-05-12T15:29:14Z
> CREATE VIEW ignores DISTINCT? Will not be fixed in v6.5. I'll add an elog(ERROR, ...) to reject those view definitions during CREATE VIEW. > CREATE TABLE t1 (a int4, b int4); CREATE VIEW v1 AS SELECT b, count(b) > FROM t1 GROUP BY b; SELECT count FROM v1; fails Fixed. SELECT b FROM v1; still fails with ERROR: union_planner: query is marked hasAggs, but I don't see any Must adjust hasAggs as final step in rewriter. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) # -
Re: [HACKERS] Update Open Items list
Jan Wieck <jwieck@debis.com> — 1999-05-12T17:04:00Z
> > > CREATE VIEW ignores DISTINCT? > > Will not be fixed in v6.5. I'll add an elog(ERROR, ...) to > reject those view definitions during CREATE VIEW. Done. > > > CREATE TABLE t1 (a int4, b int4); CREATE VIEW v1 AS SELECT b, count(b) > > FROM t1 GROUP BY b; SELECT count FROM v1; fails > > Fixed. > > SELECT b FROM v1; still fails with > > ERROR: union_planner: query is marked hasAggs, but I don't see any > > Must adjust hasAggs as final step in rewriter. Done. Jan -- #======================================================================# # It's easier to get forgiveness for being wrong than for being right. # # Let's break this rule - forgive me. # #======================================== jwieck@debis.com (Jan Wieck) #