Home > mailing lists

committing a type to never change - Mailing list pgsql-novice

From	rob
Subject	committing a type to never change
Date	March 4, 2002 13:51:04
Msg-id	000c01c1c333$a20a0a80$0400000a@silence Whole thread Raw
List	pgsql-novice

How do I apply the following constraint/rule?

If I have the following relation R1(a1, a2) and I want to enforce a rule where when a tuple in R1 is created the

attribute a2 can not ever be updated (after it's been given it's initial value by the insert of the tuple).

So basically a2 is not changable after it's created.

How is this done in postgresql?

Thanks

Rob

From: "John J. Allison"
Date: 04 March 2002, 13:29:08
Subject: LIKE with no wildcards problem

From: Masse Jacques
Date: 04 March 2002, 14:03:38
Subject: Re: ERD or UML tool