Thanks all...ended up being a missing field in my table definition...sorry to
bother you all ...
:wistle:
--
View this message in context:
http://www.nabble.com/Trigger---will-not-perform-INSERT-tp14282848p14297220.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
On Dec 11, 2007, at 21:35, smiley2211 wrote:
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
Ok, thanks...I will do some more testing and see what I get...
--
View this message in context:
http://www.nabble.com/Trigger---will-not-perform-INSERT-tp14282848p14296002.html
Sent from the PostgreSQL - general mailing list archive at Nabble.com.
---(end of
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.
On Dec 11, 2007 3:35 PM, smiley2211 [EMAIL PROTECTED] wrote:
Thanks...Michelle
Please post DDL plus sample code/data to increase the odds of having
someone help you.
---(end of broadcast)---
TIP 4: Have you searched our list archives?