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
reacted with thumbs up emoji reacted with thumbs down emoji reacted with laugh emoji reacted with hooray emoji reacted with confused emoji reacted with heart emoji reacted with rocket emoji reacted with eyes emoji
Uh oh!
There was an error while loading. Please reload this page.
-
Using 2.2.0 non-native enum types for Postgres e.g. foreign-key reference. This works seeing the enums from the console within the public schema:
drop table if exists du_spike cascade; create table du_spike ( default_display_units text DEFAULT 'us' NOT NULL ); ALTER TABLE du_spike ADD CONSTRAINT du_spike_default_display_units_fkey FOREIGN KEY (default_display_units) REFERENCES public.display_units(value);
But drop it into another schema named spike and it fails:
drop table if exists spike.du_spike cascade; create table spike.du_spike ( default_display_units text DEFAULT 'us' NOT NULL ); ALTER TABLE spike.du_spike ADD CONSTRAINT du_spike_default_display_units_fkey FOREIGN KEY (default_display_units) REFERENCES public.display_units(value);
Beta Was this translation helpful? Give feedback.
All reactions