"Teemu Juntunen" <[EMAIL PROTECTED]> writes:
> -- Trigger at the child table
> CREATE TRIGGER "AFTER_DELETE_CHILD"
> AFTER DELETE
> ON child
> FOR EACH ROW
> EXECUTE PROCEDURE fn_checkmaster();
> -- This example leads to an exception
> INSERT INTO master (foo) VALUES (1);
> INSERT INTO chi
VALUES (1);
INSERT INTO child (foo,hoo) VALUES (1,1);
DELETE FROM master WHERE foo=1;
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Teemu Juntunen" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
Sent: Saturday, November 08, 2008 7:01 A
"Teemu Juntunen" <[EMAIL PROTECTED]> writes:
> Also according to the manual BEFORE DELETE trigger should launch before
> casading delete, so I changed the trigger
> CREATE TRIGGER "BTD_Y" BEFORE DELETE ON chlid FOR EACH ROW EXECUTE
> PROCEDURE fn_td_y();
> with no help.
In that case your prob
chlid FOR EACH ROW EXECUTE
PROCEDURE fn_td_y();
with no help. Any other ideas?
Regards,
Teemu Juntunen
- Original Message -
From: "Tom Lane" <[EMAIL PROTECTED]>
To: "Teemu Juntunen" <[EMAIL PROTECTED]>
Cc: "PostgreSQL"
Sent: Friday, Novembe
On Nov 7, 2008, at 11:24 AM, Erik Jones wrote:
On Nov 7, 2008, at 10:57 AM, Teemu Juntunen wrote:
Hello,
I have a child table with
CONSTRAINT fkey FOREIGN KEY (x) REFERENCES master (x) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE.
and
CREATE TRIGGER td_y AFTER DELETE ON chlid F
On Nov 7, 2008, at 10:57 AM, Teemu Juntunen wrote:
Hello,
I have a child table with
CONSTRAINT fkey FOREIGN KEY (x) REFERENCES master (x) MATCH SIMPLE
ON UPDATE CASCADE ON DELETE CASCADE.
and
CREATE TRIGGER td_y AFTER DELETE ON chlid FOR EACH ROW EXECUTE
PROCEDURE fn_td_y();
and th
"Teemu Juntunen" <[EMAIL PROTECTED]> writes:
> CREATE TRIGGER td_y AFTER DELETE ON chlid FOR EACH ROW EXECUTE PROCEDURE
> fn_td_y();
> It seems that SELECT results to null, so the master has already deleted the
> row. Is this intended and how can I solve this?
Your trigger is firing after the
Hello,
I have a child table with
CONSTRAINT fkey FOREIGN KEY (x) REFERENCES master (x) MATCH SIMPLE ON UPDATE
CASCADE ON DELETE CASCADE.
and
CREATE TRIGGER td_y AFTER DELETE ON chlid FOR EACH ROW EXECUTE PROCEDURE
fn_td_y();
and this trigger refers to the master table...
CREATE OR REPLAC
