From: Michael Glaesemann <grzm@myrealbox.com>
To: Tom Lane <tgl@sss.pgh.pa.us>
Cc: postgresql sql list <pgsql-sql@postgresql.org>
Cc: Jeff Williams <jeffw@globaldial.com>
Subject: Re: Update timestamp on update
Date: Thu, 13 Oct 2005 12:07:47 +0900
Message-ID: <263BB61D-9C9A-40DD-A9CA-7FD6FE40AB75@myrealbox.com> (raw)
In-Reply-To: <16842.1129171924@sss.pgh.pa.us>
References: <434DB482.1000205@globaldial.com>
<16305.1129167889@sss.pgh.pa.us>
<434DC97E.7000603@globaldial.com>
<16842.1129171924@sss.pgh.pa.us>
On Oct 13, 2005, at 11:52 , Tom Lane wrote:
> Jeff Williams <jeffw@globaldial.com> writes:
>
>> Thanks. Triggers was my first thought, but chapter 35 on Triggers
>> didn't
>> really indicate a way I could do this easily and scared me with a
>> lot of
>> c code.
>>
>
> Yeah. This is a documentation issue that's bothered me for awhile.
> The problem is that we treat the PL languages as add-ons and therefore
> the documentation of the "core" system shouldn't rely on them ... but
> that leaves us presenting C-code triggers as the only examples in
> chapter 35. There is a paragraph in there suggesting you go look at
> the PL languages first, but obviously it's not getting the job done.
I think examples in PL/pgSQL would perhaps be most appropriate, as
it's a PostgreSQL-specific language, arguably easy to read, and a PL
that doesn't rely on any external dependencies, so it should be
relatively easy for people to install it if they want. (IIRC, there's
even been discussion in the past of whether or not PL/pgSQL should be
installed by default.)
Michael Glaesemann
grzm myrealbox com
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: grzm@myrealbox.com, tgl@sss.pgh.pa.us, jeffw@globaldial.com
Subject: Re: Update timestamp on update
In-Reply-To: <263BB61D-9C9A-40DD-A9CA-7FD6FE40AB75@myrealbox.com>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox