我想更改我使用的序列的名称.我try 了这两种 Select ,但都失败了:
ALTER TABLE PLAYER RENAME id_seq_player TO player_id_seq;
和
ALTER SEQUENCE id_seq_player RENAME TO player_id_seq;
I looked at the official documentation 和 from there I created those two SQL, but none of them worked. The first solution resulted in a SQL error 和 the second had a time out.
下面是我得到的SQL错误:
ERROR: column "id_seq_player" does not exist
********** Error **********
* UPDATE *
Seems like the second SQL statement did the job. Since I have to forward the port, maybe it was an issue with the connection or OpenShift. But now I retried several times to verify 和 it works.
ALTER SEQUENCE id_seq_player RENAME TO player_id_seq; /* Works */