Re: SERIAL and RULE of "ON INSERT" kind

From: Stephan Szabo <sszabo(at)megazone23(dot)bigpanda(dot)com>
To: Tomisaw Kityski <cromax(at)amiga(dot)pl>
Cc: <pgsql-general(at)postgresql(dot)org>
Subject: Re: SERIAL and RULE of "ON INSERT" kind
Date: 2002-06-25 00:46:32
Message-ID: 20020624174320.X61359-100000@megazone23.bigpanda.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

On Mon, 24 Jun 2002, Tomisaw Kityski wrote:

> Is this a bug? Is there a workaround for this (expect inserting
> data manually...)?

IIRC, rules are effectively rewrites and it's just adding extra
queries to the end before any of the queries are evaluated,
so I'd guess the default wasn't yet evaluated.
You might have better luck with a trigger instead.

In response to

Browse pgsql-general by date

  From Date Subject
Next Message Oskar Berggren 2002-06-25 00:49:48 Re: SQL server application porting headache
Previous Message Greg Sabino Mullane 2002-06-25 00:39:33 Re: Astonishing explain...!