pgsql-server/doc TODO

Started by Bruce Momjianalmost 23 years ago3 messagescomitters
Jump to latest
#1Bruce Momjian
bruce@momjian.us

CVSROOT: /cvsroot
Module name: pgsql-server
Changes by: momjian@svr1.postgresql.org 03/08/07 23:00:21

Modified files:
doc : TODO

Log message:
Update done items:

< * Allow elog() to return error codes, module name, file name, line
< number, not just messages (Peter E)
< * Add error codes (Peter E)
< * Make error messages more consistent [error]

* -Allow elog() to return error codes, module name, file name, line
number, not just messages (Tom)
* -Add error codes (Tom)
* -Make error messages more consistent

40c40
< * Add GUC log_statement_and_duration to print statement and >= min duration

* -Add GUC log_statement_and_duration to print statement and >= min duration

84c84
< * Allow current datestyle to restrict dates; prevent month/day swapping

* -Allow current datestyle to restrict dates; prevent month/day swapping

86c86
< * Prevent month/day swapping of ISO dates to make invalid dates valid

* -Prevent month/day swapping of ISO dates to make invalid dates valid

88c88
< * Delay resolution of array expression type so assignment coercion

* -Delay resolution of array expression type so assignment coercion

93c93
< o Allow arrays to be ORDER'ed

o -Allow arrays to be ORDER'ed

116c116
< * Remove Cyrillic recode support

* -Remove Cyrillic recode support

144c144
< * Certain indexes will not shrink, e.g. indexes on ever-increasing

* -Certain indexes will not shrink, e.g. indexes on ever-increasing

185c185
< * Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle

* -Have SELECT '13 minutes'::interval display zero seconds in ISO datestyle

196c196
< o -Add ALTER TABLE tab SET WITHOUT OIDS (Rod)

o --Add ALTER TABLE tab SET WITHOUT OIDS (Rod)

221c221
< stored in the backend

stored in the backend (Gavin)

235c235
< o Allow EXPLAIN EXECUTE to see prepared plans

o -Allow EXPLAIN EXECUTE to see prepared plans

241d240
< o Add untrusted version of plpython
265c264
< * Allow psql to show transaction status if backend protocol changes made

* -Allow psql to show transaction status if backend protocol changes made

272,273c271,272
< * Modify pg_get_triggerdef() to take a boolean to pretty-print,
< and use that as part of pg_dump along with psql

* -Modify pg_get_triggerdef() to take a boolean to pretty-print,
and use that as part of pg_dump along with psql

292c291
< o Add SQLSTATE

o -Add SQLSTATE

296c295
< o Implement SQLDA (do we really need this?)

o -Implement SQLDA

364d362
< * Allow binding query args over FE/BE protocol
378c376,377
< * Provide automatic running of vacuum in the background (Tom) [vacuum]

* Provide automatic running of vacuum in the background in backend
rather than in /contrib [vacuum]

427c426
< * Allow Subplans to use efficient joins(hash, merge) with upper variable

* -Allow Subplans to use efficient joins(hash, merge) with upper variable

429c428
< * Allow merge and hash joins on expressions not just simple variables (Tom)

* -Allow merge and hash joins on expressions not just simple variables (Tom)

474c473
< * Remove memory/file descriptor freeing befor elog(ERROR) (Bruce)

* Remove memory/file descriptor freeing before ereport(ERROR) (Bruce)

489,490c488,489
< o Show transaction status in psql
< o Allow binding of query parameters, support for prepared queries

o -Show transaction status in psql
o -Allow binding of query parameters, support for prepared queries

492,494c491,493
< o Remove hard-coded limits on user/db/password names
< o Remove unused elements of startup packet (unused, tty, passlength)
< o Fix COPY/fastpath protocol?

o -Remove hard-coded limits on user/db/password names
o -Remove unused elements of startup packet (unused, tty, passlength)
o -Fix COPY/fastpath protocol

496,497c495
< o Replication support?
< o Error codes

o -Error codes

500d497
< o ecpg improvements?
503c500
< o Report server version number, database encoding, client encoding

Show quoted text

o -Report server version number, database encoding, client encoding

#2Tom Lane
tgl@sss.pgh.pa.us
In reply to: Bruce Momjian (#1)
Re: pgsql-server/doc TODO

momjian@svr1.postgresql.org (Bruce Momjian) writes:

< * Delay resolution of array expression type so assignment coercion

* -Delay resolution of array expression type so assignment coercion

AFAIK, this is *not* done.

< o Implement SQLDA (do we really need this?)

o -Implement SQLDA

This is not done either is it?

364d362
< * Allow binding query args over FE/BE protocol

Shouldn't this be marked done, rather than removed?

496,497c495
< o Replication support?
< o Error codes

o -Error codes

Looks like the replication line unintentionally disappeared?

regards, tom lane

#3Bruce Momjian
bruce@momjian.us
In reply to: Tom Lane (#2)
Re: pgsql-server/doc TODO

Tom Lane wrote:

momjian@svr1.postgresql.org (Bruce Momjian) writes:

< * Delay resolution of array expression type so assignment coercion

* -Delay resolution of array expression type so assignment coercion

AFAIK, this is *not* done.

I already have it marked as not done.

< o Implement SQLDA (do we really need this?)

o -Implement SQLDA

This is not done either is it?

I thought that came in with ecpg theads, but looking now, I see sqlda.h
is am empty file. Updated.

364d362
< * Allow binding query args over FE/BE protocol

Shouldn't this be marked done, rather than removed?

It was redundant because we already have this marked as done:

o -Allow binding of query parameters, support for
prepared queries

At least I think it is redundant.

< o Replication support?
< o Error codes

o -Error codes

Looks like the replication line unintentionally disappeared?

I questioned whether replication belonged in the wire protocol section
anymore, especially since I haven't heard an argument why it is needed
in there. It was an idea floated around a while ago, but it doesn't
seem as relivant anymore.

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