René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Переименовывание колонки","articleBody":"создаем таблицу\r\nCREATE TABLE unit_type (\r\n\tid_unit_type integer NOT NULL,\r\n\tcode character varying(3) NOT NULL,\r\n\t\"NAME\" character varying(50) NOT NULL,\r\n\tshort_name character varying(15) NOT NULL\r\n);\r\nпроливаем в БД\r\nпотом изменяем колонку \"NAME\" на name. компаратор видит, что это переименовывание..\r\n![default](https://user-images.githubusercontent.com/10084993/43325963-4a6e121c-91c0-11e8-86c7-237af4a5ab6d.png)\r\nоднако, генерит вот такой код:\r\n```\r\nSET search_path = sfact, pg_catalog;\r\n\r\nALTER TABLE unit_type\r\n  DROP COLUMN \"NAME\";\r\n\r\nSET search_path = sfact_bulk, pg_catalog;\r\n\r\nALTER TABLE unit_type\r\n  DROP COLUMN \"NAME\";\r\n\r\nSET search_path = sfact, pg_catalog;\r\n\r\nALTER TABLE unit_type\r\n  ADD COLUMN name character varying(50);\r\n\r\nALTER TABLE ONLY unit_type\r\n  ALTER COLUMN name SET NOT NULL;\r\n\r\nSET search_path = sfact_bulk, pg_catalog;\r\n\r\nALTER TABLE unit_type\r\n  ADD COLUMN name character varying(50);\r\n```","author":{"url":"https://github.com/sgrinko","@type":"Person","name":"sgrinko"},"datePublished":"2018-07-27T14:13:45.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":1},"url":"https://github.com/26/pgcodekeeper/issues/26"}