Postgres Pro
Downloads
Home   >   mailing lists

Thread: Recognize the creating of duplicate row from trigger

Recognize the creating of duplicate row from trigger

From
dipti shah
Date:
Hi,
 
I have created a trigger which updates the correspondign LogTable for PrimaryTable. If the insert to LogTable would create a duplicate row then the trigger should take no action and should return. Could you tell me how could I achieve this? I have all columns as a primary key in LogTable. It is intentional but I don't want my trigger to fail if tried to insert duplicate row and rollback the transaction. It should not take any action(should not insert duplication row) and returns when duplicate row is recognized.
 
Thanks,
Dipti