Re: Rules and sequences - Mailing list pgsql-sql

From Tom Lane
Subject Re: Rules and sequences
Date
Msg-id 4884.1274918674@sss.pgh.pa.us
Whole thread Raw
In response to Rules and sequences  (Ben Morrow <ben@morrow.me.uk>)
Responses Re: Rules and sequences  ("A. Kretschmer" <andreas.kretschmer@schollglas.com>)
Re: Rules and sequences  (Ben Morrow <ben@morrow.me.uk>)
List pgsql-sql
Ben Morrow <ben@morrow.me.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


pgsql-sql by date:

Previous
From: Rolando Edwards
Date:
Subject: Re: inner join and limit
Next
From: Gerardo Herzig
Date:
Subject: cast record type to array?