Re: Rules and sequences

From: Ben Morrow <ben(at)morrow(dot)me(dot)uk>
To: tgl(at)sss(dot)pgh(dot)pa(dot)us, pgsql-sql(at)postgresql(dot)org
Subject: Re: Rules and sequences
Date: 2010-05-27 16:28:33
Message-ID: 20100527162833.GA67751@osiris.mauzo.dyndns.org
Views: Whole Thread | Raw Message | Download mbox | Resend email
Thread:
Lists: pgsql-sql

Quoth tgl(at)sss(dot)pgh(dot)pa(dot)us (Tom Lane):
> Ben Morrow <ben(at)morrow(dot)me(dot)uk> writes:
> > I am trying to implement a fairly standard 'audit table' setup, but
> > using rules instead of triggers (since it should be more efficient).
>
> Rules are sufficiently tricky that I would never, ever rely on them for
> auditing. Use a simple AFTER trigger instead.

OK, thanks.

Ben

In response to

Browse pgsql-sql by date

  From Date Subject
Next Message Brent DeSpain 2010-05-27 19:33:07 Extending Regular Expression bounds limit of 255.
Previous Message A. Kretschmer 2010-05-27 14:09:23 Re: Question about slow queries...