http://bugzilla.novell.com/show_bug.cgi?id=534050 Summary: PostgreSQL file uuid-ossp missing - function uuid_generate_v4() fails Classification: openSUSE Product: openSUSE 11.1 Version: Final Platform: x86 OS/Version: openSUSE 11.1 Status: NEW Severity: Normal Priority: P5 - None Component: Other AssignedTo: bnc-team-screening@forge.provo.novell.com ReportedBy: Harald.Oehlmann@gmx.de QAContact: qa@suse.de Found By: --- User-Agent: Mozilla/5.0 (Windows; U; Windows NT 6.0; de; rv:1.9.1.2) Gecko/20090729 Firefox/3.5.2 (.NET CLR 3.5.30729) When installing OpenBravo ERP, the following function is executed: CREATE OR REPLACE FUNCTION uuid_generate_v4() RETURNS uuid AS '$libdir/uuid-ossp', 'uuid_generate_v4' VOLATILE STRICT LANGUAGE C; This fails with "file $libdir/uuid-ossp" not found. There are many threads complaining about this missing file in the package: http://www.nabble.com/problem-running-uui.sql-script-OSSP-UUID-package-td199... so I decided to finally file a bug report Reproducible: Always Steps to Reproduce: Execute the command listed in the details in psql Actual Results: Fails with "file $libdir/uuid-ossp" not found. Expected Results: Defines function uuid_generate_v4() This issue is also present in the current factory version of postgresql 8.4.0 Regards to Reinhard, Harald -- Configure bugmail: http://bugzilla.novell.com/userprefs.cgi?tab=email ------- You are receiving this mail because: ------- You are on the CC list for the bug.