Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Peter Eisentraut
Tom Lane wrote: > Yeah, that's what I think he said too, but it strikes me as a completely > bogus policy --- what about contrib modules or stuff from pgfoundry > or any random user-written module that was built with PGXS?  All that > stuff happily drops files under $libdir and $sharedir, and I see

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Tom Lane
Mark Cave-Ayland <[EMAIL PROTECTED]> writes: > Okay, I'll try and expand on this a bit. In order to convert coordinates > between different coordinate systems, PostGIS uses the external PROJ.4 > library. Now in order to support a certain category of conversion, > PROJ.4 requires access to a set of

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Dave Page
> --- Original Message --- > From: Tom Lane <[EMAIL PROTECTED]> > To: "Dave Page" <[EMAIL PROTECTED]> > Sent: 26/11/07, 22:30:17 > Subject: Re: [HACKERS] Locating sharedir in PostgreSQL on Windows > > "Dave Page" <[EMAIL PROTEC

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Mark Cave-Ayland
On Mon, 2007-11-26 at 17:02 -0500, Tom Lane wrote: > I believe that that is talking specifically about shared libraries (or > DLLs in Windows-speak), and not about configuration or data files. > In particular, nothing under libdir would be a candidate to go under > sharedir, nor vice versa, since

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Tom Lane
"Dave Page" <[EMAIL PROTECTED]> writes: > Yes, I know. Peter seemed to be saying that nothing except postgres > itself should be in *any* of the installation directories Yeah, that's what I think he said too, but it strikes me as a completely bogus policy --- what about contrib modules or stuff fr

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Dave Page
> --- Original Message --- > From: Tom Lane <[EMAIL PROTECTED]> > To: "Dave Page" <[EMAIL PROTECTED]> > Sent: 26/11/07, 22:02:09 > Subject: Re: [HACKERS] Locating sharedir in PostgreSQL on Windows > > > I believe that that is talking spe

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Mark Cave-Ayland
On Mon, 2007-11-26 at 11:55 -0500, Tom Lane wrote: > I'm not sure why Mark's having a problem accessing my_exec_path --- > it *is* declared DLLIMPORT in miscadmin.h (which is where it counts, > AIUI) clear back to 8.0. Bah, I think that is the source of the problem. Having grepped the source for

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Tom Lane
"Dave Page" <[EMAIL PROTECTED]> writes: > From: Peter Eisentraut <[EMAIL PROTECTED]> >> Which documented recommendation do you speak of? > http://www.postgresql.org/docs/8.3/static/xfunc-c.html states: > It is recommended to locate shared libraries either relative to $libdir or > through the dyna

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Dave Page
> --- Original Message --- > From: Peter Eisentraut <[EMAIL PROTECTED]> > To: Dave Page <[EMAIL PROTECTED]> > Sent: 26/11/07, 20:14:25 > Subject: Re: [HACKERS] Locating sharedir in PostgreSQL on Windows > > Dave Page wrote: > > How does

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Peter Eisentraut
Tom Lane wrote: > Peter Eisentraut <[EMAIL PROTECTED]> writes: > > Am Montag, 26. November 2007 schrieb Mark Cave-Ayland: > >> I'm working on a piece of code for PostGIS to allow the loading of > >> projection configuration files from the share/postgresql directory, but > > > > The share directory

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Peter Eisentraut
Dave Page wrote: > How does that work with the stuff that goes into directories relative to > $libdir (per documented recommendations), without creating easy-to-break > paths like $libdir/../../MyAddon/8.3/MyAddon.dll? Which documented recommendation do you speak of? -- Peter Eisentraut http://d

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Dave Page
Peter Eisentraut wrote: > Am Montag, 26. November 2007 schrieb Mark Cave-Ayland: >> I'm working on a piece of code for PostGIS to allow the loading of >> projection configuration files from the share/postgresql directory, but > > The share directory is the wrong place for configuration files anywa

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Tom Lane
Peter Eisentraut <[EMAIL PROTECTED]> writes: > Am Montag, 26. November 2007 schrieb Mark Cave-Ayland: >> I'm working on a piece of code for PostGIS to allow the loading of >> projection configuration files from the share/postgresql directory, but > The share directory is the wrong place for config

Re: [HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Peter Eisentraut
Am Montag, 26. November 2007 schrieb Mark Cave-Ayland: > I'm working on a piece of code for PostGIS to allow the loading of > projection configuration files from the share/postgresql directory, but The share directory is the wrong place for configuration files anyway. And moreover, non-PostgreSQ

[HACKERS] Locating sharedir in PostgreSQL on Windows

2007-11-26 Thread Mark Cave-Ayland
Hi everyone, I'm working on a piece of code for PostGIS to allow the loading of projection configuration files from the share/postgresql directory, but I can't find a way of getting this to work under Win32. AIUI the way to do this would be to use a combination of my_exec_path and get_share_path