{"action":"created","issue":{"url":"https://api.github.com/repos/2ndQuadrant/audit-trigger/issues/9","labels_url":"https://api.github.com/repos/2ndQuadrant/audit-trigger/issues/9/labels{/name}","comments_url":"https://api.github.com/repos/2ndQuadrant/audit-trigger/issues/9/comments","events_url":"https://api.github.com/repos/2ndQuadrant/audit-trigger/issues/9/events","html_url":"https://github.com/2ndQuadrant/audit-trigger/issues/9","id":57948832,"number":9,"title":"Cannot Create Trigger For a Table with Name In Upper Case","user":{"login":"pete-experimenter","id":6091200,"avatar_url":"https://avatars.githubusercontent.com/u/6091200?v=3","gravatar_id":"","url":"https://api.github.com/users/pete-experimenter","html_url":"https://github.com/pete-experimenter","followers_url":"https://api.github.com/users/pete-experimenter/followers","following_url":"https://api.github.com/users/pete-experimenter/following{/other_user}","gists_url":"https://api.github.com/users/pete-experimenter/gists{/gist_id}","starred_url":"https://api.github.com/users/pete-experimenter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pete-experimenter/subscriptions","organizations_url":"https://api.github.com/users/pete-experimenter/orgs","repos_url":"https://api.github.com/users/pete-experimenter/repos","events_url":"https://api.github.com/users/pete-experimenter/events{/privacy}","received_events_url":"https://api.github.com/users/pete-experimenter/received_events","type":"User","site_admin":false},"labels":[],"state":"open","locked":false,"assignee":null,"milestone":null,"comments":4,"created_at":"2015-02-17T16:47:37Z","updated_at":"2015-02-17T17:36:31Z","closed_at":null,"body":"* Given I am using PostgreSQL 9.4\r\n* And I have a table in public schema\r\n```\r\nCREATE TABLE \"CHECK_ROW_LEVEL_LOCKS\"\r\n(\r\n  id serial NOT NULL,\r\n  msg text,\r\n  CONSTRAINT \"CHECK_ROW_LEVEL_LOCKS_pkey\" PRIMARY KEY (id)\r\n)\r\nWITH (\r\n  OIDS=FALSE\r\n);\r\nALTER TABLE \"CHECK_ROW_LEVEL_LOCKS\"\r\n  OWNER TO postgres;\r\n```\r\n* And when I try to add audit to it\r\n```\r\nSELECT audit.audit_table('CHECK_ROW_LEVEL_LOCKS');\r\n``` \r\n* Then I receive an error message\r\n```\r\nERROR: relationship \"check_row_level_locks\" does not exist\r\n```\r\n\r\nIf the table was created in lower case **check_row_level_locks**, then it would all be fine."},"comment":{"url":"https://api.github.com/repos/2ndQuadrant/audit-trigger/issues/comments/74712329","html_url":"https://github.com/2ndQuadrant/audit-trigger/issues/9#issuecomment-74712329","issue_url":"https://api.github.com/repos/2ndQuadrant/audit-trigger/issues/9","id":74712329,"user":{"login":"pete-experimenter","id":6091200,"avatar_url":"https://avatars.githubusercontent.com/u/6091200?v=3","gravatar_id":"","url":"https://api.github.com/users/pete-experimenter","html_url":"https://github.com/pete-experimenter","followers_url":"https://api.github.com/users/pete-experimenter/followers","following_url":"https://api.github.com/users/pete-experimenter/following{/other_user}","gists_url":"https://api.github.com/users/pete-experimenter/gists{/gist_id}","starred_url":"https://api.github.com/users/pete-experimenter/starred{/owner}{/repo}","subscriptions_url":"https://api.github.com/users/pete-experimenter/subscriptions","organizations_url":"https://api.github.com/users/pete-experimenter/orgs","repos_url":"https://api.github.com/users/pete-experimenter/repos","events_url":"https://api.github.com/users/pete-experimenter/events{/privacy}","received_events_url":"https://api.github.com/users/pete-experimenter/received_events","type":"User","site_admin":false},"created_at":"2015-02-17T17:36:31Z","updated_at":"2015-02-17T17:36:31Z","body":"Thanks for your comments and for the manual.\r\nA question on _quote_literal_ and checking the code: which code did you check? I had a look at https://github.com/2ndQuadrant/audit-trigger/blob/master/audit.sql and there are no references of _quote_literal_."}}