Have a simple BEFORE INSERT TRIGGER for PostalCodes.
I want prevent duplication.
Code: Select all
CREATE TRIGGER PUBLIC.POSTALCODE BEFORE INSERT ON PUBLIC."tPostalCode"
REFERENCING NEW ROW AS NEWROW FOR EACH ROW
BEGIN ATOMIC
IF EXISTS
(
SELECT
*
FROM
PUBLIC."tPostalCode"
WHERE
"tPostalCode"."PostalCode" = NEWROW."PostalCode"
)
THEN SIGNAL SQLSTATE'45000'SET MESSAGE_TEXT='This PostalCode already exists. Please verify the Existing entry!';
END IF;
END
This still leads to an increment of the PK: PostalCodeID.
No data is entered, so should the PK not increase?
Dream