Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-09 Thread Bruce Momjian
scott.marlowe wrote: > On Fri, 6 Jun 2003, Bruce Momjian wrote: > > > scott.marlowe wrote: > > > On Fri, 6 Jun 2003, Peter Eisentraut wrote: > > > > > > > scott.marlowe writes: > > > > > > > > > If indexes on text worked right in other locales it would be no big deal. > > > > > > > > They will

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Bruce Momjian
Josh Berkus wrote: > Tom, > > Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the > option that's supposed to let you turn off "Inserting missing FROM clause for > table ..." > > I thought that patch was accepted 3 weeks ago? Is this just missing from > postgresql.conf.s

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Bruce Momjian
Josh Berkus wrote: > Tom, Justin, > > > Um, not documenting it is probably not a good move for us, however putting > > it at the end in a section marked "Developer Focused" or something similar > > would probably have the right mix of messages. i.e. "hands off" + "not a > > performance tweak", et

[HACKERS] Lists are up again

2003-06-09 Thread Bruce Momjian
OK, looks like the lists are up again. I will start applying patches in 9 hours. -- Bruce Momjian| http://candle.pha.pa.us [EMAIL PROTECTED] | (610) 359-1001 + If your life is a hard drive, | 13 Roberts Road + Christ can be your backup.

Re: [HACKERS] cvs ETA?

2003-06-09 Thread Dave Cramer
Actually I was only looking for cvs, by the time this message made it to the list, it was working. Dave On Mon, 2003-06-09 at 00:21, Alvaro Herrera wrote: > On Sun, Jun 08, 2003 at 10:33:03AM -0300, The Hermit Hacker wrote: > > > > ?? cvs itself has been working for ages now ... anoncvs isn't ..

[HACKERS] Character encoding

2003-06-09 Thread Dennis Björklund
I've been playing with character encodings and found a problem/bug. I still use 7.3.2, so it's possible (but I think not) that some of this have been fixed. When you run psql with a different language then english the strings are usually in a character set that is not pure ascii. For example to re

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Josh Berkus
Folks, Attached is another order outline for the Postgresql.conf parameters, updated for 7.4. Please examine it, and then give your opinions on the following: 1) Should "enable_implicit_from" go in the "Version/Platform Compatibility" section where I have it now, or in "CLIENT CONNECTIONS-Sta

Re: [HACKERS] freeaddrinfo2 changes.

2003-06-09 Thread Tom Lane
Kurt Roeckx <[EMAIL PROTECTED]> writes: >> If this is broken then it's probably not the only problem --- we rely on >> sa.sa_family in other places. > sa.sa_family is not the problem itself, the problem is that if > you use getaddrinfo with AF_UNSPEC, you can get more than replies > with more than

Re: [HACKERS] freeaddrinfo2 changes.

2003-06-09 Thread Kurt Roeckx
On Mon, Jun 09, 2003 at 10:09:20AM -0400, Tom Lane wrote: > Kurt Roeckx <[EMAIL PROTECTED]> writes: > > I just saw in the cvs web that you changed freeaddrinfo2 to not > > have the hint af anymore, and use the one from the struct addrinfo > > itself. > > > This can break things. If you called get

[HACKERS] native bi-temporal support?

2003-06-09 Thread Andrew Piskorski
Do you know of anyone working on bi-temporal support for PostgreSQL, especially native support in PostgreSQL itself? Any comments from anyone who's looked into or been interested in this in the past? A while back, some folks pointed out[1] an excellent book[2] by Snodgrass[3], Developing Time-Ori

Re: [HACKERS] [INTERFACES] Some quick notes about extending libpq for new protocol

2003-06-09 Thread Tom Lane
Jonathan Gardner <[EMAIL PROTECTED]> writes: > I'll admit -- the current state of PQfn is practically unuseable. However, the > idea is pretty cool. I think it would be nice to have a direct function call > mechanism that bypasses the parser. The ability to prepare a "SELECT foo($1, $2, ...)" st

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Justin Clift
Tom Lane wrote: Josh Berkus <[EMAIL PROTECTED]> writes: "wal_debug" is seldom used outside of Postgresql source development or unusual system failures, and should therefore go last. BTW, it occurs to me that wal_debug is one of the hacker-only variables that probably ought not be documented at al

Re: [HACKERS] default locale considered harmful? (was Re: [GENERAL]

2003-06-09 Thread scott.marlowe
On Fri, 6 Jun 2003, Bruce Momjian wrote: > scott.marlowe wrote: > > On Fri, 6 Jun 2003, Peter Eisentraut wrote: > > > > > scott.marlowe writes: > > > > > > > If indexes on text worked right in other locales it would be no big deal. > > > > > > They will in version 7.4, so all these concerns abo

Re: [HACKERS] cvs ETA?

2003-06-09 Thread Andrew Dunstan
It's what I tried to use over the weekend, so I could start on a doc patch ... restoring it would probably help a number of people. andrew Marc wrote: > > ?? cvs itself has been working for ages now ... anoncvs isn't ... or > is that what you are using? > > On Thu, 5 Jun 2003, Dave Cramer wrote

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Josh Berkus
Tom, Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the option that's supposed to let you turn off "Inserting missing FROM clause for table ..." I thought that patch was accepted 3 weeks ago? Is this just missing from postgresql.conf.sample? -- -Josh Berkus Aglio Dat

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Josh Berkus
Tom, Justin, > Um, not documenting it is probably not a good move for us, however putting > it at the end in a section marked "Developer Focused" or something similar > would probably have the right mix of messages. i.e. "hands off" + "not a > performance tweak", etc. So, proposal: 1) wal_debug

