opennms=# drop sequence opennmsNxtId; create sequence opennmsNxtId minvalue = 10000; NOTICE: default for table assets column id depends on sequence opennmsnxtid NOTICE: default for table ifservices column id depends on sequence opennmsnxtid NOTICE: default for table ipinterface column id depends on sequence opennmsnxtid NOTICE: default for table snmpinterface column id depends on sequence opennmsnxtid ERROR: cannot drop sequence opennmsnxtid because other objects depend on it HINT: Use DROP ... CASCADE to drop the dependent objects too. ERROR: syntax error at or near "=" at character 39 LINE 1: create sequence opennmsNxtId minvalue = 10000; ^ opennms=# alter SEQUENCE opennmsNxtId CACHE CYCLE INCREMENT MAXVALUE MINVALUE NO RESTART SET SCHEMA opennms=# alter SEQUENCE opennmsNxtId MINVALUE =10000; ERROR: syntax error at or near "=" at character 38 LINE 1: alter SEQUENCE opennmsNxtId MINVALUE =10000; ^ opennms=# alter SEQUENCE opennmsNxtId MINVALUE 10000; ERROR: START value (1) can't be less than MINVALUE (10000) opennms=# alter SEQUENCE opennmsNxtId increment 10000; ALTER SEQUENCE opennms=#