hawq-commits mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From yo...@apache.org
Subject incubator-hawq-docs git commit: HAWQ-1218 - add drop language sql reference page (closes https://github.com/apache/incubator-hawq-docs/pull/75)
Date Thu, 15 Dec 2016 18:11:42 GMT
Repository: incubator-hawq-docs
Updated Branches:
  refs/heads/develop ae597e392 -> 59e6e0548


HAWQ-1218 - add drop language sql reference page (closes https://github.com/apache/incubator-hawq-docs/pull/75)


Project: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/repo
Commit: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/commit/59e6e054
Tree: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/tree/59e6e054
Diff: http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/diff/59e6e054

Branch: refs/heads/develop
Commit: 59e6e054892ea5ec7e14bb921b45f431816f8924
Parents: ae597e3
Author: Lisa Owen <lowen@pivotal.io>
Authored: Thu Dec 15 10:11:36 2016 -0800
Committer: David Yozie <yozie@apache.org>
Committed: Thu Dec 15 10:11:36 2016 -0800

----------------------------------------------------------------------
 reference/sql/CREATE-LANGUAGE.html.md.erb |  2 +-
 reference/sql/DROP-LANGUAGE.html.md.erb   | 49 ++++++++++++++++++++++++++
 2 files changed, 50 insertions(+), 1 deletion(-)
----------------------------------------------------------------------


http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/59e6e054/reference/sql/CREATE-LANGUAGE.html.md.erb
----------------------------------------------------------------------
diff --git a/reference/sql/CREATE-LANGUAGE.html.md.erb b/reference/sql/CREATE-LANGUAGE.html.md.erb
index 5a402de..6643fef 100644
--- a/reference/sql/CREATE-LANGUAGE.html.md.erb
+++ b/reference/sql/CREATE-LANGUAGE.html.md.erb
@@ -90,4 +90,4 @@ CREATE LANGUAGE plsample
 
 ## <a id="topic1__section8"></a>See Also
 
-[CREATE FUNCTION](CREATE-FUNCTION.html)
+[CREATE FUNCTION](CREATE-FUNCTION.html), [DROP LANGUAGE](DROP-LANGUAGE.html)

http://git-wip-us.apache.org/repos/asf/incubator-hawq-docs/blob/59e6e054/reference/sql/DROP-LANGUAGE.html.md.erb
----------------------------------------------------------------------
diff --git a/reference/sql/DROP-LANGUAGE.html.md.erb b/reference/sql/DROP-LANGUAGE.html.md.erb
new file mode 100644
index 0000000..efb95f8
--- /dev/null
+++ b/reference/sql/DROP-LANGUAGE.html.md.erb
@@ -0,0 +1,49 @@
+---
+title: DROP LANGUAGE
+---
+
+Removes a procedural language.
+
+## <a id="topic1__section2"></a>Synopsis
+
+``` pre
+DROP [PROCEDURAL] LANGUAGE [IF EXISTS] <name> [CASCADE | RESTRICT]
+```
+
+## <a id="topic1__section3"></a>Description
+
+`DROP LANGUAGE` will remove the definition of the previously registered procedural language
\<name\>. You must have superuser privileges to drop a language.
+
+
+## <a id="topic1__section4"></a>Parameters
+
+<dt>PROCEDURAL  </dt>
+<dd>(Optional, no effect) Indicates that this is a procedural language.</dd>
+
+<dt>IF EXISTS  </dt>
+<dd>Do not throw an error if the language does not exist. A notice message is issued
in this circumstance.</dd>
+
+<dt> \<name\>   </dt>
+<dd>The name of an existing procedural language. The name may be enclosed by single
quotes.</dd>
+
+<dt>CASCADE </dt>
+<dd>Automatically drop objects that depend on the language (for example, functions
written in that language).</dd>
+
+<dt>RESTRICT</dt>
+<dd>Refuse to drop the language if any objects depend on it. This is the default behavior.</dd>
+
+## <a id="topic1__section6"></a>Examples
+
+Remove the procedural language `plsample`:
+
+``` pre
+DROP LANGUAGE plsample;
+```
+
+## <a id="topic1__section7"></a>Compatibility
+
+`DROP LANGUAGE` is a HAWQ extension; there is no `DROP LANGUAGE` statement in the SQL standard.
+
+## <a id="topic1__section8"></a>See Also
+
+[CREATE LANGUAGE](CREATE-LANGUAGE.html)


Mime
View raw message