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: | 25213142.post@talk.nabble.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
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.
Thanks
Elias
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:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>
--
View this message in context: http://www.nabble.com/Triggers-and-Domains-tp25209238p25213142.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2009-08-30 17:01:37 | Re: Triggers and Domains |
Previous Message | Tom Lane | 2009-08-30 15:55:09 | Re: Triggers and Domains |