{"id":6496,"date":"2018-04-07T10:47:13","date_gmt":"2018-04-07T15:47:13","guid":{"rendered":"http:\/\/www.carnaghan.com\/?post_type=epkb_post_type_1&p=6496"},"modified":"2018-04-07T10:47:13","modified_gmt":"2018-04-07T15:47:13","slug":"error-permission-denied-for-sequence","status":"publish","type":"epkb_post_type_1","link":"https:\/\/www.carnaghan.com\/knowledge-base\/error-permission-denied-for-sequence\/","title":{"rendered":"ERROR: permission denied for sequence"},"content":{"rendered":"
Problem<\/strong>:\u00a0PHP Warning:\u00a0 pg_query(): Query failed: ERROR:\u00a0 permission denied for sequencename\u00a0<\/em>in\u00a0<\/em>PostgreSql<\/p>\n Solution<\/strong>:<\/p>\n To fix this problem, change the owner to the role that needs to access this sequence<\/p>\n Change\u00a0sequencename<\/strong>\u00a0to your sequence name and\u00a0rolename<\/strong>\u00a0to the owner<\/p>\n","protected":false},"excerpt":{"rendered":" Problem:\u00a0PHP Warning:\u00a0 pg_query(): Query failed: ERROR:\u00a0 permission denied for sequencename\u00a0in\u00a0PostgreSql Solution: To fix this problem, change the owner to the role that needs to access this sequence ALTER TABLE sequencename OWNER TO rolename; Change\u00a0sequencename\u00a0to your sequence name and\u00a0rolename\u00a0to the owner<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"closed","template":"","meta":{"footnotes":""},"epkb_post_type_1_category":[4427],"epkb_post_type_1_tag":[],"yoast_head":"\nALTER TABLE sequencename OWNER TO rolename;<\/pre>\n<\/div>\n<\/div>\n