On Wed, Nov 18, 2015 at 10:58 AM, Darren Duncan <darren at darrenduncan.net> wrote:
> On 2015-11-18 1:27 AM, Yuri wrote: > >> On 11/18/2015 01:17, Darren Duncan wrote: >>> >>> Deferred constraints are definitely a benefit. >>> >> I agree they can be beneficial, but not in all cases. Depends on what you >> do. It >> would have been great if it was an option, ex. "CONSTRAINT LEVEL >> [STATEMENT|TRANSACTION];". >> > > You can declare that behavior individually per foreign key constraint, and > you can also change it at runtime with > https://www.sqlite.org/pragma.html#pragma_defer_foreign_keys if that's > what you were looking for. -- Darren Duncan [DD] Oh, I didn't realize that pragma existed! Thanks for that. Didn't even realize SQLite supported deferred per FK, I thought it was always for all FKs in general. Given this pragma, then showing the FK name on immediate mode is possible, no? --DD
