Re: Rules and sequences

From: Tom Lane <tgl(at)sss(dot)pgh(dot)pa(dot)us>
To: Ben Morrow <ben(at)morrow(dot)me(dot)uk>
Cc: pgsql-sql(at)postgresql(dot)org
Subject: Re: Rules and sequences
Date: 2010-05-27 00:04:34
Message-ID: 4884.1274918674@sss.pgh.pa.us
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-sql

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.

regards, tom lane

In response to

Responses

Browse pgsql-sql by date

  From Date Subject
Next Message A. Kretschmer 2010-05-27 06:20:54 Re: Rules and sequences
Previous Message Gerardo Herzig 2010-05-26 22:02:20 cast record type to array?