Re: [PROPOSAL] ON DELETE SET NULL () for Foreign Key Constraints

On Sat, Jan 19, 2019 at 5:12 PM Tom Lane wrote: > > Paul Martinez writes: > > I have a proposal for a feature to add to Postgres. I believe it is a > > natural > > extension to the current standard SQL ON DELETE SET NULL behavior when using > > composite foreign keys. The basic idea is that you

Re: [PROPOSAL] ON DELETE SET NULL () for Foreign Key Constraints

Paul Martinez writes: > I have a proposal for a feature to add to Postgres. I believe it is a natural > extension to the current standard SQL ON DELETE SET NULL behavior when using > composite foreign keys. The basic idea is that you can specify which columns > to > set to NULL in the DELETE

[PROPOSAL] ON DELETE SET NULL () for Foreign Key Constraints

Hello! I have a proposal for a feature to add to Postgres. I believe it is a natural extension to the current standard SQL ON DELETE SET NULL behavior when using composite foreign keys. The basic idea is that you can specify which columns to set to NULL in the DELETE trigger created by a foreign