Re: Partition Creation Permissions

2021-02-04 Thread Samuel Nelson
mill On Thu, Feb 4, 2021 at 4:42 PM David G. Johnston wrote: > On Thu, Feb 4, 2021 at 3:39 PM Samuel Nelson > wrote: > >> I've been trying to restrict permissions of some users in our system and >> noticed that `create table foo partition of bar for values from (x) to

Partition Creation Permissions

2021-02-04 Thread Samuel Nelson
Hi list! I've been trying to restrict permissions of some users in our system and noticed that `create table foo partition of bar for values from (x) to (y)` complains that I must be the owner of the table. Is there another GRANT I can give to my user to allow creation and dropping of partitions

Re: CASCADE/fkey order

2020-07-22 Thread Samuel Nelson
e becoming an archbishop so you can meet girls." -- Matt Cartmill On Wed, Jul 22, 2020 at 10:31 AM David G. Johnston < david.g.johns...@gmail.com> wrote: > On Wed, Jul 22, 2020 at 8:24 AM Samuel Nelson > wrote: > >> Is there a way to force the delete to cascade to tabl

CASCADE/fkey order

2020-07-22 Thread Samuel Nelson
Hi all, We've got an interesting case where we want deletes to cascade if one table was hit directly, but not another. We can show that the delete _would_ cascade from one foreign key relationship, but the delete is actually blocked by the foreign key constraint from the other relationship. A so