Jeff Frost wrote:
>> Another problem might well be with your plpgsql trigger function. If
>> you're dropping/re-creating credit_card_audit then that'll give you
>> the error you're seeing.
>
> The trigger shouldn't be firing at all in this scenario as it is on
> credit_card and not credit_card_audit. Are you saying that it could
> cause this sort of problem even though it doesn't fire?
My mistake - I'd misread the trigger definition and assumed it was
attached to the table you were dropping.
--
Richard Huxton
Archonet Ltd