2 Oct 2006 05:33
[mb-commits] r8508 - mb_server/trunk/admin/sql/contrib/musicip/track_frd
<root <at> musicbrainz.org>
2006-10-02 03:33:09 GMT
2006-10-02 03:33:09 GMT
Author: robert
Date: 2006-10-02 03:33:08 +0000 (Mon, 02 Oct 2006)
New Revision: 8508
Modified:
mb_server/trunk/admin/sql/contrib/musicip/track_frd/CreateTrackDateFunctions.sql
mb_server/trunk/admin/sql/contrib/musicip/track_frd/CreateTrackDateTriggers.sql
mb_server/trunk/admin/sql/contrib/musicip/track_frd/DropTrackDateTriggers.sql
Log:
Change the track delete trigger to fire BEFORE the delete
Modified: mb_server/trunk/admin/sql/contrib/musicip/track_frd/CreateTrackDateFunctions.sql
===================================================================
---
mb_server/trunk/admin/sql/contrib/musicip/track_frd/CreateTrackDateFunctions.sql 2006-09-30
19:04:27 UTC (rev 8507)
+++
mb_server/trunk/admin/sql/contrib/musicip/track_frd/CreateTrackDateFunctions.sql 2006-10-02
03:33:08 UTC (rev 8508)
<at> <at> -134,7 +134,7 <at> <at>
END;
' LANGUAGE 'plpgsql';
-CREATE OR REPLACE FUNCTION a_del_track_frd () RETURNS TRIGGER AS '
+CREATE OR REPLACE FUNCTION b_del_track_frd () RETURNS TRIGGER AS '
BEGIN
DELETE FROM track_firstreleasedate where id = OLD.id;
RETURN NEW;
Modified: mb_server/trunk/admin/sql/contrib/musicip/track_frd/CreateTrackDateTriggers.sql
(Continue reading)
RSS Feed