Trigger - will not perform INSERT
| От | smiley2211 |
|---|---|
| Тема | Trigger - will not perform INSERT |
| Дата | |
| Msg-id | 14282848.post@talk.nabble.com обсуждение исходный текст |
| Ответы |
Re: Trigger - will not perform INSERT
Re: Trigger - will not perform INSERT Re: Trigger - will not perform INSERT |
| Список | pgsql-general |
ex:
CREATE TRIGGER mytrig AFTER INSERT OR UPDATE ON foo1 FOR EACH ROW EXECUTE
PROCEDURE updatefoo1('datarow');
The command itself is able to be executed without error. However, what then
happens, is that whenever the application attempts to insert a record into
foo1, it simply doesn't insert. Once I take the trigger off, it beings
inserting again.
I have checked permissions but INSERT only FAILS while trigger is enabled..
Thanks...Michelle
--
View this message in context: http://www.nabble.com/Trigger---will-not-perform-INSERT-tp14282848p14282848.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
В списке pgsql-general по дате отправления: