Tom Lane wrote:
> Joseph Shraibman <[EMAIL PROTECTED]> writes:
> > Neil Conway wrote:
> >> PostgreSQL (< 7.5) won't consider using an indexscan when the predicate 
> >> involves an integer literal and the column datatype is int2 or int8.
> 
> > Is this fixed for 7.5?  It isn't checked off on the TODO list at
> > http://developer.postgresql.org/todo.php
> 
> It is.  I don't know why Bruce hasn't checked it off.
> 


OK, marked as done:

* -Allow SELECT * FROM tab WHERE int2col = 4 to use int2col index, int8,
  float4, numeric/decimal too
> 
> Some other stuff that needs work in TODO:
> 
> : Bracketed items "[]" have more detailed.
> 
> More detailed what?  Grammar please.

Fixed.  "more detail".

> : * Remove unreferenced table files and temp tables during database vacuum
> :   or postmaster startup (Bruce)
> 
> I'm not sure this is still needed given that we now log file deletion in
> WAL.

OK, removed.

> 
> : * Allow pg_dump to dump sequences using NO_MAXVALUE and NO_MINVALUE
> 
> Seems to be done.


OK.


> 
> : * Prevent whole-row references from leaking memory, e.g. SELECT COUNT(tab.*)
> 
> Done.

OK.

> 
> : * Make LENGTH() of CHAR() not count trailing spaces
> 
> Done.

OK.

> 
> : * Allow SELECT * FROM tab WHERE int2col = 4 to use int2col index, int8,
> :   float4, numeric/decimal too
> 
> Done, per above.

Got it.

> 
> : * Allow more ISOLATION LEVELS to be accepted, but issue a warning for them
> 
> Presently we accept all four with no warning ...

OK.  Warning part removed.

> 
> : * Add GUC setting to make created tables default to WITHOUT OIDS
> 
> Seems to be done, other than the argument about how pg_dump should work.

I did the pg_dump part using SET only where needed.  That is done.

> 
> : * Allow fastpast to pass values in portable format
> 
> This was done in 7.4.


Removed.

> 
> : * Move psql backslash database information into the backend, use nmumonic
> :   commands? [psql]
> 
> Spelling problem...

Fixed.

> 
> : * JDBC
> 
> With JDBC out of the core, I'm not sure why we still have a JDBC section
> in the core TODO.

Removed.  If they want it they can get it from our CVS history.

> : * Have pg_dump -c clear the database using dependency information
> 
> I think this works now.  Not really tested, but in principle it should
> work.

OK.
> 
> : * Cache last known per-tuple offsets to speed long tuple access
> 
> This sounds exactly like attcacheoff, which has been there since
> Berkeley.  Either remove this or fix the description to give some
> idea what's really meant.

Added "adjusting for NULLs and TOAST values.  The issue is that when
NULLs or TOAST is present, those aren't useful.  I was thinking we could
remember the pattern of the previous row and use those offsets if the
TOAST/NULL pattern was the same, or something like that.  Is that a
valid idea?

> : * Automatically place fixed-width, NOT NULL columns first in a table
> 
> This is not ever going to happen, given that we've rejected the idea of
> having separate logical and physical column positions.

Removed.

> 
> : * Change representation of whole-tuple parameters to functions
> 
> Done.  (However, you might want to add something about supporting
> composite types as table columns, which isn't done.)

OK, marked a done, and added new line:

        * Support composite types as table columns

> : * Allow the regression tests to start postmaster with -i so the tests
> :   can be run on systems that don't support unix-domain sockets
> 
> Done long ago.

Removed.


Thanks for the updates!



-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  [EMAIL PROTECTED]               |  (610) 359-1001
  +  If your life is a hard drive,     |  13 Roberts Road
  +  Christ can be your backup.        |  Newtown Square, Pennsylvania 19073

---------------------------(end of broadcast)---------------------------
TIP 3: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to [EMAIL PROTECTED] so that your
      message can get through to the mailing list cleanly

Reply via email to