You signed in with another tab or window. Reload to refresh your session.You signed out in another tab or window. Reload to refresh your session.You switched accounts on another tab or window. Reload to refresh your session.Dismiss alert
Doltgres supports adding constraints through ALTER TABLE, but the ON DELETE and ON UPDATE clauses don't support the SET DEFAULT option. Dolt supports parsing the ON DELETE/UPDATE SET DEFAULT syntax, but GMS does not implement the logic for it.
CREATETABLEpublic.hn_stories (
id integerNOT NULL,
title textNOT NULL,
datetimestamp with time zoneNOT NULL,
score numericNOT NULL,
hn_username text,
website_url text
);
CREATETABLEpublic.websites (
url textNOT NULL,
title text,
description text,
twitter_username text,
github_username text
);
ALTERTABLE ONLY public.hn_stories
ADD CONSTRAINT hn_stories_website_url_fkey FOREIGN KEY (website_url) REFERENCESpublic.websites(url) ONUPDATE CASCADE ON DELETESET DEFAULT;
Discovered while testing Hasura dump loading
The text was updated successfully, but these errors were encountered:
Doltgres supports adding constraints through
ALTER TABLE
, but theON DELETE
andON UPDATE
clauses don't support theSET DEFAULT
option. Dolt supports parsing theON DELETE/UPDATE SET DEFAULT
syntax, but GMS does not implement the logic for it.Discovered while testing Hasura dump loading
The text was updated successfully, but these errors were encountered: