Postgres Pro
Downloads
Home   >   mailing lists

Re: Triggers and Domains - Mailing list pgsql-novice

From Tom Lane
Subject Re: Triggers and Domains
Date
Msg-id 13210.1251647709@sss.pgh.pa.us
Whole thread Raw
In response to Triggers and Domains  (ekekakos <ekekakos@hol.gr>)
Responses Re: Triggers and Domains  (ekekakos <ekekakos@hol.gr>)
List pgsql-novice
Tree view 
ekekakos <ekekakos@hol.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

pgsql-novice by date:

Previous
From: richard terry
Date:
Subject: Re: numbering rows in a view
Next
From: ekekakos
Date:
Subject: Re: Triggers and Domains