Separate schema and table name Since a GeoServer data source is bound to a specific database schema, names have to be given without schema qualification. Since we cannot use regclass for names of SQL views, the name is now a varchar. This way it's more straightforward to store schema and name separately.

ALTER TABLE waterway.fairway_availability ALTER COLUMN date_info DROP DEFAULT;
DROP TRIGGER fairway_availability_date_info ON waterway.fairway_availability;