BUG #6045: Compilation of contribs fail
The following bug has been logged online:
Bug reference: 6045
Logged by: Emanuel
Email address: postgres.arg@gmail.com
PostgreSQL version: 9.1beta
Operating system: Ubuntu 10.04 2.6.31
Description: Compilation of contribs fail
Details:
make and make installs work well. To compile correctly I must hardcode the
libdir. I happens with several contribs.
root@dell-desktop:/home/ecalvo-laptop/postgresql-9.1beta1/contrib/pgstattupl
e# /usr/local/pgsql/bin/psql -Upostgres < pgstattuple--1.0.sql
ERROR: could not access file "MODULE_PATHNAME": No existe el archivo o
directorio
ERROR: could not access file "MODULE_PATHNAME": No existe el archivo o
directorio
ERROR: could not access file "MODULE_PATHNAME": No existe el archivo o
directorio
ERROR: could not access file "MODULE_PATHNAME": No existe el archivo o
directorio
##### ECHO .control
root@dell-desktop:/home/ecalvo-laptop/postgresql-9.1beta1/contrib/pgstattupl
e# cat pgstattuple.control
# pgstattuple extension
comment = 'show tuple-level statistics'
default_version = '1.0'
module_pathname = '$libdir/pgstattuple'
relocatable = true
##### PG_CONFIG LIBDIR location
root@dell-desktop:/home/ecalvo-laptop/postgresql-9.1beta1/contrib/pgstattupl
e# /usr/local/pgsql/bin/pg_config | grep -i libdir
LIBDIR = /usr/local/pgsql/lib
PKGLIBDIR = /usr/local/pgsql/lib
#### Content of sql:
root@dell-desktop:/home/ecalvo-laptop/postgresql-9.1beta1/contrib/pgstattupl
e# grep -i MODULE pgstattuple--1.0.sql
AS 'MODULE_PATHNAME', 'pgstattuple'
AS 'MODULE_PATHNAME', 'pgstattuplebyid'
AS 'MODULE_PATHNAME', 'pgstatindex'
AS 'MODULE_PATHNAME', 'pg_relpages'
Seems that it didn't replace the correct MODULE_PATHNAME with
$libdir/contrib...
On Sun, May 29, 2011 at 11:16:30AM +0000, Emanuel wrote:
make and make installs work well. To compile correctly I must hardcode the
libdir. I happens with several contribs.
did you actually do make and make install *in* contrib directory?
one shouldn't load sql files from the sources, and it looks like you're
trying to do it.
Best regards,
depesz
--
The best thing about modern society is how easy it is to avoid contact with it.
http://depesz.com/
2011/5/29 hubert depesz lubaczewski <depesz@depesz.com>:
On Sun, May 29, 2011 at 11:16:30AM +0000, Emanuel wrote:
make and make installs work well. To compile correctly I must hardcode the
libdir. I happens with several contribs.did you actually do make and make install *in* contrib directory?
No, I'm making the make inside the contrib/pgstattuple , not in contrib
directory (as always do in other versions).
one shouldn't load sql files from the sources, and it looks like you're
trying to do it.
I'm doing like other versions:
make; make install
and then:
psql < xxxx.sql
Does it change for 9.1?
--
--
Emanuel Calvo
Helpame.com
Emanuel Calvo <postgres.arg@gmail.com> writes:
2011/5/29 hubert depesz lubaczewski <depesz@depesz.com>:
did you actually do make and make install *in* contrib directory?
I'm doing like other versions:
make; make install
That's correct.
and then:
psql < xxxx.sql
That's not correct anymore. Use CREATE EXTENSION.
regards, tom lane