Trigger

Поиск
Список
Период
Сортировка
От Adrian Klaver
Тема Trigger
Дата
Msg-id 200211281235.42714.aklaver@attbi.com
обсуждение исходный текст
Ответы Re: Trigger  (Tariq Muhammad <tmuhamma@libertyrms.com>)
Список pgsql-general
I have created the following function:

CREATE OR REPLACE FUNCTION validate_tag_number()
    RETURNS OPAQUE AS '
    BEGIN
    IF new.tag_number=old.tag_number THEN
    RAISE EXCEPTION " number is already present";
    END IF;
    RETURN NEW;
    END;
    'LANGUAGE 'plpgsql';

 I used it to create a trigger as follows;

    CREATE TRIGGER  validate_tag_number BEFORE UPDATE ON tag_vendor FOR EACH ROW
    EXECUTE PROCEDURE validate_tag_number();

If I do an update with a tag_number that does not exist everything is fine.
If  I do an update with a preexisting number I get the following messages-
NOTICE: plpgsql:ERROR during compile of validate_tag_number line 3
ERROR: unterminated " in name "
I was expecting to get the "number is already present" error messsage.
Where is my error?

    Thank you
    Adrian Klaver

В списке pgsql-general по дате отправления:

Предыдущее
От: Bruce Momjian
Дата:
Сообщение: Re: Incremental backup?
Следующее
От: Tariq Muhammad
Дата:
Сообщение: Re: Trigger