2
--- test creation of SERIAL column
5
CREATE TABLE serialTest (f1 text, f2 serial);
6
NOTICE: CREATE TABLE will create implicit sequence "serialtest_f2_seq" for serial column "serialtest.f2"
8
INSERT INTO serialTest VALUES ('foo');
9
INSERT INTO serialTest VALUES ('bar');
10
INSERT INTO serialTest VALUES ('force', 100);
11
INSERT INTO serialTest VALUES ('wrong', NULL);
12
ERROR: null value in column "f2" violates not-null constraint
14
SELECT * FROM serialTest;
23
CREATE SEQUENCE sequence_test;
26
SELECT nextval('sequence_test');
32
DROP SEQUENCE sequence_test;
35
CREATE SEQUENCE foo_seq;
36
ALTER TABLE foo_seq RENAME TO foo_seq_new;
37
SELECT * FROM foo_seq_new;
38
sequence_name | last_value | increment_by | max_value | min_value | cache_value | log_cnt | is_cycled | is_called
39
---------------+------------+--------------+---------------------+-----------+-------------+---------+-----------+-----------
40
foo_seq | 1 | 1 | 9223372036854775807 | 1 | 1 | 1 | f | f
43
DROP SEQUENCE foo_seq_new;
47
CREATE SEQUENCE sequence_test2 START WITH 32;
48
SELECT nextval('sequence_test2');
54
ALTER SEQUENCE sequence_test2 RESTART WITH 16
55
INCREMENT BY 4 MAXVALUE 22 MINVALUE 5 CYCLE;
56
SELECT nextval('sequence_test2');
62
SELECT nextval('sequence_test2');
68
SELECT nextval('sequence_test2');
75
COMMENT ON SEQUENCE asdf IS 'won''t work';
76
ERROR: relation "asdf" does not exist
77
COMMENT ON SEQUENCE sequence_test2 IS 'will work';
78
COMMENT ON SEQUENCE sequence_test2 IS NULL;