This script is intended to automatically fix the sequence numbers for all tables in the current database.
This is accomplished through the use of the setval() command, which we provide with the next ID value we wish to make use of.
We use the setval(sequence, number, is_called) overload
and set is_called = false in conjunction with COALESCE(MAX + 1, 1) to ensure that, with an empty table, the next sequence
value is 1 as expected.
| [ | |
| // sublime keybindings | |
| { | |
| "key": "cmd+shift+[", | |
| "command": "workbench.action.previousEditor" | |
| }, | |
| { | |
| "key": "cmd+shift+]", | |
| "command": "workbench.action.nextEditor" | |
| }, |
| gzip on; | |
| gzip_disable "msie6"; | |
| gzip_vary on; | |
| gzip_proxied any; | |
| gzip_comp_level 6; | |
| gzip_buffers 16 8k; | |
| gzip_http_version 1.1; | |
| gzip_types text/plain text/xml text/css text/javascript text/x-js application/json application/javascript application/x-javascript application/xml application/xml+rss; |
| sudo dseditgroup -o edit -a username -t user _www |