Postgres Pro
Downloads
Home   >   mailing lists

Re: SERIAL type's sequence is double-called or ? - Mailing list pgsql-sql

From Richard Huxton
Subject Re: SERIAL type's sequence is double-called or ?
Date
Msg-id 46E1625F.4070701@archonet.com
Whole thread Raw
In response to SERIAL type's sequence is double-called or ?  (Aleksandr Vinokurov <aleksandr.vin@gmail.com>)
List pgsql-sql
Tree view 
Aleksandr Vinokurov wrote:
> 
> Logging will be done with this rule:
> 
> create or replace rule chuwee_rule as on insert to chuwee
> do insert into chuwee_log (num, mesg)
>    values (new.num, new.mesg);

Don't do logging with rules, do logging with triggers.

See mailing-list archives for details.

--   Richard Huxton  Archonet Ltd

pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: to_date function
Next
From: "A. Kretschmer"
Date:
Subject: Re: to_date function