github.com/cockroachdb/cockroach@v20.2.0-alpha.1+incompatible/pkg/sql/logictest/testdata/logic_test/rename_sequence (about)

     1  # see also file `sequences`
     2  
     3  statement ok
     4  CREATE SEQUENCE alter_test
     5  
     6  statement ok
     7  ALTER SEQUENCE alter_test RENAME TO renamed_alter_test
     8  
     9  # alter_test no longer there
    10  statement ok
    11  ALTER SEQUENCE IF EXISTS alter_test RENAME TO something
    12  
    13  statement ok
    14  ALTER SEQUENCE IF EXISTS renamed_alter_test RENAME TO renamed_again_alter_test
    15  
    16  statement ok
    17  DROP SEQUENCE renamed_again_alter_test
    18  
    19  # You can't rename a sequence with ALTER TABLE or ALTER VIEW.
    20  
    21  statement OK
    22  CREATE SEQUENCE foo
    23  
    24  statement error pgcode 42809 "foo" is not a table
    25  ALTER TABLE foo RENAME TO bar
    26  
    27  statement error pgcode 42809 "foo" is not a view
    28  ALTER VIEW foo RENAME TO bar