As an absolute beginner I want to install the Hungarian fork of SQL-Ledger on MacOS 10.5.3.
The instalation of PostgreSQL for mac worked fine.
I installed DBD-Pg and DBI with macports, but it installed perl and Postgres as well into opt/local.
Now I wanted to use the createlang command, but the PostgreSQL8 dir does not exist in Library in the Terminal, while the folder is there in the finder and the db nicely works putting out error messages like:
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: Use CREATE LANGUAGE to load the language into the database.
I'll be grateful for any kind of help
If you would like to refer to this comment somewhere else in this project, copy and paste the following link:
As an absolute beginner I want to install the Hungarian fork of SQL-Ledger on MacOS 10.5.3.
The instalation of PostgreSQL for mac worked fine.
I installed DBD-Pg and DBI with macports, but it installed perl and Postgres as well into opt/local.
Now I wanted to use the createlang command, but the PostgreSQL8 dir does not exist in Library in the Terminal, while the folder is there in the finder and the db nicely works putting out error messages like:
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: Use CREATE LANGUAGE to load the language into the database.
I'll be grateful for any kind of help