{"action":"closed","issue":{"url":"https://api.github.com/repos/tgriesser/knex/issues/1403","repository_url":"https://api.github.com/repos/tgriesser/knex","labels_url":"https://api.github.com/repos/tgriesser/knex/issues/1403/labels{/name}","comments_url":"https://api.github.com/repos/tgriesser/knex/issues/1403/comments","events_url":"https://api.github.com/repos/tgriesser/knex/issues/1403/events","html_url":"https://github.com/tgriesser/knex/issues/1403","id":154551809,"number":1403,"title":"Not able to rename a table","user":{"login":"rvarbanov","id":2780282,"avatar_url":"https://avatars.githubusercontent.com/u/2780282?v=3","gravatar_id":"","url":"https://api.github.com/users/rvarbanov","html_url":"https://github.com/rvarbanov","followers_url":"https://api.github.com/users/rvarbanov/followers","following_url":"https://api.github.com/users/rvarbanov/following{/other_user}","gists_url":"https://api.github.com/users/rvarbanov/gists{/gist_id}","starred_url":"https://api.github.com/users/rvarbanov/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/rvarbanov/subscriptions","organizations_url":"https://api.github.com/users/rvarbanov/orgs","repos_url":"https://api.github.com/users/rvarbanov/repos","events_url":"https://api.github.com/users/rvarbanov/events{/privacy}","received_events_url":"https://api.github.com/users/rvarbanov/received_events","type":"User","site_admin":false},"labels":[{"url":"https://api.github.com/repos/tgriesser/knex/labels/bug","name":"bug","color":"fc2929"},{"url":"https://api.github.com/repos/tgriesser/knex/labels/PostgreSQL","name":"PostgreSQL","color":"207de5"},{"url":"https://api.github.com/repos/tgriesser/knex/labels/PR%20please","name":"PR please","color":"bfe5bf"}],"state":"closed","locked":false,"assignee":null,"milestone":null,"comments":1,"created_at":"2016-05-12T18:36:47Z","updated_at":"2016-05-14T20:57:48Z","closed_at":"2016-05-14T20:57:48Z","body":"My migration scripts are breaking when trying to rename a table\r\n\r\n```js\r\n'use strict';\r\n\r\nexports.up = (knex, Promise) => {\r\n\treturn knex.schema.withSchema('core').renameTable('organization_id_type', 'organization_code_type');\r\n};\r\n\r\nexports.down = (knex, Promise) => {\r\n\treturn knex.schema.withSchema('core').renameTable('organization_code_type', 'organization_id_type');\r\n};\r\n```\r\n\r\nand here is the warning that I get\r\n\r\n```bash\r\nKnex:warning - migrations failed with error: alter table \"core\".\"organization_id_type\" rename to \"core\".\"organization_code_type\" - syntax error at or near \".\"\r\nUnhandled rejection error: alter table \"core\".\"organization_id_type\" rename to \"core\".\"organization_code_type\" - syntax error at or near \".\"\r\n    at Connection.parseE (/opt/app/node_modules/pg/lib/connection.js:539:11)\r\n    at Connection.parseMessage (/opt/app/node_modules/pg/lib/connection.js:366:17)\r\n    at Socket.<anonymous> (/opt/app/node_modules/pg/lib/connection.js:105:22)\r\n    at emitOne (events.js:96:13)\r\n    at Socket.emit (events.js:188:7)\r\n    at readableAddChunk (_stream_readable.js:172:18)\r\n    at Socket.Readable.push (_stream_readable.js:130:10)\r\n    at TCP.onread (net.js:542:20)\r\n```"}}