sql-ledger-users

[SL] Dataset creation issue

[John W. F. <joh...@ve...>]

Can someone tell me what to do about this error. Docs are not real clear on 
what is going on. This is an error generated when I try to set up any new 
dataset. This same thing happened when I tried to use the Debian packages. 
This error is from the tarball installation using setup.perl and installing 
from the internet.



Error!


CREATE FUNCTION del_yearend() RETURNS OPAQUE AS '
begin
 delete from yearend where trans_id = old.id;
 return NULL;
end;
' language 'plpgsql';

ERROR: language "plpgsql" does not exist
HINT: You need to use "createlang" to load the language into the database.

-- 
John W. Foster

Re: [SL] Dataset creation issue

[Seneca C. <te...@gm...>]

On Mon, Nov 06, 2006 at 01:00:31AM -0600, John W. Foster wrote:
> Can someone tell me what to do about this error. Docs are not real clear on 
> what is going on. This is an error generated when I try to set up any new 
> dataset. This same thing happened when I tried to use the Debian packages. 
> This error is from the tarball installation using setup.perl and installing 
> from the internet.
[...]
> ERROR: language "plpgsql" does not exist
> HINT: You need to use "createlang" to load the language into the database.

You need to run 'createlang plpgsql template1' at the command line as
the database user before creating a dataset.  If the database is already
created, run "createlang plpgsql $DBNAME" instead.

-- 
Seneca
te...@gm...