Trigger aborted on error - Mailing list pgsql-hackers

From Andrij Korud
Subject Trigger aborted on error
Date
Msg-id Pine.BSF.3.96.991031213049.42375A-100000@NetSurfer.lp.lviv.ua
Whole thread Raw
Responses Re: [HACKERS] Trigger aborted on error  (wieck@debis.com (Jan Wieck))
List pgsql-hackers
Hi.
I've such problem :
I table with primary key and in trigger try to insert into this table data
wich violate constrain (not uniq). When ectually executing SPI_execp I got
a message "ERROR: cannot insert a duplicate key into a unique index" and
trigger executing is aborted. What should I do in order to get this error
as a result from SPI_execp and continue trigger execution?

Thanks in advance,
Andriy Korud, Lviv, Ukraine



pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Patch - Re: [HACKERS] view vs. inheritance hierarchy
Next
From: Lamar Owen
Date:
Subject: Re: [HACKERS] pgaccess 0.98