Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Bernd Helmle
--On Montag, September 04, 2006 23:58:35 -0400 Tom Lane <[EMAIL PROTECTED]> 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

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Oleg Bartunov
I'm a bit fear to to engage into this thread, but I've seen also reproducible case when libpq client stops working and 'vaccuum analyze' helped. It's happened on Windows Server 2003 and XP with PostgreSQL 8.1.4. I don't have client source code, so I can't say more, but customer's developer said th

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Tom Lane
Abhijit Menon-Sen <[EMAIL PROTECTED]> writes: > Fine with me. Two questions: > - Where would the code live, if it were in core? New file under utils/adt/ probably ... it's not a new datatype exactly, but that's the default place for new SQL-visible functions. > - Shall I hack up the API you sugg

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-05 Thread mark
On Tue, Sep 05, 2006 at 05:54:50PM -0700, Jeff Davis wrote: > On Tue, 2006-09-05 at 18:24 -0400, Chris Browne wrote: > > Recently seen in ACM Operating Systems Review (this is the first time > > I've found as many as 1 interesting article in it in a while, and > > there were 3 things I found worthw

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Yes, unfortunately there isn't much more to be had for another 2 weeks ;) I trust they've got the reboot time and they will know exactly how long from reboot to problem? I'm not all that sold on the "GetTickCount overflow" theory,

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Abhijit Menon-Sen
At 2006-09-05 16:35:49 -0400, [EMAIL PROTECTED] wrote: > > The biggest part of the work needed is to write the documentation --- > but we'd have to do that for Abhijit's patch too, since the userlocks > docs presumably fall under GPL along with the code. I'll write the documentation, either for th

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > Yes, unfortunately there isn't much more to be had for another 2 weeks ;) I trust they've got the reboot time and they will know exactly how long from reboot to problem? I'm not all that sold on the "GetTickCount overflow" theory, but certainly we o

Re: [HACKERS] @ versus ~, redux

2006-09-05 Thread Tom Lane
Jeff Davis <[EMAIL PROTECTED]> writes: > On Mon, 2006-09-04 at 10:45 -0400, Tom Lane wrote: >> The existing geometric containment tests seem to be nonstrict, so if we >> wanted to leave room to add strict ones later, it might be best to >> settle on >> >> x @>= y x contains or equals

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Christopher Browne
Centuries ago, Nostradamus foresaw when [EMAIL PROTECTED] (Tom Lane) would write: > Bruce Momjian <[EMAIL PROTECTED]> 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: >>> >>> SHLI

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-05 Thread Jeff Davis
On Tue, 2006-09-05 at 18:24 -0400, Chris Browne wrote: > Recently seen in ACM Operating Systems Review (this is the first time > I've found as many as 1 interesting article in it in a while, and > there were 3 things I found worthwhile...): > > NTT (of the recent "NTT Power Hour") have created a n

Re: [HACKERS] @ versus ~, redux

2006-09-05 Thread Jeff Davis
On Mon, 2006-09-04 at 10:45 -0400, Tom Lane wrote: > Andrew - Supernews <[EMAIL PROTECTED]> writes: > > On 2006-09-04, Tom Lane <[EMAIL PROTECTED]> wrote: > >> Do we all agree on this: > >> > >> "x @> y" means "x contains y" > >> "x @< y" means "x is contained in y" > > The existing geometric con

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Dave Cramer
On 5-Sep-06, at 7:00 PM, Joshua D. Drake wrote: Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED]> writes: On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote: Yes they are using a connection pool. A java based one. Since java has it's own protocol implementation, this is totally unrelated to any

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
It sounds to me like we don't actually know that, because the client doesn't know how to restart the postmaster without rebooting the OS. (Josh says "pg_ctl stop" doesn't work in this state, which is a tad interesting in itself, because that doesn't go through a connection request.) It would be

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Tom Lane
Alvaro Herrera <[EMAIL PROTECTED]> writes: > Joshua D. Drake wrote: >> I already said that ;). The problem IS NOT that we can't restart the >> system and get postgresql back. It is that it happens at all. > It is quite different a bug that can only be fixed by "rebooting the > server" (which to m

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Alvaro Herrera
Joshua D. Drake wrote: > The only known resolution is to reboot Windows. Using the service ^^ > control panel to shutdown postgresql will fail once the message is > received. It is unknown if using the task master to individually kill > processes wi

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> 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

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Alvaro Herrera
Joshua D. Drake wrote: > Alvaro Herrera wrote: > >Joshua D. Drake wrote: > >>Tom Lane wrote: > >>>Dave Cramer <[EMAIL PROTECTED]> writes: > On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote: > >Yes they are using a connection pool. A java based one. > Since java has it's own protocol imple

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Hello, O.k. to recap: OS: Win2k3 SP1 PostgreSQL: 8.1.2 Application Server: Jboss Connection Pooler: C3PO JDBC Version: 8.1.404, Also verified with 8.0.311 Problem: After 2/3 weeks, PostgreSQL will begin issuing the following message: server sent data ("D" message) without prior row descriptio

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Alvaro Herrera wrote: Joshua D. Drake wrote: Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED]> writes: On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote: Yes they are using a connection pool. A java based one. Since java has it's own protocol implementation, this is totally unrelated to any libp

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Bruce Momjian
Chris Browne wrote: > [EMAIL PROTECTED] (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 c

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Alvaro Herrera
Joshua D. Drake wrote: > Tom Lane wrote: > >Dave Cramer <[EMAIL PROTECTED]> writes: > >>On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote: > >>>Yes they are using a connection pool. A java based one. > > > >>Since java has it's own protocol implementation, this is totally > >>unrelated to any libpq

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Chris Browne
josh@agliodbs.com (Josh Berkus) writes: > Overall, though, I think we should really wait until 8.3 for core merge and > API improvements. Wasn't Tom just complaining about last-minute features, > and not enough code reviewers? He may have worked through enough of the backlog that he's ready to

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Chris Browne
[EMAIL PROTECTED] (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 A

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Dave Page
-Original Message- From: "Joshua D. Drake" <[EMAIL PROTECTED]> To: "Joshua D. Drake" <[EMAIL PROTECTED]>; "Tom Lane" <[EMAIL PROTECTED]>; "Merlin Moncure" <[EMAIL PROTECTED]>; "Magnus Hagander" <[EMAIL PROTECTED]>; "PostgreSQL-development" Sent: 05/09/06 23:27 Subject: Re: [HACKERS] Wi

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Tom Lane wrote: Dave Cramer <[EMAIL PROTECTED]> writes: On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote: Yes they are using a connection pool. A java based one. Since java has it's own protocol implementation, this is totally unrelated to any libpq error messages. Another important point t

Re: [HACKERS] ISBN/ISSN/ISMN/EAN13 module

2006-09-05 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > Tom Lane wrote: > >> I'm reviewing this for addition to contrib/ now. I notice that there is > >> no clear license statement. Is it OK to put the following into the > >> README file? > > >> This module is released under the same BSD

Re: [HACKERS] [PATCHES] WIP: bitmap indexes

2006-09-05 Thread Bruce Momjian
This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Jie Zhang wrote: > > > On 8/15/06 6:18 AM, "Tom Lane" <[EMAIL PROTECTED]> wrote: > > > Gavin Sherry <[EMAIL PROTECT

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Alvaro Herrera wrote: Joshua D. Drake wrote: Alvaro Herrera wrote: Joshua D. Drake wrote: Alvaro Herrera wrote: What I've been wondering all along is whether they are using a connection pool. Yes they are using a connection pool. A java based one. It's quite possible that it's the connect

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Bruce Momjian
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 owner

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Alvaro Herrera
Joshua D. Drake wrote: > Alvaro Herrera wrote: > >Tom Lane wrote: > >>"Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >Fail in what way. Hang, not connect, or get an error msg? > >>>Just verified with customer. Once the problem occurs the first time, the > >>>customer will continually get the

Re: [HACKERS] New Linux Filesystem: NILFS

2006-09-05 Thread Douglas McNaught
Chris Browne <[EMAIL PROTECTED]> writes: > NetBSD used to have a LFS; has that gone anywhere? Or been > essentially dropped? My reading over the last few years has indicated that LFSs tend to suffer bad performance degradation as data and metadata for a given file get scattered all over the disk

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Tom Lane
Dave Cramer <[EMAIL PROTECTED]> writes: > On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote: >> Yes they are using a connection pool. A java based one. > Since java has it's own protocol implementation, this is totally > unrelated to any libpq error messages. Another important point that we've not

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Alvaro Herrera
Joshua D. Drake wrote: > Alvaro Herrera wrote: > >Joshua D. Drake wrote: > >>Alvaro Herrera wrote: > >>>What I've been wondering all along is whether they are using a > >>>connection pool. > >>Yes they are using a connection pool. A java based one. > > > >It's quite possible that it's the connecti

Re: [HACKERS] ISBN/ISSN/ISMN/EAN13 module

2006-09-05 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Tom Lane wrote: >> I'm reviewing this for addition to contrib/ now. I notice that there is >> no clear license statement. Is it OK to put the following into the >> README file? >> This module is released under the same BSD license as the rest of Postgr

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Dave Cramer
On 5-Sep-06, at 6:05 PM, Joshua D. Drake wrote: Alvaro Herrera wrote: Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Fail in what way. Hang, not connect, or get an error msg? Just verified with customer. Once the problem occurs the first time, the customer will continually g

Re: [HACKERS] [PATCHES] Updatable views

2006-09-05 Thread Bruce Momjian
This has been saved for the 8.3 release: http://momjian.postgresql.org/cgi-bin/pgpatches_hold --- Bernd Helmle wrote: > --On Freitag, September 01, 2006 11:41:16 -0400 Tom Lane > <[EMAIL PROTECTED]> wrote: > > > >

Re: [HACKERS] ISBN/ISSN/ISMN/EAN13 module

2006-09-05 Thread Bruce Momjian
Tom Lane wrote: > "Jeremy Kronuz" <[EMAIL PROTECTED]> writes: > > Hello again,This is an usable version of my EAN13/UPC/ISBN module. > > I'm reviewing this for addition to contrib/ now. I notice that there is > no clear license statement. Is it OK to put the following into the > README file? >

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Alvaro Herrera wrote: Joshua D. Drake wrote: Alvaro Herrera wrote: Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Fail in what way. Hang, not connect, or get an error msg? Just verified with customer. Once the problem occurs the first time, the customer will continually get th

[HACKERS] New Linux Filesystem: NILFS

2006-09-05 Thread Chris Browne
Recently seen in ACM Operating Systems Review (this is the first time I've found as many as 1 interesting article in it in a while, and there were 3 things I found worthwhile...): NTT (of the recent "NTT Power Hour") have created a new filesystem: NILFS is a log-struc

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Jeremy Drake
On Tue, 5 Sep 2006, Joshua D. Drake wrote: > Right, but "just took a reboot to fix it" isn't very confidence inspiring ;) Are you kidding? This is standard procedure for troubleshooting Windows problems :) -- The world is coming to an end. Please log off. ---(end of br

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Andrew - Supernews
On 2006-09-05, "Merlin Moncure" <[EMAIL PROTECTED]> wrote: > I have no objection from them being removed from contrib in the short > term due to the gpl issue, although I am not sure how you can > copyright a function wrapper. I made this point several times in the original discussion (which was a

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Alvaro Herrera wrote: Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Fail in what way. Hang, not connect, or get an error msg? Just verified with customer. Once the problem occurs the first time, the customer will continually get the same error message for each subsequent conne

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Tom Lane wrote: "Joshua D. Drake" <[EMAIL PROTECTED]> writes: Fail in what way. Hang, not connect, or get an error msg? Just verified with customer. Once the problem occurs the first time, the customer will continually get the same error message for each subsequent connection attempt: ser

Re: [HACKERS] pgcrypto deprecated functions?

2006-09-05 Thread Bruce Momjian
Tom Lane wrote: > "Marko Kreen" <[EMAIL PROTECTED]> writes: > > On 8/30/06, Bruce Momjian <[EMAIL PROTECTED]> wrote: > >> Michael Fuhr wrote: > >>> In README.pgcrypto, Section 2.3 "Deprecated functions" says that > >>> digest_exists(), hmac_exists(), and cipher_exists() are planned to > >>> be remo

Re: [HACKERS] [PATCHES] Backend SSL configuration enhancement

2006-09-05 Thread Bruce Momjian
Victor Wagner wrote: > On 2006.09.04 at 15:46:03 -0400, Bruce Momjian wrote: > > > Tom Lane wrote: > > > Bruce Momjian <[EMAIL PROTECTED]> writes: > > > > This has been saved for the 8.3 release: > > > > http://momjian.postgresql.org/cgi-bin/pgpatches_hold > > > > > > This version was wit

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Alvaro Herrera
Tom Lane wrote: > "Joshua D. Drake" <[EMAIL PROTECTED]> writes: > >>> Fail in what way. Hang, not connect, or get an error msg? > > > Just verified with customer. Once the problem occurs the first time, the > > customer will continually get the same error message for each subsequent > > connecti

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Tom Lane
"Joshua D. Drake" <[EMAIL PROTECTED]> writes: >>> Fail in what way. Hang, not connect, or get an error msg? > Just verified with customer. Once the problem occurs the first time, the > customer will continually get the same error message for each subsequent > connection attempt: > server sent d

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Bruce Momjian
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 doc

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Tom Lane
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 Remo

Re: [HACKERS] updatable views and default values

2006-09-05 Thread David Fetter
On Sat, Sep 02, 2006 at 06:22:49PM -0500, Jim C. Nasby wrote: > On Thu, Aug 31, 2006 at 06:29:50PM -0400, Tom Lane wrote: > > For backwards compatibility we should probably say that this > > automatic lifting of base-table defaults happens only if the > > INSERT rule is implicitly generated ... if

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Josh failed to answer the most important question though: Sorry. Subsequent connections to the database will fail (such as pgAdmin) and Windows must be completely rebooted. Fail in what way. Hang, not connect, or get an error msg? Just verified with customer. Once the problem occurs the

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Bruce Momjian
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 examplenot submitted Gregory Stark <[EMAIL PROTECTED]>

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Bruce Momjian
Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> 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 willi

Re: [HACKERS] pgcrypto deprecated functions?

2006-09-05 Thread Tom Lane
"Marko Kreen" <[EMAIL PROTECTED]> writes: > On 8/30/06, Bruce Momjian <[EMAIL PROTECTED]> wrote: >> Michael Fuhr wrote: >>> In README.pgcrypto, Section 2.3 "Deprecated functions" says that >>> digest_exists(), hmac_exists(), and cipher_exists() are planned to >>> be removed in PostgreSQL 8.2. Thos

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > On 9/5/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote: >> Magnus Hagander wrote: >>> What do you mean by this? It doesn't start upon reboot? What is needed >>> to make it start? >> >> It means that postgresql doesn't recover on its own. On linux if a >

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Magnus Hagander
> >> PostgreSQL will also not recover on its own (e.g; auto restart and > >> roll through the logs). > > > > What do you mean by this? It doesn't start upon reboot? > What is needed > > to make it start? > > It means that postgresql doesn't recover on its own. On linux > if a backend crashes

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Magnus Hagander wrote: PostgreSQL will also not recover on its own (e.g; auto restart and roll through the logs). What do you mean by this? It doesn't start upon reboot? What is needed to make it start? It means that postgresql doesn't recover on its own. On linux if a backend crashes all of

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Merlin Moncure
On 9/5/06, Joshua D. Drake <[EMAIL PROTECTED]> wrote: Magnus Hagander wrote: > What do you mean by this? It doesn't start upon reboot? What is needed > to make it start? It means that postgresql doesn't recover on its own. On linux if a backend crashes all of PostgreSQL will restart and come bac

Re: [HACKERS] Win32 hard crash problem

2006-09-05 Thread Joshua D. Drake
Magnus Hagander wrote: Oops, going backwards through the mails it seems :) Subsequent connections to the database will fail (such as pgAdmin) and Windows must be completely rebooted. Fail in what way. Hang, not connect, or get an error msg? PostgreSQL will also not recover on its own (e.g;

Re: [HACKERS] [PATCHES] Gen_fmgrtab.sh fails with LANG=et_EE

2006-09-05 Thread Marko Kreen
On 9/5/06, Tom Lane <[EMAIL PROTECTED]> wrote: Peter Eisentraut <[EMAIL PROTECTED]> writes: > Well, the line of code is > cpp_define=`echo $OIDSFILE | tr abcdefghijklmnopqrstuvwxyz ABCDEFGHIJKLMNOPQRSTUVWXYZ | sed -e 's/[^A-Z]/_/g'` > so it ought to be pretty obvious what the correct solution fo

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Tom Lane
Josh Berkus writes: > Merlin, >> well, I'm confused now. Tom said that cleaned up functions might be >> sneaked into 8.2, which is what prompted my question. > You're correct, he did. Tom? Well, it's not like we're done with forced initdb's for 8.2, so I don't particularly see the harm in add

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Andrew Dunstan
Tom Lane wrote: I'm happy to put some cleaned-up functions into core right now (ie, for 8.2) if someone will do the legwork to define and implement them. OK, who are you and what have you done with the real Tom Lane? cheers andrew ---(end of broadcast)---

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Joachim Wieland
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

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Merlin Moncure
On 9/5/06, Stefan Kaltenbrunner <[EMAIL PROTECTED]> wrote: Tom Lane wrote: > "Merlin Moncure" <[EMAIL PROTECTED]> writes: >> I also agree with Andrew that pgfoundry is not a appropriate place for >> userlocks. They should be properly documented with a cleaned up api. >> I have no objection from

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Andrew - Supernews
On 2006-09-05, Tom Lane <[EMAIL PROTECTED]> wrote: > Right, I see the pgfoundry project as just a backwards-compatibility > thing for anyone who doesn't want to change their code. I'm happy to > put some cleaned-up functions into core right now (ie, for 8.2) if > someone will do the legwork to def

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Stefan Kaltenbrunner
Tom Lane wrote: > "Merlin Moncure" <[EMAIL PROTECTED]> writes: >> I also agree with Andrew that pgfoundry is not a appropriate place for >> userlocks. They should be properly documented with a cleaned up api. >> I have no objection from them being removed from contrib in the short >> term due to t

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Andrew - Supernews
On 2006-09-05, "Merlin Moncure" <[EMAIL PROTECTED]> wrote: > On 9/5/06, Andrew - Supernews <[EMAIL PROTECTED]> wrote: >> On 2006-09-05, Josh Berkus wrote: >> > The current code is GPL. It *has* to be removed. >> >> Which is why Abhijit's version exists - it's intended to be a drop-in, >> BSD-lic

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Josh Berkus
Merlin, > well, I'm confused now. Tom said that cleaned up functions might be > sneaked into 8.2, which is what prompted my question. You're correct, he did. Tom? > If that's the > case I'm considering putting something together quickly. It's no big > deal to me either way really. However,

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Merlin Moncure
On 9/5/06, Josh Berkus wrote: So userlocks will be in pgFoundry for the next rev -- frankly, it should have been for 8.1 but I forgot it. For the 8.3 version, as Tom has indicated we may want to change the API somewhat anyway, so we'll want the pgFoundry version for backwards-compat. well, I'

Re: [HACKERS] [PATCHES] Gen_fmgrtab.sh fails with LANG=et_EE

2006-09-05 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Well, the line of code is > cpp_define=`echo $OIDSFILE | tr abcdefghijklmnopqrstuvwxyz > ABCDEFGHIJKLMNOPQRSTUVWXYZ | sed -e 's/[^A-Z]/_/g'` > so it ought to be pretty obvious what the correct solution for the > problem "character ranges are locale-de

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Peter Eisentraut
Tom Lane wrote: > Checking my copy of the "hit list", I thought we'd agreed to migrate > contrib/oracle as well. It has already been removed because it is being actively maintained elsewhere. -- Peter Eisentraut http://developer.postgresql.org/~petere/ ---(end of broadc

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Josh Berkus
Merlin, > > > The current code is GPL. It *has* to be removed. > > > > Which is why Abhijit's version exists - it's intended to be a drop-in, > > BSD-licensed replacement for the current code. > > does his patch include documentation? I can help with that if it isn't > done. was it reviewed?

Re: [HACKERS] [PATCHES] Gen_fmgrtab.sh fails with LANG=et_EE

2006-09-05 Thread Peter Eisentraut
Tom Lane wrote: > "Marko Kreen" <[EMAIL PROTECTED]> writes: > > I grepped around source and did not find other instances of this. > > The A-Z experssion was only in perl scripts or in configure and > > configure should be fine as it explicitly resets locale. > > Why not do the same in Gen_fmgrtab.s

Re: [HACKERS] Where is hstore?

2006-09-05 Thread Tom Lane
I'm seeing the following compiler warnings from hstore on x86_64: hstore_io.c: In function 'get_val': hstore_io.c:51: warning: format '%d' expects type 'int', but argument 4 has type 'long int' hstore_io.c: In function 'parse_hstore': hstore_io.c:150: warning: format '%d' expects type 'int', but

Re: [HACKERS] [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL

2006-09-05 Thread Peter Eisentraut
Tom Lane wrote: > Fixed --- I noticed it about the same time you did. I'm surprised > Peter didn't get a Makefile right the first time though ... I'm surprised how crazy the contrib makefiles got while I wasn't looking. :) I was glad to get something working at all. The uniformity isn't that

Re: [HACKERS] [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL

2006-09-05 Thread Peter Eisentraut
Bruce Momjian wrote: > > Yes, it can be removed. I just wasn't aware that copyright transfer > > is neccessary. Most open-source projects don't have such a > > requirement, and individual portions of code are copyrighted by > > their respecitve authors. This isn't a "copyright transfer", but if yo

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Merlin Moncure
On 9/5/06, Andrew - Supernews <[EMAIL PROTECTED]> wrote: On 2006-09-05, Josh Berkus wrote: > The current code is GPL. It *has* to be removed. Which is why Abhijit's version exists - it's intended to be a drop-in, BSD-licensed replacement for the current code. does his patch include documen

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Andrew - Supernews
On 2006-09-05, Josh Berkus wrote: > The current code is GPL. It *has* to be removed. Which is why Abhijit's version exists - it's intended to be a drop-in, BSD-licensed replacement for the current code. -- Andrew, Supernews http://www.supernews.com - individual and corporate NNTP services --

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Andrew - Supernews
On 2006-09-05, Tom Lane <[EMAIL PROTECTED]> wrote: > Andrew Dunstan <[EMAIL PROTECTED]> writes: >> It's a pity we didn't have Abhijit's patch 6 weeks ago. > > Well, now that we have it, the question is whether we want to do > anything with it. One problem is it lacks documentation. > > However, as

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Tom Lane
"Merlin Moncure" <[EMAIL PROTECTED]> writes: > I also agree with Andrew that pgfoundry is not a appropriate place for > userlocks. They should be properly documented with a cleaned up api. > I have no objection from them being removed from contrib in the short > term due to the gpl issue, although

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Merlin Moncure
On 9/5/06, Tom Lane <[EMAIL PROTECTED]> wrote: Andrew Dunstan <[EMAIL PROTECTED]> writes: > It's a pity we didn't have Abhijit's patch 6 weeks ago. Well, now that we have it, the question is whether we want to do anything with it. One problem is it lacks documentation. yes, userlocks have to

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Tom Lane
Josh Berkus writes: >> Checking my copy of the "hit list", I thought we'd agreed to migrate >> contrib/oracle as well. > Hmmm ... somehow that got dropped out of discussions early on, without > any reason why. Actually ... never mind that, it seems to have been done already. Sorry for the noise

Re: [HACKERS] TODO Request

2006-09-05 Thread Alvaro Herrera
Rocco Altier wrote: > > From: [EMAIL PROTECTED] > > [mailto:[EMAIL PROTECTED] On Behalf Of Hannu Krosing > > > > Ühel kenal päeval, T, 2006-08-29 kell 22:12, kirjutas Joshua D. Drake: > > > >> Auto creations of partitions > > > > > > This would be something like: > > > > > > create table foo ()

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Josh Berkus
Tom, Checking my copy of the "hit list", I thought we'd agreed to migrate contrib/oracle as well. Hmmm ... somehow that got dropped out of discussions early on, without any reason why. See the "more nuclear options" thread; oracle is nowhere on it. Will only take me 30 min to migrate, but

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Josh Berkus
Andrew, It seems odd to remove the module from contrib for 8.2 and then put a replacement in core for 8.3. I guess we could signal our intentions in the release notes. The current code is GPL. It *has* to be removed. --Josh ---(end of broadcast)

Re: [HACKERS] ISBN/ISSN/ISMN/EAN13 module

2006-09-05 Thread Tom Lane
"Jeremy Kronuz" <[EMAIL PROTECTED]> writes: > Hello again,This is an usable version of my EAN13/UPC/ISBN module. I'm reviewing this for addition to contrib/ now. I notice that there is no clear license statement. Is it OK to put the following into the README file? EAN13 - UPC - ISBN (books) -

Re: [HACKERS] Where is hstore?

2006-09-05 Thread Tom Lane
Teodor Sigaev <[EMAIL PROTECTED]> writes: >> AFAIR the authors have never proposed it for inclusion. > We'll be glad if hstore will be in main tarball. As I remember, when we > suggest > (may be, in private exchange of letters) to include it, somebody says that > hstore breaks "relational" in

Re: [HACKERS] Fixed length data types issue

2006-09-05 Thread Martijn van Oosterhout
On Tue, Sep 05, 2006 at 02:48:45PM +0100, Gregory Stark wrote: > > > So I'm thinking again about the problems with fixed length data types not > having typmod available when they would need it. But I'm having trouble > finding enough old posts to get a handle on exactly what the problem is. Like

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Tom Lane
Andrew Dunstan <[EMAIL PROTECTED]> writes: > It's a pity we didn't have Abhijit's patch 6 weeks ago. Well, now that we have it, the question is whether we want to do anything with it. One problem is it lacks documentation. However, as I said, I'd really rather choose a new API altogether. The m

Re: [HACKERS] TODO Request

2006-09-05 Thread Rocco Altier
> From: [EMAIL PROTECTED] > [mailto:[EMAIL PROTECTED] On Behalf Of Hannu Krosing > > Ühel kenal päeval, T, 2006-08-29 kell 22:12, kirjutas Joshua D. Drake: > > >> Auto creations of partitions > > > > This would be something like: > > > > create table foo () partition by ... > > from the refere

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Andrew Dunstan
Tom Lane wrote: Andrew - Supernews <[EMAIL PROTECTED]> writes: Userlock needs to go into core, not get removed; this was discussed in a previous "let's clean up contrib/" thread. Something like it ought to go into core, but personally I'd opt for taking the opportunity to redesign the

Re: [HACKERS] Open items for 8.2

2006-09-05 Thread Andrew Dunstan
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 <[EMAIL PROTECTED]> This one is actu

Re: [HACKERS] Fixed length data types issue

2006-09-05 Thread Tom Lane
Gregory Stark <[EMAIL PROTECTED]> writes: > So I'm thinking again about the problems with fixed length data types not > having typmod available when they would need it. But I'm having trouble > finding enough old posts to get a handle on exactly what the problem is. The problem is it isn't availab

Re: [HACKERS] integration of pgcluster into postgresql

2006-09-05 Thread Andrew Sullivan
On Sun, Aug 27, 2006 at 12:47:12PM -0400, Tom Lane wrote: > see some kind of joint proposal by multiple replication projects about > what hooks to add. Anybody out there want to organize such a thing? We were attempting to define such a set of hooks as part of the Slony-II work, but that sort of

Re: [HACKERS] [PATCHES] Gen_fmgrtab.sh fails with LANG=et_EE

2006-09-05 Thread Tom Lane
"Marko Kreen" <[EMAIL PROTECTED]> writes: > I grepped around source and did not find other instances of this. > The A-Z experssion was only in perl scripts or in configure and > configure should be fine as it explicitly resets locale. Why not do the same in Gen_fmgrtab.sh? A quick LANG=C seems le

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Abhijit Menon-Sen
At 2006-09-05 10:23:19 -0400, [EMAIL PROTECTED] wrote: > > Something like it ought to go into core, but personally I'd opt for > taking the opportunity to redesign the API, which was a bit crufty to > begin with. I'm happy to do the work right away (not that there's much) if someone suggests a bet

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Tom Lane
Andrew - Supernews <[EMAIL PROTECTED]> writes: > Userlock needs to go into core, not get removed; this was discussed in a > previous "let's clean up contrib/" thread. Something like it ought to go into core, but personally I'd opt for taking the opportunity to redesign the API, which was a bit cru

Re: [HACKERS] Ding-dong, contrib is dead ...

2006-09-05 Thread Tom Lane
Josh Berkus writes: > Migrated to pgFoundry: > adddepends (Greg) > dbmirror (Steve Singer) > dbase --> dbf2pg > fulltextindex --> simplefti > mac (LER) --> mac-manufacturer > userlock (Merlin) > Please also kill the following two contrib directories,

[HACKERS] Fixed length data types issue

2006-09-05 Thread Gregory Stark
So I'm thinking again about the problems with fixed length data types not having typmod available when they would need it. But I'm having trouble finding enough old posts to get a handle on exactly what the problem is. This would make a nice test of the new wiki. I would be indebted to whoever c

Re: [HACKERS] TODO item: GUID

2006-09-05 Thread Gevik Babakhani
> Do you really want to copy the code verbatim? I mean, there's a lot of > stuff which would need quite a bit of massaging to get working in > postgres. I'd say just look at it, understand it, and then write > something that will work. The copyright won't matter then. > This is a better idea i m

  1   2   >