finki-main
main
|
Last change
on this file since 06ebe74 was 62b2964, checked in by Klimentina Efremova <klimentina08642@…>, 2 weeks ago |
|
Project Handcraft Marketplace
|
-
Property mode
set to
100644
|
|
File size:
360 bytes
|
| Rev | Line | |
|---|
| [62b2964] | 1 | CREATE OR REPLACE FUNCTION delete_product_changes()
|
|---|
| 2 | RETURNS TRIGGER
|
|---|
| 3 | LANGUAGE plpgsql
|
|---|
| 4 | AS $$
|
|---|
| 5 | BEGIN
|
|---|
| 6 | -- Delete all changes associated with the product
|
|---|
| 7 | DELETE FROM change
|
|---|
| 8 | WHERE product_code = OLD.code;
|
|---|
| 9 |
|
|---|
| 10 | RETURN OLD;
|
|---|
| 11 | END;
|
|---|
| 12 | $$;
|
|---|
| 13 |
|
|---|
| 14 |
|
|---|
| 15 | CREATE TRIGGER trg_delete_product_changes
|
|---|
| 16 | BEFORE DELETE
|
|---|
| 17 | ON product
|
|---|
| 18 | FOR EACH ROW
|
|---|
| 19 | EXECUTE FUNCTION delete_product_changes();
|
|---|
Note:
See
TracBrowser
for help on using the repository browser.
