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: 25214530.post@talk.nabble.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
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
Elias

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:
> http://www.postgresql.org/mailpref/pgsql-novice
>
>

--
View this message in context: http://www.nabble.com/Triggers-and-Domains-tp25209238p25214530.html
Sent from the PostgreSQL - novice mailing list archive at Nabble.com.

In response to

Browse pgsql-novice by date

  From Date Subject
Next Message Ruzsinszky Attila 2009-08-31 09:18:24 Date interval and bitmask for days - Pl/Perl or SQL
Previous Message Tom Lane 2009-08-30 18:39:26 Re: Triggers and Domains