Re: Updating column on row update

Scott Marlowe <scott.marlowe@gmail.com>

From: Scott Marlowe <scott.marlowe@gmail.com>
To: Thom Brown <thombrown@gmail.com>
Cc: PGSQL Mailing List <pgsql-general@postgresql.org>
Date: 2009-11-22T20:50:58Z
Lists: pgsql-hackers, pgsql-general
On Sun, Nov 22, 2009 at 1:32 PM, Thom Brown <thombrown@gmail.com> wrote:
> Thanks Scott.  It's a shame a function has to be used because it then has
> the dependency of plpgsql being loaded.  I'm attempting to write a database
> schema to accompany a PostgreSQL driver for a popular CMS, but I guess I
> could get it to load plpgsql in as a language.

Nice thing about plpgsql is that as long as you own the database you
don't have to be a superuser to create language plgpsql.