Fw: [HACKERS] Translators wanted

2001-07-31 Thread Serguei Mokhov
Sorry for posting this messages into the list. It was intended for Peter E., but it looks like his personal mailbox is over quota... Hopefully, he will scan through the posts in the list once he's back from vacation, and the message won't get lost. Serguei - Original Message - From: Se

Fw: [HACKERS] Translators wanted

2001-07-31 Thread Serguei Mokhov
The same applies as to my previous post... Sorry again. S. - Original Message - From: Serguei Mokhov <[EMAIL PROTECTED]> To: Peter Eisentraut <[EMAIL PROTECTED]> Sent: Wednesday, August 01, 2001 1:50 AM Subject: Re: [HACKERS] Translators wanted > - Original Message - > From:

Re: [HACKERS] LIBPQ on Windows and large Queries

2001-07-31 Thread Steve Howe
Hello all, I was in a trip and just arrived, and will do it real soon. Best Regards, Steve Howe - Original Message - From: "Tom Lane" <[EMAIL PROTECTED]> To: "Hiroshi Inoue" <[EMAIL PROTECTED]> Cc: "Steve Howe" <[EMAIL PROTECTED]>; <[EMAIL PROTECTED]> Sent: Sunday, July 29, 20

Re: [HACKERS] vacuumlo.

2001-07-31 Thread Bruce Momjian
> > > > IIRC vacuumlo doesn't take the type lo(see contrib/lo) into > > > > account. I'm suspicious if vacuumlo is reliable. > > > > > > This was my round about way of asking if something to combat this issue > > > can be placed in the to do list. :) > > > > Added to TODO: > > > > * Impr

Re: [HACKERS] vacuumlo.

2001-07-31 Thread Hiroshi Inoue
Bruce Momjian wrote: > > > > > > Can you see a scenario where a programmer would forget to delete the > > > > > data from pg_largeobject and the database becoming very large filled > > > > > with orphaned large objects? > > > > > > > > Sure. My point wasn't that the functionality isn't needed, it

Re: [HACKERS] Re: pg_hba.conf pre-parsing change

2001-07-31 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > >> In any case, if we don't change the code, the change in behavior from > >> prior releases needs to be documented... > > > You mean in the SGML or in the release highlight text? > > Both. client_auth.sgml specifically states that editing the file

Re: [HACKERS] Re: pg_hba.conf pre-parsing change

2001-07-31 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> In any case, if we don't change the code, the change in behavior from >> prior releases needs to be documented... > You mean in the SGML or in the release highlight text? Both. client_auth.sgml specifically states that editing the file is sufficient

Re: [HACKERS] Re: pg_hba.conf pre-parsing change

2001-07-31 Thread Lamar Owen
On Tuesday 31 July 2001 19:20, Tom Lane wrote: > Bruce Momjian <[EMAIL PROTECTED]> writes: > > We could, but we don't with postgresql.conf so it made sense to keep the > > behavior the same for the two files. > I'm inclined to agree --- for one thing, this allows one to edit the > files in place

[HACKERS] Re: [PATCHES] Allow IDENT authentication on local connections (Linuxonly)

2001-07-31 Thread Bruce Momjian
> BTW, while digging through my mail archives I discovered that Oliver > *did* already extract his "peer" auth patch and submit it as a proposed > patch --- see the pghackers archives for 3-May-2001. At the time I > think we were concerned about portability issues, but as long as it's > appropria

[HACKERS] Re: [PATCHES] Allow IDENT authentication on local connections (Linux only)

2001-07-31 Thread Tom Lane
BTW, while digging through my mail archives I discovered that Oliver *did* already extract his "peer" auth patch and submit it as a proposed patch --- see the pghackers archives for 3-May-2001. At the time I think we were concerned about portability issues, but as long as it's appropriately autoc

Re: [HACKERS] Re: pg_hba.conf pre-parsing change

2001-07-31 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > >> Would it make sense to do fstat calls on these files and reload whenever > >> we observe that the file modification time has changed? That'd be an > >> additional kernel call per connection attempt, so I'm not at all sure > >> I want to do it ... b

[HACKERS] Re: pg_hba.conf pre-parsing change

2001-07-31 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> Would it make sense to do fstat calls on these files and reload whenever >> we observe that the file modification time has changed? That'd be an >> additional kernel call per connection attempt, so I'm not at all sure >> I want to do it ... but it ough

[HACKERS] Re: pg_hba.conf pre-parsing change

