From: | Andrew Sullivan <andrew(at)libertyrms(dot)info> |
---|---|
To: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: Automatic insertion on insertion on another table |
Date: | 2002-10-29 13:32:34 |
Message-ID: | 20021029083234.B18292@mail.libertyrms.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | 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(at)libertyrms(dot)info> M2P 2A8
+1 416 646 3304 x110
From | Date | Subject | |
---|---|---|---|
Next Message | Andrew Sullivan | 2002-10-29 13:38:24 | Re: [pgsql-performance] Performance Problems |
Previous Message | Florian Litot | 2002-10-29 12:58:29 | error in insertion |