Re: [HACKERS] Groups and roles

2003-06-09 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: ... Therefore I ask whether everyone agrees that groups and roles are basically equivalent concepts (and perhaps that we might in the future strive to make groups more compatible with the roles as defined in the SQL standard). Or does anyone see that

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

2003-06-09 Thread Tom Lane
Robert Treat [EMAIL PROTECTED] writes: I think this was touched on before, but was there a final determination of the ordering of the show all command? SHOW ALL will remain alphabetical. regards, tom lane ---(end of

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 fault

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

[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

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

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

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 backlog

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 an

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

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

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

[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] 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 and the

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

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] 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 about trading off

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

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

[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

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 getaddrinfo2()

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 1

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

[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: [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 ... or

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

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