Parameters from trigger to function.
| От | Vams |
|---|---|
| Тема | Parameters from trigger to function. |
| Дата | |
| Msg-id | 200406222346.39006.vmudrageda@charter.net обсуждение исходный текст |
| Ответы |
Re: Parameters from trigger to function.
|
| Список | pgsql-general |
Everyone, I need your help,
I am trying to pass a parameter to a function that is to be called by a
trigger. But, the correct function isn't being recognized and I am getting
an error stating that the function doesn't exist even though it does!
What I got going in psql...
CREATE TABLE testing (id SERIAL, data text); -- sequence = testing_id_seq
CREATE OR REPLACE FUNCTION id_protect(text) RETURNS TRIGGER AS '
DECLARE
sequence ALIAS FOR $1;
BEGIN
IF TG_OP = ''INSERT'' THEN
NEW.id := nextval(sequence);
RETURN NEW;
ELSIF TG_OP = ''UPDATE'' THEN
NEW.id := OLD.id;
RETURN NEW;
ELSE
RETURN NEW;
END IF;
END;
' LANGUAGE PLPGSQL;
\df id_protect
List of Functions
Result data type | Schema | Name | Argument data types
-------------------+----------+------------+------------------------
"trigger" | public | id_protect | text
CREATE TRIGGER protector BEFORE INSERT OR UPDATE ON testing FOR EACH ROW
EXECUTE PROCEDURE id_protect('testing_id_seq');
ERROR: function id_protect() does not exist
-----------------------------------------------------------------------------------------------------
Now, why am I getting that error?
Thx all,
Vams
В списке pgsql-general по дате отправления: