{"action":"created","issue":{"url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/419","labels_url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/419/labels{/name}","comments_url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/419/comments","events_url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/419/events","html_url":"https://github.com/phalcon/phalcon-devtools/issues/419","id":83298923,"number":419,"title":"Phalcon migration Generate/Run error with Postgresql","user":{"login":"kimthangatm","id":7090588,"avatar_url":"https://avatars.githubusercontent.com/u/7090588?v=3","gravatar_id":"","url":"https://api.github.com/users/kimthangatm","html_url":"https://github.com/kimthangatm","followers_url":"https://api.github.com/users/kimthangatm/followers","following_url":"https://api.github.com/users/kimthangatm/following{/other_user}","gists_url":"https://api.github.com/users/kimthangatm/gists{/gist_id}","starred_url":"https://api.github.com/users/kimthangatm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kimthangatm/subscriptions","organizations_url":"https://api.github.com/users/kimthangatm/orgs","repos_url":"https://api.github.com/users/kimthangatm/repos","events_url":"https://api.github.com/users/kimthangatm/events{/privacy}","received_events_url":"https://api.github.com/users/kimthangatm/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":2,"created_at":"2015-06-01T03:59:41Z","updated_at":"2015-07-07T04:19:15Z","closed_at":null,"body":"Generate and run success with MySql but error on Postgres with SCHEMA.\r\n\r\nI think team add new video demo for Postgres sample as Mysql (Youtube: https://www.youtube.com/watch?v=Vx-9GiZt68I)"},"comment":{"url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/comments/119068743","html_url":"https://github.com/phalcon/phalcon-devtools/issues/419#issuecomment-119068743","issue_url":"https://api.github.com/repos/phalcon/phalcon-devtools/issues/419","id":119068743,"user":{"login":"kimthangatm","id":7090588,"avatar_url":"https://avatars.githubusercontent.com/u/7090588?v=3","gravatar_id":"","url":"https://api.github.com/users/kimthangatm","html_url":"https://github.com/kimthangatm","followers_url":"https://api.github.com/users/kimthangatm/followers","following_url":"https://api.github.com/users/kimthangatm/following{/other_user}","gists_url":"https://api.github.com/users/kimthangatm/gists{/gist_id}","starred_url":"https://api.github.com/users/kimthangatm/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/kimthangatm/subscriptions","organizations_url":"https://api.github.com/users/kimthangatm/orgs","repos_url":"https://api.github.com/users/kimthangatm/repos","events_url":"https://api.github.com/users/kimthangatm/events{/privacy}","received_events_url":"https://api.github.com/users/kimthangatm/received_events","type":"User","site_admin":false},"created_at":"2015-07-07T04:19:15Z","updated_at":"2015-07-07T04:19:15Z","body":"Command error\r\n```\r\nzaichi$ phalcon migration run\r\n\r\nPhalcon DevTools (2.0.3)\r\n\r\n1436242153.4626: SELECT CASE WHEN COUNT(*) > 0 THEN 1 ELSE 0 END FROM information_schema.tables WHERE table_schema = 'cms_old' AND table_name='bug_tracking'  => 1436242153.473 (0.010378122329712)\r\n1436242153.4736: SELECT DISTINCT c.column_name AS Field, c.data_type AS Type, c.character_maximum_length AS Size, c.numeric_precision AS NumericSize, c.numeric_scale AS NumericScale, c.is_nullable AS Null, CASE WHEN pkc.column_name NOTNULL THEN 'PRI' ELSE '' END AS Key, CASE WHEN c.data_type LIKE '%int%' AND c.column_default LIKE '%nextval%' THEN 'auto_increment' ELSE '' END AS Extra, c.ordinal_position AS Position, c.column_default FROM information_schema.columns c LEFT JOIN ( SELECT kcu.column_name, kcu.table_name, kcu.table_schema FROM information_schema.table_constraints tc INNER JOIN information_schema.key_column_usage kcu on (kcu.constraint_name = tc.constraint_name and kcu.table_name=tc.table_name and kcu.table_schema=tc.table_schema) WHERE tc.constraint_type='PRIMARY KEY') pkc ON (c.column_name=pkc.column_name AND c.table_schema = pkc.table_schema AND c.table_name=pkc.table_name) WHERE c.table_schema='cms_old' AND c.table_name='bug_tracking' ORDER BY c.ordinal_position  => 1436242153.5224 (0.048776149749756)\r\n                                                        \r\nError: Trying to call method getname on a non-object\r\n```"}}