Re: Automatic insertion on insertion on another table - Mailing list pgsql-general

From Andrew Sullivan
Subject Re: Automatic insertion on insertion on another table
Date
Msg-id 20021029083234.B18292@mail.libertyrms.com
Whole thread Raw
In response to Automatic insertion on insertion on another table  ("Owen Jacobson" <ojacobson@sympatico.ca>)
List pgsql-general
On Thu, Oct 24, 2002 at 05:36:52PM -0400, Owen Jacobson wrote:

> I assume the correct way to do this is through a trigger on the user table
> (AFTER INSERT) but have no experience whatsoever writing triggers.  I'm not
> necessarily asking for someone to write it for me, although that would be
> most kind, but some resources on how to write it myself would be just as
> good.

That's probably what you want (a rule might also work in this case).
The place to start is

<http://www.ca.postgresql.org/users-lounge/docs/7.2/postgres/triggers.html>

A

--
----
Andrew Sullivan                         204-4141 Yonge Street
Liberty RMS                           Toronto, Ontario Canada
<andrew@libertyrms.info>                              M2P 2A8
                                         +1 416 646 3304 x110


pgsql-general by date:

Previous
From: Savita
Date:
Subject: ONE MORE PERFORMANCE ISSUE WITH POSTGRES
Next
From: Florian Litot
Date:
Subject: error in insertion