Skip site navigation (1) Skip section navigation (2)

Re: Triggers and Domains

From: ekekakos <ekekakos(at)hol(dot)gr>
To: pgsql-novice(at)postgresql(dot)org
Subject: Re: Triggers and Domains
Date: 2009-08-30 16:32:22
Message-ID: (view raw, whole thread or download thread mbox)
Lists: pgsql-novice
Thanks but how, in SQL server you put the function USER() (if I remember
well) and it works.
Here it does not work. I must put in all of my table the 2 fields
LASTUPDATEUSER and LASTUPDATEDATETIME and I am trying to find a quick way. I
thought the inheritance but I do not think that it will work.
I will be much appreciate if someone can help me on this.


Tom Lane-2 wrote:
> ekekakos <ekekakos(at)hol(dot)gr> writes:
>> I have a DOMAIN LastUpdateUser and I want to use it in all the tables of
>> the
>> database. I want also to create a trigger which will fulfill this domain
>> with the user name.
>> Is it possible to do it on Domain instead of the table?
> No.  But wouldn't a DEFAULT expression attached to the domain serve just
> as well?
> 			regards, tom lane
> -- 
> Sent via pgsql-novice mailing list (pgsql-novice(at)postgresql(dot)org)
> To make changes to your subscription:

View this message in context:
Sent from the PostgreSQL - novice mailing list archive at

In response to


pgsql-novice by date

Next:From: Tom LaneDate: 2009-08-30 17:01:37
Subject: Re: Triggers and Domains
Previous:From: Tom LaneDate: 2009-08-30 15:55:09
Subject: Re: Triggers and Domains

Privacy Policy | About PostgreSQL
Copyright © 1996-2017 The PostgreSQL Global Development Group