[HACKERS] freeaddrinfo2 changes.

2003-06-09 Thread Kurt Roeckx
I just saw in the cvs web that you changed freeaddrinfo2 to not have the hint af anymore, and use the one from the struct addrinfo itself. This can break things. If you called getaddrinfo2() with AF_UNSPEC, the version from the system can return an AF_UNIX socket. For instance glibc 2.1 will do

Re: [HACKERS] Groups and roles

2003-06-09 Thread Oleg Bartunov
Just interesting if we could inplement some kind of RBAC (role based access control). Here is the reference: http://csrc.nist.gov/rbac/ We've used a lot simple (flat) RBAC built on top of postgresql, but would like to see more powerful (with roles hierarchy) rbac built-in. Oleg On Sat, 7

Re: [HACKERS] cvs ETA?

2003-06-09 Thread Kurt Roeckx
On Sun, Jun 08, 2003 at 10:33:03AM -0300, The Hermit Hacker wrote: > > ?? cvs itself has been working for ages now ... anoncvs isn't ... or is > that what you are using? What else would we be using? Kurt ---(end of broadcast)--- TIP 3: if posti

Re: [HACKERS] security flaw

2003-06-09 Thread Robert Treat
On Sat, 2003-06-07 at 14:04, [EMAIL PROTECTED] wrote: > Hi all, > > I wonder if it's a security problem: One of my customer noticed that he > could see all databases on the system with phppgadmin. not only he sees > databases but tables, views, fonctions... Fortunatly he can't see any row. > > Th

Re: [HACKERS] freeaddrinfo2 changes.

2003-06-09 Thread Tom Lane
Kurt Roeckx <[EMAIL PROTECTED]> writes: > I just saw in the cvs web that you changed freeaddrinfo2 to not > have the hint af anymore, and use the one from the struct addrinfo > itself. > This can break things. If you called getaddrinfo2() with > AF_UNSPEC, the version from the system can return a

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Josh Berkus
Tom, > Bruce hasn't applied that patch yet. I believe he's starting to catch > up the patch backlog today, though. > > BTW there is also a pending patch that will add a GUC variable to > control "rendezvous" on Darwin. I had forgotten what-all was in the > patch queue until I looked this mornin

Re: [HACKERS] Proposal to Re-Order Postgresql.Conf, part II

2003-06-09 Thread Tom Lane
Josh Berkus <[EMAIL PROTECTED]> writes: > Hey, I'm looking at the postgresql.conf.sample in CVS, and can't find the > option that's supposed to let you turn off "Inserting missing FROM clause for > table ..." Bruce hasn't applied that patch yet. I believe he's starting to catch up the patch back

Re: [GENERAL] [HACKERS] large objects

2003-06-09 Thread Tom Lane
"Nigel J. Andrews" <[EMAIL PROTECTED]> writes: > Ok, I tried to try this but I can not get SSL to _not_ be used when > connecting via any tcp connection, unless the client hasn't been built > with ssl support of course. Yeah, I believe that's the way it works. It seems overly fascist of the SSL c

[HACKERS] neptune back up and being configured ...

2003-06-09 Thread The Hermit Hacker
Just a quick note that we just brought neptune back up and are re-configuring her (getting the OS updated, patch applied for memory leak, etc) Teodor, I have your list of modules and am in the process of getting postgresql 7.3.3 installed ... will get the mailware DB back up and configured iwth t

Re: [HACKERS] Debugging tool for viewing parse trees?

2003-06-09 Thread Bruce Momjian
Sure, see the debug_ variables in postgresql.conf or via SHOW ALL, and then set client_log_messages to DEBUG. Also look at debug_pretty_print. --- Eric D Nielsen wrote: > I've gotten back to working on the SQL99 version of

[HACKERS] Archives re-generating ...

2003-06-09 Thread The Hermit Hacker
http://archives.postgresql.org is slowly being re-generated from the base majordomo archive files, and the search index is ... indexing. Marc G. Fournier ICQ#7615664 IRC Nick: Scrappy Systems Administrator @ hub.org primary: [EMAIL PROTECTED] secondary:

[HACKERS] svr1 moved ...

2003-06-09 Thread Marc G. Fournier
okay, the developer VM has been moved back to its server ... I've checked everything I can think of and it all seems to be fine ... mail, ftp all running ... I'll be working on fixing up the other stuff over the next few days (ie. anoncvs, archives) ... ---(end of broadc

Re: [HACKERS] cvs ETA?

2003-06-09 Thread Alvaro Herrera
On Sun, Jun 08, 2003 at 10:33:03AM -0300, The Hermit Hacker wrote: > > ?? cvs itself has been working for ages now ... anoncvs isn't ... or is > that what you are using? I think that'd be it... I'm waiting for CVSup too. ("Cannot connect to cvsup.postgresql.org: Connection refused") -- Alvaro

Re: [HACKERS] Wrong version of jdbc in 7.3.3 rpms

2003-06-09 Thread Tom Lane
Barry Lind <[EMAIL PROTECTED]> writes: > There are a number of reasons that IMHO moving the source out of the > core project does not make sense for jdbc: If I'm not misunderstanding here, the problem is that the JDBC sources in the REL7_3 branch are current (if not, I'd say this is not Lamar's fa