> ------- 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 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 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 no good
> argument why it shouldn't.
Yup, exactly.
> There is fair room for argument about whether $sharedir is the
> appropriate place for installation-specific config files though.
> Those should probably live in the same place as postgresql.conf
> and friends, ie, typically but not necessarily $PGDATA. It doesn't
> look like SelectConfigFiles() saves the config directory name anyplace
> where an add-on module could get at it. We could perhaps fix that for
> 8.3, but it won't help Mark if he insists on a backwards-compatible
> solution. I suppose he could copy ConfigFileName and strip the last
> component from it?
Wouldn't be difficult, but I suspect Mark is probably using the path for the
PostGIS SQL scripts lwgeom.sql, spatial_ref_sys.sql etc. rather than config
files. But, I see he's found his bug now anyway.
/D
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
