I'm going to be on vacation for essentially the next month. So if there's
anything that you'd like fixed before that, now's a good time to tell.


Meanwhile a few TODO updates:

* Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME(Thomas)

Looks obsolete to me. (Reltime indexes still don't work, but I doubt
someone needs them.)

* -More access control over who can create tables and use locks(Karal)

Not done, and it's "Karel".

* Test syslog functionality
* Unify configuration into one configuration file (Peter E)
* use setproctitle() if it exists for 'ps' display of status

All done

* Add hash for int8

Seems to work (Tom Lane?)

* BSD/OS does not support locale because there is no LC_MESSAGES

Done

* Add ALTER TABLE DROP/ALTER COLUMN feature(Peter E) [drop]

`ALTER TABLE ALTER COLUMN' was implemented for 7.0. I am not working on
the DROP COLUMN part, so you might want to remove my name.

* Allow DELETE and UPDATE to use inheritance using tablename*

Chris Bitmead's contributions accomplish that (though not how it's written
here).


There seem to be some duplicate items:

* Some database schema's are not dumpable;  do dumps in oid order
* make pg_dump dump in oid order, so dependencies are resolved

* Allow nulls in arrays
* Allow arrays to hold NULL elements


See y'all in beta... :-)


-- 
Peter Eisentraut                  Sernanders vï¿½g 10:115
peter_e@gmx.net                   75262 Uppsala
http://yi.org/peter-e/            Sweden


Sun, 23 Jul 2000 14:58:39 +0200 (CEST)
Peter Eisentraut <peter_e@gmx.net>
TODO updates
Peter Eisentraut <peter_e@gmx.net> writes:
> Meanwhile a few TODO updates:

> * Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME(Thomas)

> Looks obsolete to me. (Reltime indexes still don't work, but I doubt
> someone needs them.)

Hm.  It looks like the following standard types are not indexable
(or at least don't have default opclass entries) in current sources:

 aclitem
 bit
 bytea
 cid
 filename
 int2vector
 line
 lseg
 money
 path
 point
 regproc
 reltime
 smgr
 tid
 tinterval
 varbit
 xid

There are three more that are indexable but not by btree (we only
have rtree support, which I guess makes sense here):

 box
 circle
 polygon

It surprises me that we don't have index support for reltime and
tinterval (I think only a 3-way comparison proc and a few table entries
are missing).  regproc is even closer, it just needs table entries.
bit/varbit are of course just Not There Yet (but I see comparison
functions exist --- just the AM table entries don't.)

Another notable omission is that there should be rtree support for all
the geometric types (what happened to line, lseg, path, point?)

Lack of indexability of these other types doesn't bother me much.

So I guess an up-to-date version of this TODO item should read

* Add btree index support for reltime, tinterval, regproc, bit, varbit
* Add rtree index support for line, lseg, path, point

> * Add hash for int8
>
> Seems to work (Tom Lane?)

Yeah, I fixed that a month ago.


> See y'all in beta... :-)

Have a good one...

			regards, tom lane

Sun, 23 Jul 2000 13:18:39 -0400
Tom Lane <tgl@sss.pgh.pa.us>
Re: TODO updates 
> 
> * -More access control over who can create tables and use locks(Karal)
> 
> Not done, and it's "Karel".

 My old patch for this is usable, but as we already discussed about it,
 more "systematic" solution is overwrite a ACL. In this context I not sure
 if my name is right here. I can help with this because I need this features
 for some my private projects, but now I don't want work on more projects if 
 the query cache is still open (and still is a quiet about it! (look at 
 anyone my first snapshot?)).

 Plan anyone (Peter?) ACL at eyeshot time?

						Karel

PS. "Karel" = "Charles" in Eng. :-) 


Mon, 24 Jul 2000 09:23:15 +0200 (CEST)
Karel Zak <zakkr@zf.jcu.cz>
Re: TODO updates
[ Charset ISO-8859-1 unsupported, converting... ]
> I'm going to be on vacation for essentially the next month. So if there's
> anything that you'd like fixed before that, now's a good time to tell.
> 
> 
> Meanwhile a few TODO updates:
> 
> * Creating index of TIMESTAMP & RELTIME fails, or rename to DATETIME(Thomas)
> 
> Looks obsolete to me. (Reltime indexes still don't work, but I doubt
> someone needs them.)

Marked as done.

> 
> * -More access control over who can create tables and use locks(Karal)
> 
> Not done, and it's "Karel".

Sorry, fixed.

> 
> * Test syslog functionality
> * Unify configuration into one configuration file (Peter E)
> * use setproctitle() if it exists for 'ps' display of status
> 
> All done

Yes.

> 
> * Add hash for int8
> 
> Seems to work (Tom Lane?)

Yes.

> 
> * BSD/OS does not support locale because there is no LC_MESSAGES
> 
> Done

Yes.

> 
> * Add ALTER TABLE DROP/ALTER COLUMN feature(Peter E) [drop]
> 
> `ALTER TABLE ALTER COLUMN' was implemented for 7.0. I am not working on
> the DROP COLUMN part, so you might want to remove my name.

Entry split into two lines and updated.
> 
> * Allow DELETE and UPDATE to use inheritance using tablename*
> 
> Chris Bitmead's contributions accomplish that (though not how it's written
> here).

Fixed, with tablename* removed.

> 
> 
> There seem to be some duplicate items:
> 
> * Some database schema's are not dumpable;  do dumps in oid order
> * make pg_dump dump in oid order, so dependencies are resolved
> 
> * Allow nulls in arrays
> * Allow arrays to hold NULL elements

Duplicates removed.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  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, Pennsylvania 19026

Thu, 27 Jul 2000 14:48:02 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO updates
> Lack of indexability of these other types doesn't bother me much.
> 
> So I guess an up-to-date version of this TODO item should read
> 
> * Add btree index support for reltime, tinterval, regproc, bit, varbit
> * Add rtree index support for line, lseg, path, point

TODO updated.

> 
> > * Add hash for int8
> >
> > Seems to work (Tom Lane?)
> 
> Yeah, I fixed that a month ago.

TODO updated.

-- 
  Bruce Momjian                        |  http://candle.pha.pa.us
  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, Pennsylvania 19026

Thu, 27 Jul 2000 14:51:31 -0400 (EDT)
Bruce Momjian <pgman@candle.pha.pa.us>
Re: TODO updates