Re: declare column update expression - Mailing list pgsql-general

From Artacus
Subject Re: declare column update expression
Date
Msg-id 48C9F9F1.2010104@comcast.net
Whole thread Raw
In response to Re: declare column update expression  ("Scott Marlowe" <scott.marlowe@gmail.com>)
List pgsql-general
 > That means I have to then go through all my code and make sure I set
 > the fields value. If I forget to modify one statement, things will
 > break.

Right, that's why the right answer for what you want to do is to have a
trigger. I was just giving you an alternative since you didn't like the
trigger answer.


> Do you have a superuser account?  Pretty sure you gotta have that to
> create lang.  OTOH, plpgsql is a "safe" language once installed, so
> you should be able to ask your hosting provider to install it.  Can't
> hurt to ask.

For plpgsql I don't believe it actually "installs" anything. The docs
make it sound more like it activates it. So as long as you own your
database you should be able to

createlang plpgsql


pgsql-general by date:

Previous
From: "Scott Marlowe"
Date:
Subject: Re: declare column update expression
Next
From: Artacus
Date:
Subject: Re: psql scripting tutorials