Re: [HACKERS] ECPG regression failures on OpenBSD

On Tue, Sep 05, 2006 at 08:00:12AM +0200, Stefan Kaltenbrunner wrote: > After upgrading some of my buildfarm members to the latest version of > the buildfarm script both OpenBSD boxes startet to fail the ECPG > regression tests: > ... complex/test2 gets a segmentation fault on both machines. Could

Re: [HACKERS] ECPG regression failures on OpenBSD

Michael Meskes wrote: On Tue, Sep 05, 2006 at 08:00:12AM +0200, Stefan Kaltenbrunner wrote: After upgrading some of my buildfarm members to the latest version of the buildfarm script both OpenBSD boxes startet to fail the ECPG regression tests: ... complex/test2 gets a segmentation fault on bo

Re: [HACKERS] [DOCS] New XML section for documentation

On 8/26/06, Peter Eisentraut <[EMAIL PROTECTED]> wrote: Bruce Momjian wrote: > I made it clear in the section that the XML syntax was being checked, > not validation against a schema. You want Check and Validation > sections? "Valid" and "well-formed" have very specific distinct meanings in XML

[HACKERS] large object regression tests

Sorry if this gets through more than once, I seem to be having email difficulties... On Tue, 5 Sep 2006, Jeremy Drake wrote: > I noticed when I was working on a patch quite a while back that there are > no regression tests for large object support. I know, large objects > are not the most sexy p

Re: [HACKERS] pgcrypto deprecated functions?

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. Those functions still exist -- should > they be removed

[HACKERS] TODO item: GUID

I have two questions regarding the GUID todo item... 1. Do we want to have a new datatype for that or just a macro like the SERIAL type? create table bla ( my_pk GUID /* that is my_pk varchar(32) DEFAULT 'new_guid()' */ ) 2. Didn't we have a contrib module doing the GUID? Regards, Gevik.

Re: [HACKERS] ECPG regression failures on OpenBSD

> >> After upgrading some of my buildfarm members to the latest version of > >> the buildfarm script both OpenBSD boxes startet to fail the ECPG > >> regression tests: > >> ... > > > > complex/test2 gets a segmentation fault on both machines. Could you try > > running it under gdb to see where it

Re: [HACKERS] ECPG regression failures on OpenBSD

On Tue, Sep 05, 2006 at 11:58:41AM +0200, Stefan Kaltenbrunner wrote: > #0 0x0add8c83 in replace_variables (text=0x7e709780 "select name, born, > age, married, children from meskes where name = ?") at prepare.c:42 > ptr = 0x7e70a000 > string = 0 '\0' I think I found this one

Re: [HACKERS] ECPG regression failures on OpenBSD

On Tue, Sep 05, 2006 at 08:00:12AM +0200, Stefan Kaltenbrunner wrote: > http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=emu&dt=2006-09-05%2002:35:02 > > and > > http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=spoonbill&dt=2006-09-04%2023:50:05 Hmm, for some reason the x86 machine doesn't giv

[HACKERS] Question about 8-byte datatypes

Is int8 a passed-by-value data type on 64-bit platforms? How do we arrange for that to be the case? I don't see any magic in pg_type.h but I'm not sure what I'm looking for. I'm asking because I have another 8-byte data type I want to use and it would be nice to have that same property, assuming

Re: [HACKERS] ECPG regression failures on OpenBSD

On Tue, Sep 05, 2006 at 01:08:48PM +0200, Stefan Kaltenbrunner wrote: > FYI: complex/test2 fails on lionfish (my linux/mipsel box) too: > > http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=lionfish&dt=2006-09-05%2005:30:07 This needs some debugging. The output difference comes from an indicator

Re: [HACKERS] TODO item: GUID

On Tue, Sep 05, 2006 at 11:29:40AM +0200, Gevik Babakhani wrote: > I have two questions regarding the GUID todo item... > > 1. Do we want to have a new datatype for that or just a macro like the > SERIAL type? A new datatype. Just because someone has a guid column doesn't mean they want it autog

Re: [HACKERS] Question about 8-byte datatypes

On Tue, Sep 05, 2006 at 11:16:06AM +0100, Gregory Stark wrote: > > Is int8 a passed-by-value data type on 64-bit platforms? How do we arrange for > that to be the case? I don't see any magic in pg_type.h but I'm not sure what > I'm looking for. Not AFAIK. It would involve fiddeling the catalog, t

Re: [HACKERS] ECPG regression failures on OpenBSD

Michael Meskes wrote: On Tue, Sep 05, 2006 at 01:08:48PM +0200, Stefan Kaltenbrunner wrote: FYI: complex/test2 fails on lionfish (my linux/mipsel box) too: http://www.pgbuildfarm.org/cgi-bin/show_log.pl?nm=lionfish&dt=2006-09-05%2005:30:07 This needs some debugging. The output difference come

Re: [HACKERS] ECPG regression failures on OpenBSD

> > will try to get a backtrace soon - if you are trying to do your own > > testing keep in mind that both boxes of mine do run with special > > malloc-settings (as in FGJZ) as discussed in: > > > > http://archives.postgresql.org/pgsql-hackers/2005-06/msg00817.php > > > > while I'm not sure y

Re: [HACKERS] Open items for 8.2

Tom Lane wrote: > Alvaro Herrera <[EMAIL PROTECTED]> 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

[HACKERS] Dead code?

Is there anywhere we make use of this code that handles attlen == -2? If so I'm curious where because I was thinking of doing something similar and didn't realise we already had this capability. But I suspect it's just dead code left over, possibly from the days before the Name data type? /*

Re: [HACKERS] TODO item: GUID

For developing the GUID datatype, I was wondering if I could use the sample code from http://www.ietf.org/rfc/rfc4122.txt (hate to reinvent the wheel) The code has a copyright which says: "use and modify as you wish but include the copyright notice with your code" What are our rules is such matte

Re: [HACKERS] Dead code?

Martijn van Oosterhout writes: > attlen -2 is used for cstring (null terminated strings). > > Hope this helps, Well that's what the code I quoted indicates. But when do we ever store a cstring in a tuple? Certainly I can't find any standard data types that use it. -- Gregory Stark Enterpri

Re: [HACKERS] Dead code?

On Tue, Sep 05, 2006 at 01:21:46PM +0100, Gregory Stark wrote: > > > > Is there anywhere we make use of this code that handles attlen == -2? > > If so I'm curious where because I was thinking of doing something similar and > didn't realise we already had this capability. But I suspect it's just

Re: [HACKERS] Dead code?

On Tue, Sep 05, 2006 at 01:42:57PM +0100, Gregory Stark wrote: > Martijn van Oosterhout writes: > > > attlen -2 is used for cstring (null terminated strings). > > > > Hope this helps, > > Well that's what the code I quoted indicates. But when do we ever store a > cstring in a tuple? Certainly I

Re: [HACKERS] TODO item: GUID

On Tue, Sep 05, 2006 at 02:29:15PM +0200, Gevik Babakhani wrote: > For developing the GUID datatype, I was wondering if I could use the > sample code from http://www.ietf.org/rfc/rfc4122.txt (hate to reinvent > the wheel) > > The code has a copyright which says: "use and modify as you wish but > i

Re: [HACKERS] TODO item: GUID

> 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

[HACKERS] Fixed length data types issue

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] Ding-dong, contrib is dead ...

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,

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

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 ...

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] integration of pgcluster into postgresql

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] Fixed length data types issue

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] Open items for 8.2

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] [PATCHES] Gen_fmgrtab.sh fails with LANG=et_EE

"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 ...

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] TODO Request

> 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 ...

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] Fixed length data types issue

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] Where is hstore?

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] ISBN/ISSN/ISMN/EAN13 module

"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] Ding-dong, contrib is dead ...

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] Ding-dong, contrib is dead ...

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] TODO Request

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 ...

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] Ding-dong, contrib is dead ...

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 ...

"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 ...

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 ...

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 ...

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] [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL

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] [COMMITTERS] pgsql: sslinfo contrib module - information about current SSL

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] Where is hstore?

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] [PATCHES] Gen_fmgrtab.sh fails with LANG=et_EE

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] Ding-dong, contrib is dead ...

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] Ding-dong, contrib is dead ...

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] [PATCHES] Gen_fmgrtab.sh fails with LANG=et_EE

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 ...

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] Ding-dong, contrib is dead ...

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 ...

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 ...

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 ...

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 ...

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] Open items for 8.2

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 ...

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] Ding-dong, contrib is dead ...

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] Win32 hard crash problem

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] Win32 hard crash problem

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

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

> >> 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

"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] pgcrypto deprecated functions?

"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] Open items for 8.2

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] Open items for 8.2

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] Win32 hard crash problem

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] updatable views and default values

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] Open items for 8.2

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] Open items for 8.2

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] Win32 hard crash problem

"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] [PATCHES] Gen_fmgrtab.sh fails with LANG=et_EE

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] Win32 hard crash problem

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] [PATCHES] Backend SSL configuration enhancement

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] pgcrypto deprecated functions?

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] Win32 hard crash problem

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] Win32 hard crash problem

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] Ding-dong, contrib is dead ...

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

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

[HACKERS] New Linux Filesystem: NILFS

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

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

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

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] [PATCHES] Updatable views

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] Win32 hard crash problem

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] ISBN/ISSN/ISMN/EAN13 module

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

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] Win32 hard crash problem

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] New Linux Filesystem: NILFS

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

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] Open items for 8.2

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

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] [PATCHES] WIP: bitmap indexes

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] ISBN/ISSN/ISMN/EAN13 module

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] Win32 hard crash problem

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] Win32 hard crash problem

-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] Open items for 8.2

[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

  1   2   >