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=#