Hi All,
I am trying to build a function to insert or update data in one table from
date stored in another table. Eventually I hope to trigger this process based
on data being INSERTed into the original table. I have written the code below
based on the documentation and some help from this list. When I execute the
code I get this error.
ERROR: language "plpgsql" does not exist
What does this mean? How do I correct the error?
Kind Regards,
Keith
PS This is PostgreSQL v7.3.6 on Red Hat Enterprise Linux v3
CREATE FUNCTION xfer_gl_account_data() RETURNS INTEGER AS '
DECLARE
rcrd_gl_account RECORD;
BEGIN
FOR rcrd_gl_account IN SELECT
data_transfer.tbl_peachtree_gl_acount.account_id,
data_transfer.tbl_peachtree_gl_acount.description,
data_transfer.tbl_peachtree_gl_acount.account_type,
data_transfer.tbl_peachtree_gl_acount.inactive
FROM data_transfer.tbl_peachtree_gl_acount
ORDER BY gl_number
LOOP
SELECT peachtree.tbl_gl_account.account_id
FROM peachtree.tbl_gl_account
WHERE peachtree.tbl_gl_account.account_id = rcrd_gl_account.account_id;
IF NOT FOUND THEN
INSERT INTO peachtree.tbl_gl_account
( peachtree.tbl_gl_account.account_id,
peachtree.tbl_gl_account.description,
peachtree.tbl_gl_account.account_type,
peachtree.tbl_gl_account.inactive )
VALUES ( rcrd_gl_account.account_id,
rcrd_gl_account.description,
rcrd_gl_account.account_type,
rcrd_gl_account.inactive );
ELSE
UPDATE peachtree.tbl_gl_account
SET peachtree.tbl_gl_account.description =
rcrd_gl_account.description,
peachtree.tbl_gl_account.account_type =
rcrd_gl_account.account_type,
peachtree.tbl_gl_account.inactive = rcrd_gl_account.inactive
WHERE peachtree.tbl_gl_account.account_id =
rcrd_gl_account.account_id;
END IF;
END LOOP;
RETURN 1;
END;
' LANGUAGE 'plpgsql';
______________________________________________
99main Internet Services http://www.99main.com
