Jan Pazdziora <jpazdzi...@redhat.com> writes: > On Wed, Jun 29, 2011 at 08:32:29AM +0200, Jonathan Hoser wrote: >> By adding the basic two lines (from the Postgres manual) to my >> /etc/sysconfig/rhn/postgres/main.sql I actually got it working: >> >> CREATE FUNCTION plpgsql_call_handler() RETURNS language_handler AS >> '$libdir/plpgsql' LANGUAGE C; >> >> CREATE TRUSTED PROCEDURAL LANGUAGE plpgsql >> HANDLER plpgsql_call_handler;
> We list this on the > https://fedorahosted.org/spacewalk/wiki/PostgreSQLServerSetup > page. I assume you created the database and user in the cluster > manually but forgot about the language. BTW, not sure where you were looking in the PG manual, but it's been many years since that was the recommended way to create a procedural language. You're missing the validator function at least. I'd suggest either the createlang shell script (which is what's recommended on the above wiki page) or just "CREATE LANGUAGE plpgsql" (without any other parameters). regards, tom lane _______________________________________________ Spacewalk-devel mailing list Spacewalk-devel@redhat.com https://www.redhat.com/mailman/listinfo/spacewalk-devel
