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 18:56:00
Message-ID: (view raw or whole thread)
Lists: pgsql-novice
So for every table I must create the 2 fields with the 2 triggers. Is there
any way to simplify this?
>From what you are saying I think no. Am I right?

Thanks again

Tom Lane-2 wrote:
> ekekakos <ekekakos(at)hol(dot)gr> writes:
>> And it does not work during the update.
> Oh, you mean you want the field to change during updates?  No, a
> DEFAULT won't do that for you.  You'll have to use a trigger.
> 			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: Ruzsinszky AttilaDate: 2009-08-31 09:18:24
Subject: Date interval and bitmask for days - Pl/Perl or SQL
Previous:From: Tom LaneDate: 2009-08-30 18:39:26
Subject: Re: Triggers and Domains

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