<!DOCTYPE html PUBLIC "-//W3C//DTD XHTML 1.1//EN"
"http://www.w3.org/TR/xhtml11/DTD/xhtml11.dtd">
<html xmlns="http://www.w3.org/1999/xhtml">
<head><meta http-equiv="content-type" content="text/html; charset=utf-8" />
<title>[203152] trunk/Websites/test-results/init-database.sql</title>
</head>
<body>
<style type="text/css"><!--
#msg dl.meta { border: 1px #006 solid; background: #369; padding: 6px; color: #fff; }
#msg dl.meta dt { float: left; width: 6em; font-weight: bold; }
#msg dt:after { content:':';}
#msg dl, #msg dt, #msg ul, #msg li, #header, #footer, #logmsg { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; }
#msg dl a { font-weight: bold}
#msg dl a:link { color:#fc3; }
#msg dl a:active { color:#ff0; }
#msg dl a:visited { color:#cc6; }
h3 { font-family: verdana,arial,helvetica,sans-serif; font-size: 10pt; font-weight: bold; }
#msg pre { overflow: auto; background: #ffc; border: 1px #fa0 solid; padding: 6px; }
#logmsg { background: #ffc; border: 1px #fa0 solid; padding: 1em 1em 0 1em; }
#logmsg p, #logmsg pre, #logmsg blockquote { margin: 0 0 1em 0; }
#logmsg p, #logmsg li, #logmsg dt, #logmsg dd { line-height: 14pt; }
#logmsg h1, #logmsg h2, #logmsg h3, #logmsg h4, #logmsg h5, #logmsg h6 { margin: .5em 0; }
#logmsg h1:first-child, #logmsg h2:first-child, #logmsg h3:first-child, #logmsg h4:first-child, #logmsg h5:first-child, #logmsg h6:first-child { margin-top: 0; }
#logmsg ul, #logmsg ol { padding: 0; list-style-position: inside; margin: 0 0 0 1em; }
#logmsg ul { text-indent: -1em; padding-left: 1em; }#logmsg ol { text-indent: -1.5em; padding-left: 1.5em; }
#logmsg > ul, #logmsg > ol { margin: 0 0 1em 0; }
#logmsg pre { background: #eee; padding: 1em; }
#logmsg blockquote { border: 1px solid #fa0; border-left-width: 10px; padding: 1em 1em 0 1em; background: white;}
#logmsg dl { margin: 0; }
#logmsg dt { font-weight: bold; }
#logmsg dd { margin: 0; padding: 0 0 0.5em 0; }
#logmsg dd:before { content:'\00bb';}
#logmsg table { border-spacing: 0px; border-collapse: collapse; border-top: 4px solid #fa0; border-bottom: 1px solid #fa0; background: #fff; }
#logmsg table th { text-align: left; font-weight: normal; padding: 0.2em 0.5em; border-top: 1px dotted #fa0; }
#logmsg table td { text-align: right; border-top: 1px dotted #fa0; padding: 0.2em 0.5em; }
#logmsg table thead th { text-align: center; border-bottom: 1px solid #fa0; }
#logmsg table th.Corner { text-align: left; }
#logmsg hr { border: none 0; border-top: 2px dashed #fa0; height: 1px; }
#header, #footer { color: #fff; background: #636; border: 1px #300 solid; padding: 6px; }
#patch { width: 100%; }
#patch h4 {font-family: verdana,arial,helvetica,sans-serif;font-size:10pt;padding:8px;background:#369;color:#fff;margin:0;}
#patch .propset h4, #patch .binary h4 {margin:0;}
#patch pre {padding:0;line-height:1.2em;margin:0;}
#patch .diff {width:100%;background:#eee;padding: 0 0 10px 0;overflow:auto;}
#patch .propset .diff, #patch .binary .diff {padding:10px 0;}
#patch span {display:block;padding:0 10px;}
#patch .modfile, #patch .addfile, #patch .delfile, #patch .propset, #patch .binary, #patch .copfile {border:1px solid #ccc;margin:10px 0;}
#patch ins {background:#dfd;text-decoration:none;display:block;padding:0 10px;}
#patch del {background:#fdd;text-decoration:none;display:block;padding:0 10px;}
#patch .lines, .info {color:#888;background:#fff;}
--></style>
<div id="msg">
<dl class="meta">
<dt>Revision</dt> <dd><a href="http://trac.webkit.org/projects/webkit/changeset/203152">203152</a></dd>
<dt>Author</dt> <dd>lforschler@apple.com</dd>
<dt>Date</dt> <dd>2016-07-12 22:45:02 -0700 (Tue, 12 Jul 2016)</dd>
</dl>
<h3>Log Message</h3>
<pre>Fix SQL: quote hyphenated string.</pre>
<h3>Modified Paths</h3>
<ul>
<li><a href="#trunkWebsitestestresultsinitdatabasesql">trunk/Websites/test-results/init-database.sql</a></li>
</ul>
</div>
<div id="patch">
<h3>Diff</h3>
<a id="trunkWebsitestestresultsinitdatabasesql"></a>
<div class="modfile"><h4>Modified: trunk/Websites/test-results/init-database.sql (203151 => 203152)</h4>
<pre class="diff"><span>
<span class="info">--- trunk/Websites/test-results/init-database.sql 2016-07-13 04:50:14 UTC (rev 203151)
+++ trunk/Websites/test-results/init-database.sql 2016-07-13 05:45:02 UTC (rev 203152)
</span><span class="lines">@@ -3,6 +3,8 @@
</span><span class="cx"> -- Drop existing schema. WARNING: this will delete all data in the database
</span><span class="cx"> DROP SCHEMA IF EXISTS public CASCADE;
</span><span class="cx"> CREATE SCHEMA public;
</span><ins>+GRANT ALL PRIVILEGES ON ALL TABLES IN SCHEMA public TO "test-results-user";
+GRANT ALL PRIVILEGES ON ALL SEQUENCES IN SCHEMA public TO "test-results-user";
</ins><span class="cx">
</span><span class="cx"> SET search_path TO public;
</span><span class="cx"> SET constraint_exclusion = partition;
</span><span class="lines">@@ -100,8 +102,8 @@
</span><span class="cx">
</span><span class="cx"> -- Table permissions are not inherited from the parent.
</span><span class="cx"> -- If permissions change on the master be sure to change them on the child also.
</span><del>-EXECUTE 'ALTER TABLE public.' || quote_ident(_tablename) || ' OWNER TO test-results-user';
-EXECUTE 'GRANT ALL ON TABLE public.' || quote_ident(_tablename) || ' TO test-results-user';
</del><ins>+EXECUTE 'ALTER TABLE public.' || quote_ident(_tablename) || ' OWNER TO "test-results-user"';
+EXECUTE 'GRANT ALL ON TABLE public.' || quote_ident(_tablename) || ' TO "test-results-user"';
</ins><span class="cx">
</span><span class="cx"> -- Indexes are defined per child, so we assign a default index that uses the partition columns
</span><span class="cx"> EXECUTE 'CREATE INDEX ' || quote_ident(_tablename||'_indx1') || ' ON public.' || quote_ident(_tablename) || ' (time, id)';
</span><span class="lines">@@ -172,10 +174,10 @@
</span><span class="cx"> $BODY$
</span><span class="cx"> LANGUAGE plpgsql VOLATILE COST 100;
</span><span class="cx">
</span><del>-ALTER FUNCTION public.partition_maintenance(text, text, date) OWNER TO test-results-user;
</del><ins>+ALTER FUNCTION public.partition_maintenance(text, text, date) OWNER TO "test-results-user";
</ins><span class="cx">
</span><del>-GRANT EXECUTE ON FUNCTION public.partition_maintenance(text, text, date) TO test-results-user;
-GRANT EXECUTE ON FUNCTION public.partition_maintenance(text, text, date) TO test-results-user;
</del><ins>+GRANT EXECUTE ON FUNCTION public.partition_maintenance(text, text, date) TO "test-results-user";
+GRANT EXECUTE ON FUNCTION public.partition_maintenance(text, text, date) TO "test-results-user";
</ins><span class="cx">
</span><span class="cx"> -- The function below is again generic and allows you to pass in the table name of the file you would like to export to the operating system and the name of the compressed file that will contain the exported table.
</span><span class="cx"> -- Helper Function for partition maintenance
</span><span class="lines">@@ -185,11 +187,11 @@
</span><span class="cx"> tablename=${1}
</span><span class="cx"> filename=${2}
</span><span class="cx"> # NOTE: pg_dump must be available in the path.
</span><del>-/usr/local/bin/pg_dump -U test-results-user -t public."${tablename}" test-results-user | gzip -c > ${filename} ;
</del><ins>+/usr/local/bin/pg_dump -U test-results-user -t public."${tablename}" test-results-db | gzip -c > ${filename} ;
</ins><span class="cx"> $BASH$
</span><span class="cx"> LANGUAGE plsh;
</span><span class="cx">
</span><del>-ALTER FUNCTION public.export_partition(text, text) OWNER TO test-results-user;
</del><ins>+ALTER FUNCTION public.export_partition(text, text) OWNER TO "test-results-user";
</ins><span class="cx">
</span><del>-GRANT EXECUTE ON FUNCTION public.export_partition(text, text) TO test-results-user;
-GRANT EXECUTE ON FUNCTION public.export_partition(text, text) TO test-results-user;
</del><span class="cx">\ No newline at end of file
</span><ins>+GRANT EXECUTE ON FUNCTION public.export_partition(text, text) TO "test-results-user";
+GRANT EXECUTE ON FUNCTION public.export_partition(text, text) TO "test-results-user";
</ins></span></pre>
</div>
</div>
</body>
</html>