top | item 36166916 (no title) meotimdihia | 2 years ago Is there a database that supported arrays of foreign keys? discuss order hn newest paulddraper|2 years ago Of the major databases, only Oracle and PostgreSQL have array extensions and neither support FKs as array elements.I'm curious how people think this feature should work? ON DELETE SET NULL, ON DELETE CASCADE, something else? evangow|2 years ago I would love it if the would remove the key from the array. lolive|2 years ago We use it in Palantir, that is a proprietary overlay on top of Spark. It supports this feature reasonably fine.
paulddraper|2 years ago Of the major databases, only Oracle and PostgreSQL have array extensions and neither support FKs as array elements.I'm curious how people think this feature should work? ON DELETE SET NULL, ON DELETE CASCADE, something else? evangow|2 years ago I would love it if the would remove the key from the array.
lolive|2 years ago We use it in Palantir, that is a proprietary overlay on top of Spark. It supports this feature reasonably fine.
paulddraper|2 years ago
I'm curious how people think this feature should work? ON DELETE SET NULL, ON DELETE CASCADE, something else?
evangow|2 years ago
lolive|2 years ago