Changeset: c8ada1ed90a3 for MonetDB URL: https://dev.monetdb.org/hg/MonetDB?cmd=changeset;node=c8ada1ed90a3 Modified Files: sql/scripts/76_dump.sql Branch: monetdbe-proxy Log Message:
Remove the primary key constraint from dump_statements. diffs (12 lines): diff --git a/sql/scripts/76_dump.sql b/sql/scripts/76_dump.sql --- a/sql/scripts/76_dump.sql +++ b/sql/scripts/76_dump.sql @@ -159,7 +159,7 @@ END; --Because we need to explicitly overwrite the creation order column "o" in those cases. After inserting the dump statements for sys.functions and table-likes, --we can restart the auto-increment sequence with a sensible value for following dump statements. -CREATE TABLE sys.dump_statements(o INT, s STRING, PRIMARY KEY (o)); +CREATE TABLE sys.dump_statements(o INT, s STRING); CREATE FUNCTION sys.current_size_dump_statements() RETURNS INT BEGIN RETURN SELECT COUNT(*) FROM dump_statements; END; _______________________________________________ checkin-list mailing list checkin-list@monetdb.org https://www.monetdb.org/mailman/listinfo/checkin-list
