Обсуждение: Open items for 8.2
Here are the open items for 8.2: http://momjian.postgresql.org/cgi-bin/pgopenitems This list will be continually updated until we release 8.2. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Bruce Momjian wrote: > Here are the open items for 8.2: > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This list will be continually updated until we release 8.2. Thanks for the effort. A quickie: this item Store only active XIDs in subtransaction cache was already done: http://archives.postgresql.org/pgsql-committers/2006-09/msg00048.php -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
Bruce Momjian <bruce@momjian.us> writes: > Here are the open items for 8.2: > http://momjian.postgresql.org/cgi-bin/pgopenitems Had a bitmap-index patch arrived in my inbox this morning, as had been promised to me for three weekends running, I might have been willing to drop all else and review it. But, no patch. This item is dead for 8.2. Do not even think of suggesting otherwise. Updatable views are likewise dead --- we don't have a credible patch or any short-term path to get one. I hope to see both of these items land early in the 8.3 devel cycle, but for 8.2, nyet. The list is missing the issue of removing the long-since-agreed-on-to-remove contrib modules. A couple of recently discussed FE/BE protocol issues are: not storing a plan at all for unnamed-statement cases, and thus allowing bind parameters to be treated as constants; allowing parameter types to go unresolved rather than throwing an error. Perhaps it's too late to consider these for 8.2, but they seem no more invasive than some other items on the open-issues list. Other docs issues: VALUES-list syntax --- not real clear where to put it timezone changes: appendix B is out of date, and do we need a list at all rather than telling people to look at the config file + system view? regards, tom lane
Alvaro Herrera <alvherre@commandprompt.com> writes: > A quickie: this item > Store only active XIDs in subtransaction cache > was already done: I think Bruce is referring to the idea that you and I each arrived at recently, ie removing subcommitted subxact XIDs from the PGPROC cache if they hadn't stored any tuples. That certainly wasn't done by my commit you mention ... did you do it when I wasn't looking? regards, tom lane
Tom Lane wrote: > Alvaro Herrera <alvherre@commandprompt.com> writes: > > A quickie: this item > > Store only active XIDs in subtransaction cache > > was already done: > > I think Bruce is referring to the idea that you and I each arrived at > recently, ie removing subcommitted subxact XIDs from the PGPROC cache > if they hadn't stored any tuples. That certainly wasn't done by my > commit you mention ... did you do it when I wasn't looking? Ah, true -- no, I didn't do it, sorry :-) -- Alvaro Herrera http://www.CommandPrompt.com/ The PostgreSQL Company - Command Prompt, Inc.
Bruce Momjian wrote: > Here are the open items for 8.2: > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This list will be continually updated until we release 8.2. > > Emacs code example not submitted Gregory Stark <gsstark@mit.edu> <mailto:gsstark@mit.edu> This one is actually on my list, and will be done in a day or two. I have Greg's suggestion, which will be included. cheers andrew
On Mon, Sep 04, 2006 at 11:58:35PM -0400, Tom Lane wrote: > timezone changes: appendix B is out of date, and do we need a list at > all rather than telling people to look at the config file + system view? Since I did the initial patch I also volunteer to submit documentation for it. As far as the table is concerned, I think we agreed on removing the list (that has been inaccurate since long anyway) and tell people to check out the system view. Joachim -- Joachim Wieland joe@mcknight.de GPG key available
Tom Lane wrote: > Bruce Momjian <bruce@momjian.us> writes: > > Here are the open items for 8.2: > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > Had a bitmap-index patch arrived in my inbox this morning, as had been > promised to me for three weekends running, I might have been willing to > drop all else and review it. But, no patch. This item is dead for 8.2. > Do not even think of suggesting otherwise. Well, we have to use some objective criteria, rather than one person's decision. I would say we are one month past feature freeze, and have not received a patch to review, and you have asked repeatedly. That is enough of a basis to reject this feature for 8.2. Removed from open items list. > Updatable views are likewise dead --- we don't have a credible patch or > any short-term path to get one. I hope to see both of these items land > early in the 8.3 devel cycle, but for 8.2, nyet. OK, same criteria. Removed. > The list is missing the issue of removing the long-since-agreed-on-to-remove > contrib modules. Added. > A couple of recently discussed FE/BE protocol issues are: not storing a > plan at all for unnamed-statement cases, and thus allowing bind > parameters to be treated as constants; allowing parameter types to go > unresolved rather than throwing an error. Perhaps it's too late to > consider these for 8.2, but they seem no more invasive than some other > items on the open-issues list. Well, I think the difference is that they are new items, rather than something pre-August 1 (or bugs), but I figure we could throw them in if it wasn't risky. Added to list. > Other docs issues: > > VALUES-list syntax --- not real clear where to put it > > timezone changes: appendix B is out of date, and do we need a list at > all rather than telling people to look at the config file + system view? Both added. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Andrew Dunstan wrote: > Bruce Momjian wrote: > > Here are the open items for 8.2: > > > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > > > This list will be continually updated until we release 8.2. > > > > > > Emacs code example not submitted Gregory Stark <gsstark@mit.edu> > <mailto:gsstark@mit.edu> > > > > This one is actually on my list, and will be done in a day or two. I > have Greg's suggestion, which will be included. OK. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
We made pretty good progress today on the open-items list: ISBN/EAN: I've reviewed this and fixed a couple small issues, it's ready to commit as soon as the author indicates his assent to license statement. I'll remove isbn_issn at the same time. Altering view ownership doesn't work: fixed Remove pgcrypto deprecated functions: done Intel compiler fails for GIN build: I think Teodor did something with this Add /contrib/hstore: done by Teodor plpgsql, return can contains any expression: actually, this is "bounced back to author for rework". Dunno if you intend "reviewing" to include that state. Remove contrib stuff: done regards, tom lane
Joachim Wieland wrote: > On Mon, Sep 04, 2006 at 11:58:35PM -0400, Tom Lane wrote: > > timezone changes: appendix B is out of date, and do we need a list at > > all rather than telling people to look at the config file + system view? > > Since I did the initial patch I also volunteer to submit documentation for > it. As far as the table is concerned, I think we agreed on removing the list > (that has been inaccurate since long anyway) and tell people to check out > the system view. OK, added. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Tom Lane wrote: > We made pretty good progress today on the open-items list: > > ISBN/EAN: I've reviewed this and fixed a couple small issues, it's ready > to commit as soon as the author indicates his assent to license > statement. I'll remove isbn_issn at the same time. > > Altering view ownership doesn't work: fixed > > Remove pgcrypto deprecated functions: done > > Intel compiler fails for GIN build: I think Teodor did something with > this > > Add /contrib/hstore: done by Teodor > > plpgsql, return can contains any expression: actually, this is "bounced > back to author for rework". Dunno if you intend "reviewing" to include > that state. Yes, it does, but I changed it to "resubmit". > Remove contrib stuff: done Other stuff all updated/removed. -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
bruce@momjian.us (Bruce Momjian) writes: > Here are the open items for 8.2: > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This list will be continually updated until we release 8.2. I've got suggested patches for my item (e.g. - --with-openssl causing contrib stuff to break on AIX); a couple of instances of: SHLIB_LINK = $(libpq) $(LIBS) in contrib/dblink/Makefile and contrib/sslinfo seem to do the trick. I'm not sure of adverse effects for others, so that's only speculative at this point... -- output = ("cbbrowne" "@" "linuxfinances.info") http://linuxdatabases.info/info/postgresql.html Is A.I. Possible? Some ask "Can humans create intelligent machines?" In fact, humans do it all the time. The question needs to be "Since it's possible in the bedroom, why shouldn't it be possible in the laboratory?" -- Mark Miller
Chris Browne wrote: > bruce@momjian.us (Bruce Momjian) writes: > > Here are the open items for 8.2: > > > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > > > This list will be continually updated until we release 8.2. > > I've got suggested patches for my item (e.g. - --with-openssl causing > contrib stuff to break on AIX); a couple of instances of: > > SHLIB_LINK = $(libpq) $(LIBS) > > in contrib/dblink/Makefile and contrib/sslinfo seem to do the trick. > I'm not sure of adverse effects for others, so that's only speculative > at this point... My guess is that sslinfo needs it because of the use of the SSL libraries. I would guess any of the other /contrib modules would need similar changes. Can you do a 'make' at the top of the contrib tree and see what fails? -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Bruce Momjian <bruce@momjian.us> writes: > Chris Browne wrote: >> I've got suggested patches for my item (e.g. - --with-openssl causing >> contrib stuff to break on AIX); a couple of instances of: >> >> SHLIB_LINK = $(libpq) $(LIBS) >> >> in contrib/dblink/Makefile and contrib/sslinfo seem to do the trick. >> I'm not sure of adverse effects for others, so that's only speculative >> at this point... > My guess is that sslinfo needs it because of the use of the SSL > libraries. I just added $(LIBS) to sslinfo's Makefile to fix its build failure on Darwin. (I see no reason why libpq should be involved there, though.) I'm unclear on why AIX would need more than Darwin does to get dblink to build. regards, tom lane
Centuries ago, Nostradamus foresaw when tgl@sss.pgh.pa.us (Tom Lane) would write: > Bruce Momjian <bruce@momjian.us> writes: >> Chris Browne wrote: >>> I've got suggested patches for my item (e.g. - --with-openssl causing >>> contrib stuff to break on AIX); a couple of instances of: >>> >>> SHLIB_LINK = $(libpq) $(LIBS) >>> >>> in contrib/dblink/Makefile and contrib/sslinfo seem to do the trick. >>> I'm not sure of adverse effects for others, so that's only speculative >>> at this point... > >> My guess is that sslinfo needs it because of the use of the SSL >> libraries. > > I just added $(LIBS) to sslinfo's Makefile to fix its build failure on > Darwin. (I see no reason why libpq should be involved there, > though.) > I'm unclear on why AIX would need more than Darwin does to get dblink > to build. In the case of dblink/Makefile, it started as SHLIB_LINK = $(libpq) which need to be augmented to: SHLIB_LINK = $(libpq) $(LIBS) When I saw the same errors pop up with sslinfo, there was no SHLIB_LINK definition, so went to: SHLIB_LINK = $(libpq) $(LIBS) It's entirely possible that SHLIB_LINK = $(LIBS) is sufficient. -- wm(X,Y):-write(X),write('@'),write(Y). wm('cbbrowne','gmail.com'). http://linuxfinances.info/info/spreadsheets.html "We defeated the enemy with teamwork and the hammer of not bickering." -- The Shoveller, Mystery Men
--On Montag, September 04, 2006 23:58:35 -0400 Tom Lane <tgl@sss.pgh.pa.us> wrote: > Updatable views are likewise dead --- we don't have a credible patch or > any short-term path to get one. I hope to see both of these items land > early in the 8.3 devel cycle, but for 8.2, nyet. Yeah, i don't had the time to get to it the last days and to fix all outstanding issues, sorry for that. Regarding to the complexity of all required work that needs to be done, 8.3 is the better choice, indeed. -- Thanks Bernd
Am Dienstag, 5. September 2006 05:58 schrieb Tom Lane: > A couple of recently discussed FE/BE protocol issues are: not storing a > plan at all for unnamed-statement cases, and thus allowing bind > parameters to be treated as constants; allowing parameter types to go > unresolved rather than throwing an error. Perhaps it's too late to > consider these for 8.2, but they seem no more invasive than some other > items on the open-issues list. Do we have a patch for that today? -- Peter Eisentraut http://developer.postgresql.org/~petere/
Am Dienstag, 5. September 2006 03:07 schrieb Bruce Momjian: > Here are the open items for 8.2: > > http://momjian.postgresql.org/cgi-bin/pgopenitems This host seems to be offline. What about using the wiki? -- Peter Eisentraut http://developer.postgresql.org/~petere/
Hello, On Wed, 2006-09-06 at 13:04 +0200, Peter Eisentraut wrote: > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This host seems to be offline. It is suffering from a DNS problem. > What about using the wiki? Wiki has the same problem, too. Regards, -- The PostgreSQL Company - Command Prompt, Inc. 1.503.667.4564 PostgreSQL Replication, Consulting, Custom Development, 24x7 support Managed Services, Shared and Dedicated Hosting Co-Authors: plPHP, plPerlNG - http://www.commandprompt.com/
> > Here are the open items for 8.2: > > > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This host seems to be offline. What about using the wiki? The problem is with the postgresql.org DNS servers. Something weird is afoot around the hub.org nameservers, from what I can tell. Servers seem to be dropping off one by one as TTLs expire. //Magnus
Martha Stewart called it a Good Thing when mha@sollentuna.net ("Magnus Hagander") wrote: >> > Here are the open items for 8.2: >> > >> > http://momjian.postgresql.org/cgi-bin/pgopenitems >> >> This host seems to be offline. What about using the wiki? > > The problem is with the postgresql.org DNS servers. Something weird is > afoot around the hub.org nameservers, from what I can tell. Servers seem > to be dropping off one by one as TTLs expire. Apparently Marc is back; he recently had a question about reordering IP addresses on pgsql.sql, which suggests some sort of DNS maintenance being up. Hopefully this is a matter of things getting a little worse before they get more comprehensively fixed. I hope... -- let name="cbbrowne" and tld="gmail.com" in name ^ "@" ^ tld;; http://linuxdatabases.info/info/spreadsheets.html "Look, would it save you all this bother if I just gave up and went mad now?" -- Arthur Dent
Peter Eisentraut <peter_e@gmx.net> writes: > Am Dienstag, 5. September 2006 05:58 schrieb Tom Lane: >> A couple of recently discussed FE/BE protocol issues are: not storing a >> plan at all for unnamed-statement cases, and thus allowing bind >> parameters to be treated as constants; allowing parameter types to go >> unresolved rather than throwing an error. Perhaps it's too late to >> consider these for 8.2, but they seem no more invasive than some other >> items on the open-issues list. > Do we have a patch for that today? We could have a patch for the first one today --- I was thinking about it last night and intending to code it today. The second one is merely a matter of removing an error check that exists now; the question really is do people want that behavior. (I asked that on the jdbc list and got zero response, so actually I was thinking that it was a dead issue; but as long as it's on the open-items list we ought to discuss it.) regards, tom lane
Peter Eisentraut wrote: > Am Dienstag, 5. September 2006 03:07 schrieb Bruce Momjian: > > Here are the open items for 8.2: > > > > http://momjian.postgresql.org/cgi-bin/pgopenitems > > This host seems to be offline. What about using the wiki? The host is fine. postgresql.org DNS is broken. Reference the host directly: http://momjian.us/cgi-bin/pgopenitems -- Bruce Momjian bruce@momjian.us EnterpriseDB http://www.enterprisedb.com + If your life is a hard drive, Christ can be your backup. +
Bruce Momjian wrote: > Tom Lane wrote: >> Had a bitmap-index patch arrived in my inbox this morning, as had been >> promised to me for three weekends running, I might have been willing to >> drop all else and review it. But, no patch. This item is dead for 8.2. >> Do not even think of suggesting otherwise. > > Well, we have to use some objective criteria, rather than one person's > decision. I would say we are one month past feature freeze, and have > not received a patch to review, and you have asked repeatedly. That is > enough of a basis to reject this feature for 8.2. Removed from open > items list. This may be too little too late, but I have time to work on the bitmap index patch and fix the API issues. I'm familiar with the index am API and I can see the issues with the patch as it stands. If it's definitely too late for 8.2, I'd like to get it into CVS as soon as possible after the 8.2 release. Jie and/or Gavin, could you send the latest version of the patch to the list in any case? Do you want help with the patch, or would I be stepping on your toes? -- Heikki Linnakangas EnterpriseDB http://www.enterprisedb.com
Tom Lane wrote: > Peter Eisentraut <peter_e@gmx.net> writes: >> Am Dienstag, 5. September 2006 05:58 schrieb Tom Lane: >>> A couple of recently discussed FE/BE protocol issues are: not storing a >>> plan at all for unnamed-statement cases, and thus allowing bind >>> parameters to be treated as constants; allowing parameter types to go >>> unresolved rather than throwing an error. Perhaps it's too late to >>> consider these for 8.2, but they seem no more invasive than some other >>> items on the open-issues list. > >> Do we have a patch for that today? > > We could have a patch for the first one today --- I was thinking about > it last night and intending to code it today. The second one is merely > a matter of removing an error check that exists now; the question really > is do people want that behavior. (I asked that on the jdbc list and got > zero response, so actually I was thinking that it was a dead issue; but > as long as it's on the open-items list we ought to discuss it.) I personally think it's a good idea to do it, as it should improve the plans for one-shot queries. Unfortunately I don't certainly know how the JDBC driver issues queries when called through a PreparedStatement but without a "prepare-threshold"[*] set. If it uses the unnamed-statement, then I guess the proposed change would be a win. Best Regards Michael Paesold [*] This option determines, after how many executes of a prepared statement, the driver will switch to server-side prepares.