Re: [GENERAL] Trigger - will not perform INSERT

2007-12-14 Thread smiley2211
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.

Re: [GENERAL] Trigger - will not perform INSERT

2007-12-12 Thread Alban Hertroys
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

Re: [GENERAL] Trigger - will not perform INSERT

2007-12-12 Thread smiley2211
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

[GENERAL] Trigger - will not perform INSERT

2007-12-11 Thread smiley2211
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.

Re: [GENERAL] Trigger - will not perform INSERT

2007-12-11 Thread Rodrigo De León
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?