2001-07-31 Thread Bruce Momjian
> Bruce Momjian - CVS <[EMAIL PROTECTED]> writes: > > Load pg_hba.conf and pg_ident.conf on startup and SIGHUP into List of > > Lists, and use that for user validation. > > While this should be a nice speedup, it bothers me somewhat that the old > behavior of reacting immediately to pg_hb

Re: [HACKERS] Re: [PATCHES] Allow IDENT authentication on local connections(Linux only)

2001-07-31 Thread Bruce Momjian
Can you send over your version for review. We can edit the 'peer' part. > Tom Lane wrote: > >[ redirected to pgsql-hackers for comment ] > > > >Helge Bahmann <[EMAIL PROTECTED]> writes: > >> On Tue, 31 Jul 2001, Tom Lane wrote: > >>> There is a more complete version of this capabilit

[HACKERS] pg_hba.conf pre-parsing change

2001-07-31 Thread Tom Lane
Bruce Momjian - CVS <[EMAIL PROTECTED]> writes: > Load pg_hba.conf and pg_ident.conf on startup and SIGHUP into List of > Lists, and use that for user validation. While this should be a nice speedup, it bothers me somewhat that the old behavior of reacting immediately to pg_hba.conf a

[HACKERS] Re: Update to 7.1.2 Question...

2001-07-31 Thread mlw
gabriel wrote: > > hello all > I have a postgresql 7.0 > and I'm trying to update to 7.1.2 using rpms > but some files is missing > like: > libcrypto.so.0 > libssl.so.0 > > anyone knows what package i can find this files?? > > thanks... > > ---(end of broadcast)

[HACKERS] Re: [PATCHES] Allow IDENT authentication on local connections (Linux only)

2001-07-31 Thread Oliver Elphick
Tom Lane wrote: >[ redirected to pgsql-hackers for comment ] > >Helge Bahmann <[EMAIL PROTECTED]> writes: >> On Tue, 31 Jul 2001, Tom Lane wrote: >>> There is a more complete version of this capability in the Debian patch >>> set. I think we've been waiting for Oliver to pull it out a

Re: [HACKERS] Update to 7.1.2 Question...

2001-07-31 Thread Trond Eivind Glomsrød
"gabriel" <[EMAIL PROTECTED]> writes: > hello all > I have a postgresql 7.0 > and I'm trying to update to 7.1.2 using rpms > but some files is missing > like: > libcrypto.so.0 > libssl.so.0 > > anyone knows what package i can find this files?? openssl -- Trond Eivind Glomsrød Red Hat, Inc. -

[HACKERS] Update to 7.1.2 Question...

2001-07-31 Thread gabriel
hello all I have a postgresql 7.0 and I'm trying to update to 7.1.2 using rpms but some files is missing like: libcrypto.so.0 libssl.so.0 anyone knows what package i can find this files?? thanks... ---(end of broadcast)--- TIP 4: Don't 'kill -9'

Re: [HACKERS] Re: Returned mail: User unknown

2001-07-31 Thread Marc G. Fournier
Should be fixed ... meant to respond as soon as I fixed it, but got onto something else at the time :( On Tue, 31 Jul 2001, Bruce Momjian wrote: > > Grant <[EMAIL PROTECTED]> writes: > > > Is it just me or is an address on the hackers list who's mail is handled > > > by wmail.metro.taejon.kr no

[HACKERS] Re: [PATCHES] Allow IDENT authentication on local connections (Linux only)

2001-07-31 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: >> ... But Oliver may feel that he has to >> continue to support the "peer" keyword on Debian anyway, for backwards >> compatibility. If so, do we want different ways of doing the same thing >> on different distros, or should we just follow the Debian pre

[HACKERS] Re: From TODO, XML?

2001-07-31 Thread mlw
Gilles DAROLD wrote: > > Hi, > > Why don't use the excellent DBIx-XML_RDB perl module ? Give it the query > it will return XML output as you sample. With some hack you can do what you > want... > The point I was trying to make is that XML is trivial to create. It is much more difficult to read.

[HACKERS] Re: [PATCHES] Allow IDENT authentication on local connections (Linuxonly)

2001-07-31 Thread Bruce Momjian
> Bruce Momjian <[EMAIL PROTECTED]> writes: > >> ... But Oliver may feel that he has to > >> continue to support the "peer" keyword on Debian anyway, for backwards > >> compatibility. If so, do we want different ways of doing the same thing > >> on different distros, or should we just follow the

[HACKERS] Re: [PATCHES] Allow IDENT authentication on local connections (Linuxonly)

2001-07-31 Thread Bruce Momjian
> [ redirected to pgsql-hackers for comment ] > > Helge Bahmann <[EMAIL PROTECTED]> writes: > > On Tue, 31 Jul 2001, Tom Lane wrote: > >> There is a more complete version of this capability in the Debian patch > >> set. I think we've been waiting for Oliver to pull it out and submit it > >> as a

Re: [HACKERS] [Fwd: Majordomo Delivery Error]

2001-07-31 Thread Vince Vielhaber
On Tue, 31 Jul 2001, Tom Lane wrote: > "Timothy H. Keitt" <[EMAIL PROTECTED]> writes: > > Anyone else getting these? Are these supposed to go to list subscribers? > > Was it a bounceback from wmail.metro.taejon.kr? They seem to have some > rather broken mail delivery software in place there. B

[HACKERS] Re: [PATCHES] Allow IDENT authentication on local connections (Linux only)

2001-07-31 Thread Tom Lane
[ redirected to pgsql-hackers for comment ] Helge Bahmann <[EMAIL PROTECTED]> writes: > On Tue, 31 Jul 2001, Tom Lane wrote: >> There is a more complete version of this capability in the Debian patch >> set. I think we've been waiting for Oliver to pull it out and submit it >> as a patch... > O

Re: [HACKERS] [Fwd: Majordomo Delivery Error]

2001-07-31 Thread Tom Lane
"Timothy H. Keitt" <[EMAIL PROTECTED]> writes: > Anyone else getting these? Are these supposed to go to list subscribers? Was it a bounceback from wmail.metro.taejon.kr? They seem to have some rather broken mail delivery software in place there. Bruce and I have both asked Marc to remove that

Re: [HACKERS] Re: From TODO, XML?

2001-07-31 Thread Gilles DAROLD
Hi, Why don't use the excellent DBIx-XML_RDB perl module ? Give it the query it will return XML output as you sample. With some hack you can do what you want... Regards Gilles DAROLD mlw wrote: > Bruce Momjian wrote: > > > > > > > I have managed to get several XML files into PostgreSQL by wri

[HACKERS] [Fwd: Majordomo Delivery Error]

2001-07-31 Thread Timothy H. Keitt
Anyone else getting these? Are these supposed to go to list subscribers? Tim Original Message Subject: Majordomo Delivery Error Date: Tue, 31 Jul 2001 09:43:58 -0400 (EDT) From: [EMAIL PROTECTED] To: [EMAIL PROTECTED] This message was created automatically by mail delivery

Re: [HACKERS] Performance TODO items

2001-07-31 Thread Bruce Momjian
> On Mon, 30 Jul 2001, Bruce Momjian wrote: > > > * Improve spinlock code, perhaps with OS semaphores, sleeper queue, or > > spining to obtain lock on multi-cpu systems > > You may be interested in a discussion which happened over on > linux-kernel a few months ago. > > Quite a lot of people

[HACKERS] Re: From TODO, XML?

2001-07-31 Thread mlw
Bruce Momjian wrote: > > > > > I have managed to get several XML files into PostgreSQL by writing a parser, > > > > and it is a huge hassle, the public parsers are too picky. I am thinking that a > > > > fuzzy parser, combined with some intelligence and an XML DTD reader, could make > > > > a ver

Re: [HACKERS] vacuumlo.

2001-07-31 Thread Bruce Momjian
> > > > Can you see a scenario where a programmer would forget to delete the > > > > data from pg_largeobject and the database becoming very large filled > > > > with orphaned large objects? > > > > > > Sure. My point wasn't that the functionality isn't needed, it's that > > > I'm not sure vacuu

Re: [HACKERS] Re: Returned mail: User unknown

2001-07-31 Thread Bruce Momjian
> Grant <[EMAIL PROTECTED]> writes: > > Is it just me or is an address on the hackers list who's mail is handled > > by wmail.metro.taejon.kr not existant? > > I've had to institute a sendmail access block against that site :-( > It bounces a useless complaint for every damn posting I make. What

Re: [HACKERS] Performance TODO items

2001-07-31 Thread Matthew Kirkwood
On Mon, 30 Jul 2001, Bruce Momjian wrote: > * Improve spinlock code, perhaps with OS semaphores, sleeper queue, or > spining to obtain lock on multi-cpu systems You may be interested in a discussion which happened over on linux-kernel a few months ago. Quite a lot of people want a lightweight