https://bugzilla.novell.com/show_bug.cgi?id=747440 https://bugzilla.novell.com/show_bug.cgi?id=747440#c0 Summary: no variable expansion while executing dblink (configuring postgresql) Classification: openSUSE Product: openSUSE 12.1 Version: Final Platform: x86-64 OS/Version: openSUSE 12.1 Status: NEW Severity: Critical Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: Robert.Jaeckel@unibw.de QAContact: qa@suse.de Found By: --- Blocker: --- User-Agent: Mozilla/5.0 (Windows NT 5.1; rv:10.0.1) Gecko/20100101 Firefox/10.0.1 I insalled 'PostgreSQL 9.1.1 on x86_64-suse-linux-gnu, compiled by gcc (SUSE Linux) 4.6.2, 64-bit'. I tried to add functions from /usr/share/postgresql/extension/dblink--1.0.sql while sourcing '/usr/share/postgresql/extension/dblink.control' before. I saw e.g. 'psql:-:166: FEHLER: konnte nicht auf Datei »MODULE_PATHNAME« zugreifen: Datei oder Verzeichnis nicht gefunden'. In dblink--1.0.sql I corrected MODULE_PATHNAME to $MODULE_PATHNAME with nearly the same result. After correcting it to '/usr/lib64/postgresql/dblink' the creation of the fuctions were successful. Why was there no expansion of the variables? Reproducible: Always Steps to Reproduce: 1. install postgres 2. source /usr/share/postgresql/extension/dblink.control 3. feed psql with /usr/share/postgresql/extension/dblink--1.0.sql Actual Results: error message: 'psql:-:166: FEHLER: konnte nicht auf Datei »MODULE_PATHNAME« zugreifen: Datei oder Verzeichnis nicht gefunden'. Expected Results: Functions had not been installed. Using our application 'Mittelbewirtschftungssystem' is a critical feature.. -- Configure bugmail: https://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.