{"action":"created","issue":{"url":"https://api.github.com/repos/lmsgit/lms/issues/865","repository_url":"https://api.github.com/repos/lmsgit/lms","labels_url":"https://api.github.com/repos/lmsgit/lms/issues/865/labels{/name}","comments_url":"https://api.github.com/repos/lmsgit/lms/issues/865/comments","events_url":"https://api.github.com/repos/lmsgit/lms/issues/865/events","html_url":"https://github.com/lmsgit/lms/issues/865","id":173818772,"number":865,"title":"Czysta instalacja GIT, branch:master, import pliku schematu Postgres","user":{"login":"interduo","id":17087236,"avatar_url":"https://avatars.githubusercontent.com/u/17087236?v=3","gravatar_id":"","url":"https://api.github.com/users/interduo","html_url":"https://github.com/interduo","followers_url":"https://api.github.com/users/interduo/followers","following_url":"https://api.github.com/users/interduo/following{/other_user}","gists_url":"https://api.github.com/users/interduo/gists{/gist_id}","starred_url":"https://api.github.com/users/interduo/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/interduo/subscriptions","organizations_url":"https://api.github.com/users/interduo/orgs","repos_url":"https://api.github.com/users/interduo/repos","events_url":"https://api.github.com/users/interduo/events{/privacy}","received_events_url":"https://api.github.com/users/interduo/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"assignees":[],"milestone":null,"comments":2,"created_at":"2016-08-29T16:48:24Z","updated_at":"2016-08-29T20:14:10Z","closed_at":null,"body":"To tak:\r\n$ psql\r\nCREATE DATABASE lms ENCODING='UTF8';\r\n\\c lms\r\n\\i ./lms.pgsql\r\n\r\n2016-08-29 18:41:31 CEST [3459-1] lms@lms BŁĄD:  relacja \"tariffs\" nie istnieje\r\n2016-08-29 18:41:31 CEST [3459-2] lms@lms WYRAŻENIE:  CREATE TABLE voip_tariff_rules (\r\n                id integer DEFAULT nextval('voip_tariff_rules_id_seq'::text) NOT NULL,\r\n                tarifid integer NOT NULL\r\n                        REFERENCES tariffs (id) ON DELETE CASCADE ON UPDATE CASCADE,\r\n                ruleid integer NULL\r\n                        REFERENCES voip_rules (id) ON DELETE CASCADE ON UPDATE CASCADE,\r\n                PRIMARY KEY (id)\r\n        );\r\n\r\nReszta dalej zostaje olana i przy każdym querry:\r\nBŁĄD:  bieżąca transakcja została przerwana, polecenia ignorowane do końca bloku transakcji"},"comment":{"url":"https://api.github.com/repos/lmsgit/lms/issues/comments/243241397","html_url":"https://github.com/lmsgit/lms/issues/865#issuecomment-243241397","issue_url":"https://api.github.com/repos/lmsgit/lms/issues/865","id":243241397,"user":{"login":"chilek","id":1457437,"avatar_url":"https://avatars.githubusercontent.com/u/1457437?v=3","gravatar_id":"","url":"https://api.github.com/users/chilek","html_url":"https://github.com/chilek","followers_url":"https://api.github.com/users/chilek/followers","following_url":"https://api.github.com/users/chilek/following{/other_user}","gists_url":"https://api.github.com/users/chilek/gists{/gist_id}","starred_url":"https://api.github.com/users/chilek/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/chilek/subscriptions","organizations_url":"https://api.github.com/users/chilek/orgs","repos_url":"https://api.github.com/users/chilek/repos","events_url":"https://api.github.com/users/chilek/events{/privacy}","received_events_url":"https://api.github.com/users/chilek/received_events","type":"User","site_admin":false},"created_at":"2016-08-29T20:14:10Z","updated_at":"2016-08-29T20:14:10Z","body":"W wierszu:\r\nhttps://github.com/lmsgit/lms/blob/master/doc/lms.pgsql#L757\r\njest odwołanie do tablicy **tariffs**, a jej definicja występuje dopiero dalej:\r\nhttps://github.com/lmsgit/lms/blob/master/doc/lms.pgsql#L834\r\n!"}}
{"actor":{"display_login":"chilek"}}