Re: BUG #2379: Duplicate pkeys in table

From: Philip Warner <pjw(at)rhyme(dot)com(dot)au>
To: pgsql-bugs(at)postgresql(dot)org
Subject: Re: BUG #2379: Duplicate pkeys in table
Date: 2006-04-06 14:40:02
Message-ID: 44352842.1050105@rhyme.com.au
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

Alvaro Herrera wrote:
> Do the triggers involved have EXCEPTION clauses? (I assume they are
> written in PL/pgSQL -- are there any in other languages?)
Triggers that update this table are in pl/pgsql, and can *raise*
exceptions (using RAISE) if that is what you mean. They do not handle
them -- is that even possible on pl/pgsql?

Other triggers (for slony) are written in plpgsql and C, and I know some
of the pl/pgsql triggers raise exceptions.

In response to

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2006-04-06 14:53:42 Re: BUG #2379: Duplicate pkeys in table
Previous Message Philip Warner 2006-04-06 14:39:08 Re: BUG #2379: Duplicate pkeys in table