Function problem.
| От | Geoff Ellis |
|---|---|
| Тема | Function problem. |
| Дата | |
| Msg-id | FDCF842C8B1DD311833C0090277C04B518C359@augusta.planmatics.co.uk обсуждение исходный текст |
| Ответы |
Re: Function problem.
|
| Список | pgsql-admin |
I've got a tiny problem with how I want this function to work.
On and insert/delete from a table, I want to check to see if a field
contains a certain valule. If it does, not to insert or delete the record.
If it doesn't I want to go ahead and insert/delete the record.
Here's my function.
-- Function: users_upd_del()
CREATE FUNCTION users_upd_del() RETURNS int2 AS 'BEGIN
IF ( NEW.username = ''emsroot'' ) THEN
RAISE NOTICE ''Cannot REMOVE user [ (%) ]'', NEW.username;
RETURN NULL;
END IF;
RETURN 1;
END' LANGUAGE 'plpgsql';
However, when this run I get the error
=== ERROR: fmgr_info: function 696542: cache lookup failed =====
I've tried to change the return type to opaque and remove the RETURN 1; But
if the condition isn't true then I don't have a return.
Can someone help me here, I've looked through the 7.3rc1 Docs shipped with
pgadmin and can't quite see what I'm after...
thanks
Geoff
В списке pgsql-admin по дате отправления: