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 Pos

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 sec

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

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 u

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 specif

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

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 wo

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: > You could search in a path... first sysconfdir, then datadir. Surely the other way around. regards, tom lane ---(end of broadcast)--- TIP 6: Have you s

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: > > While on the subject of postgresql conf... shouldn't it be in > > sysconfdir instead of the database directory? > > No. That would (a) not allow different postmasters to have differen

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 initd

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

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 havin

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 mod

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

2001-05-15 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > About to be implemented, for your approval... > Variable name: dynamic_library_path > Permissions: superuser > Default value: empty string This is of little value unless the default is intelligently chosen. The default should be "$PGLIB", IMHO (inser

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

Re: [HACKERS] please apply patch for GiST (7.1.1, current cvs)

2001-05-15 Thread Tom Lane
Bruce Momjian <[EMAIL PROTECTED]> writes: > Applied to 7.1.1 and 7.2. Thanks. You seem to have missed the REL7_1_STABLE branch ... regards, tom lane ---(end of broadcast)--- TIP 4: Don't 'kill -9' the postmaster

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

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 t

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