Re: Remove mention in docs that foreign keys on partitioned tables arenot supported - Mailing list pgsql-hackers

From Rui DeSousa
Subject Re: Remove mention in docs that foreign keys on partitioned tables arenot supported
Date
Msg-id 3938060C-D804-4160-8113-1FDF2EA959AD@icloud.com
Whole thread Raw
In response to Re: Remove mention in docs that foreign keys on partitioned tablesare not supported  (Robert Haas <robertmhaas@gmail.com>)
List pgsql-hackers


On Jun 14, 2018, at 9:19 AM, Robert Haas <robertmhaas@gmail.com> wrote:

 anyone who wants a BEFORE trigger has a good reason
for wanting it.

I have used before triggers to enforce the immutability of a column.

i.e. 

  if (new.member_key != old.member_key) then
    raise exception 'Unable to change member_key, column is immutable';
  end if
  ; 

pgsql-hackers by date:

Previous
From: Peter Geoghegan
Date:
Subject: Re: Locking B-tree leafs immediately in exclusive mode
Next
From: Alexander Korotkov
Date:
Subject: Re: Locking B-tree leafs immediately in exclusive mode