#334 Export TRIGGERs

[Anonymous]

Originally created by: ansgar.b...@wolterskluwer.de
Originally owned by: a...@anse.de

Reported as bug #1951460 by ultimateb@sf on 2008-04-25 02:21

When i try to export a database to another database triggers aren't
exported. This can be a pain on trigger heavy databases.

Example trigger to make life easier:

Table:

markers

id int pk
geo geometry
locatie varchar(255) default 'POINT(0 0)'

create trigger:
CREATE TRIGGER t_gebieden_geo_insert
                            BEFORE INSERT ON gebieden
                            FOR EACH ROW
                            SET NEW.geo = GeometryFromText(NEW.locatie)

Trigger it:
INSERT INTO markers ( locatie ) values ( "POINT(52 4)" );

[Anonymous]

Originally posted by: rosenfie...@gmail.com

(No comment was entered for this change.)

Labels: -priority-medium Severity-Broken

[Anonymous]

Originally posted by: a...@anse.de

(No comment was entered for this change.)

Labels: -migrated

[Anonymous]

Originally posted by: rosenfie...@gmail.com

(No comment was entered for this change.)

Labels: -Type-Defect -Severity-Broken Type-Enhancement Severity-Default

[Anonymous]

Originally posted by: rosenfie...@gmail.com

(No comment was entered for this change.)

Summary: Export TRIGGERs

[Anonymous]

Originally posted by: a...@anse.de

Issue #806 : General displaying triggers should be implemented at first.

[Anonymous]

Originally posted by: a...@anse.de

This issue was closed by revision [r2929].

Mergedinto: -
Status: Fixed