On Saturday, March 20, 2004, at 10:23 PM, V i s h a l Kashyap @ [Sai
Hertz And Control Systems] wrote:
> Dear Kevin ,
>>> Yes, you can set the default value for update of a record
>>> just with
>>> UPDATE email SET m_date = DEFAULT, m_by_user = DEFAULT WHERE id =
>> If I use this method, I will need to control the input from the
>> client side. I was hoping to have an easy way to update the record
>> with the last date modified and user who modified the record
>> regardless of where the modification came from. eg. Web or internal
>> client software.
> If the below query is issed by the web client then your job could be
> done by the said above query as well .
> To my limited knowledge no need to write a trigger.
> Just try using this
> CREATE FUNCTION email_mod_date() RETURNS TRIGGER AS
I'll give it a try.
>> acc=# UPDATE email SET email_address = 'mynewusername(at)mydomain(dot)com'
>> WHERE id = 14;
>> UPDATE 1
> I suppose this is update has been done without the trigger in place.
That's correct, when the function & trigger are in place psql just
hangs. It does not accept any input and the only way I know how to
terminate the process is to restart postmaster from another process.
> But kindly pass on the solution if you have found one.
As soon as I find one I will. I'm sure that I just have a simple syntax
error, but I'm too new to know what it is.
In response to
pgsql-novice by date
|Next:||From: V i s h a l Kashyap @ [Sai Hertz And Control Systems]||Date: 2004-03-21 05:23:31|
|Subject: Re: Creating Functions & Triggers|
|Previous:||From: Robert Morgan||Date: 2004-03-21 05:08:52|
|Subject: Re: connect from network PC |