[HACKERS] I know there are few hams on this list...

2001-05-15 Thread Vince Vielhaber
Ok, so this is off topic, but I know there are a few hams on this list. I'm wondering if any of them are going to Dayton this weekend? Probably better to contact me off list. Vince. -- == Vince Vielhaber -- KA8CSH

Re: [HACKERS] Installation on SGI IRIX 6.5.10

2001-05-15 Thread G. Anthony Reina
Tom Lane wrote: That absolutely should NOT be necessary; there should be a proper extern declaration of strdup visible. Perhaps it should be added to include/port/irix5.h (cf port/nextstep.h). regards, tom lane Just to make sure, I tried compiling on another SGI.

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Nathan Myers
On Tue, May 15, 2001 at 05:53:36PM -0400, Bruce Momjian wrote: But, if I may editorialize a little myself, this is just indicative of a 'Fortress PostgreSQL' attitude that is easy to get into. 'We've always I have to admit I like the sound of 'Fortress PostgreSQL'. :-) Ye Olde

AW: [HACKERS] pg_index.indislossy

2001-05-15 Thread Zeugswetter Andreas SB
Let's avoid removing things for the sake of removing them ... might be an old idea that, if someone takes the time to research, might prove useful ... Yea, there is actually some code attached to this vs. the others that had no code at all. Are we ever going to do partial indexes? I

AW: [HACKERS] pg_index.indislossy

2001-05-15 Thread Zeugswetter Andreas SB
One problem with keeping it is that interface coders are getting confused by some of the unused system table columns, assuming they mean something, when in fact they don't. Both ODBC and JDBC have had this problem that I fixed today. Imho the correct answer to this would be to implement

AW: [HACKERS] pg_index.indislossy

2001-05-15 Thread Zeugswetter Andreas SB
Can someone tell me what we use indislossy for? Ok, so the interpretation of this field is: A match in the index needs to be reevaluated in the heap tuple data, since a match in the index does not necessarily mean, that the heap tuple matches. If the heap

Re: [HACKERS] Internet is putting lot of competition fire heat under Microsoft SQL Server

2001-05-15 Thread Roberto Mello
On Tue, May 15, 2001 at 07:19:01AM -0400, D'Arcy J.M. Cain wrote: Everybody is asking What is the equivalent of Linux in SQL databases ?? The answer is PostgreSQL RDBMS server. Oh please. Can we stop trying to tie everything to the current front runner. I mean, PostgreSQL uses the

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane writes: This is of little value unless the default is intelligently chosen. The default should be $PGLIB, IMHO (inserted from configure's data). This default has little value as well. Users don't generally put their loadable modules in

Re: [HACKERS] State of PL/Python build

2001-05-15 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Tom Lane writes: I wonder whether people would like an option to statically link libperl.a and/or libpython.a into the Postgres backend proper? That would allow plperl/plpython to be used on platforms where this is an issue, without having to make

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
Peter Eisentraut [EMAIL PROTECTED] writes: Perhaps it would be good to make the empty path component equivalent to $libdir, e.g., Hmm, that would work, and also avoid having to figure out how to stuff $PGLIB into postgresql.conf during initdb. Sold as far as I'm concerned ...

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Trond Eivind Glomsrød
Tom Lane [EMAIL PROTECTED] writes: Peter Eisentraut [EMAIL PROTECTED] writes: Perhaps it would be good to make the empty path component equivalent to $libdir, e.g., Hmm, that would work, and also avoid having to figure out how to stuff $PGLIB into postgresql.conf during initdb. While

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
[EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: You could search in a path... first sysconfdir, then datadir. Surely the other way around. Which could work as well

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Trond Eivind Glomsrød
Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: You could search in a path... first sysconfdir, then datadir. Surely the

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Trond Eivind Glomsrød
Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: You could search in a path... first sysconfdir, then datadir. Surely the other way around. Which could work as well - or just a switch to postmaster to tell it which file to use. --

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
[EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: There is a security issue here: stuff stored in datadir is not visible to random other users on the machine (since datadir is mode 700), but I would not expect sysconfdir to be mode 700. It could be (the RPMs specify a

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
[EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: The real bottom line here, though, is that you haven't shown me any positive reason to move the config files out of datadir. It conflicts with the FHS - AFAIK, the FHS is not designed to support multiple instances of

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Trond Eivind Glomsrød
Tom Lane [EMAIL PROTECTED] writes: [EMAIL PROTECTED] (Trond Eivind =?iso-8859-1?q?Glomsr=F8d?=) writes: There is a security issue here: stuff stored in datadir is not visible to random other users on the machine (since datadir is mode 700), but I would not expect sysconfdir to be mode

Re: [HACKERS] Configurable path to look up dynamic libraries

2001-05-15 Thread Tom Lane
Lamar Owen [EMAIL PROTECTED] writes: Just because we've always done it one way does not that one way correct make. Sure. We're one component of a system -- and the PostgreSQL Group has done such a good job of being platform agnostic that the platform and systems issues are almost