Re: Insert zero to auto increment serial column - Mailing list pgsql-general

From Scott Marlowe
Subject Re: Insert zero to auto increment serial column
Date
Msg-id CAOR=d=1WaSovA1T3H-04vEiavtDqj=RTyddouWcYPc7WFSHd4w@mail.gmail.com
Whole thread Raw
In response to Re: Insert zero to auto increment serial column  (Jayadevan M <maymala.jayadevan@gmail.com>)
Responses Re: Insert zero to auto increment serial column  (Shaun Thomas <sthomas@optionshouse.com>)
List pgsql-general
On Wed, Apr 2, 2014 at 6:53 AM, Jayadevan M <maymala.jayadevan@gmail.com> wrote:
> Will a rule work?
> http://www.postgresql.org/docs/9.3/static/sql-createrule.html

There are a couple of issues you face if you use a rule, copy commands
ignore rules, and rules are slower.

Triggers are almost always better here and really aren't that hard to write.


pgsql-general by date:

Previous
From: Jayadevan M
Date:
Subject: Re: Insert zero to auto increment serial column
Next
From: Adrian Klaver
Date:
Subject: Re: Insert zero to auto increment serial column