Commit2e83e6b

committed

Adjust hints and docs to suggest CREATE EXTENSION not CREATE LANGUAGE.

The core PLs have been extension-ified for seven years now, and we canreasonably hope that all out-of-core PLs have been too. So adjust a fewplaces that were still recommending CREATE LANGUAGE as the user-levelway to install a PL.Discussion:https://postgr.es/m/CA+TgmoaJTUDMSuSCg4k08Dv8vhbrJq9nP3ZfPbmysVz_616qxw@mail.gmail.com

1 parent76ece16 commit2e83e6bCopy full SHA for 2e83e6b

File tree

-5

lines changed

-5

lines changed

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -157,7 +157,7 @@ CREATE [ OR REPLACE ] TRANSFORM FOR <replaceable>type_name</replaceable> LANGUAG`
`157`	`157`	`<programlisting>`
`158`	`158`	`CREATE TYPE hstore ...;`
`159`	`159`
`160`		`-CREATELANGUAGE plpythonu ...;`
	`160`	`+CREATEEXTENSION plpythonu;`
`161`	`161`	`</programlisting>`
`162`	`162`	`Then create the necessary functions:`
`163`	`163`	`<programlisting>`
`@@ -176,7 +176,7 @@ CREATE TRANSFORM FOR hstore LANGUAGE plpythonu (`
`176`	`176`	`TO SQL WITH FUNCTION plpython_to_hstore(internal)`
`177`	`177`	`);`
`178`	`178`	`</programlisting>`
`179`		`- In practice, these commands would be wrapped up inextensions.`
	`179`	`+ In practice, these commands would be wrapped up inan extension.`
`180`	`180`	`</para>`
`181`	`181`
`182`	`182`	`<para>`

Lines changed: 1 addition & 1 deletion

Original file line number	Diff line number	Diff line change
`@@ -81,7 +81,7 @@ DO [ LANGUAGE <replaceable class="parameter">lang_name</replaceable> ] <replacea`
`81`	`81`
`82`	`82`	`<para>`
`83`	`83`	`The procedural language to be used must already have been installed`
`84`		`- into the current database by means of <command>CREATELANGUAGE</command>.`
	`84`	`+ into the current database by means of <command>CREATEEXTENSION</command>.`
`85`	`85`	`<literal>plpgsql</literal> is installed by default, but other languages are not.`
`86`	`86`	`</para>`
`87`	`87`

Lines changed: 2 additions & 2 deletions

Original file line number	Diff line number	Diff line change
`@@ -934,7 +934,7 @@ CreateFunction(ParseState pstate, CreateFunctionStmt stmt)`
`934`	`934`	`(errcode(ERRCODE_UNDEFINED_OBJECT),`
`935`	`935`	`errmsg("language \"%s\" does not exist",language),`
`936`	`936`	`(PLTemplateExists(language) ?`
`937`		`-errhint("Use CREATELANGUAGE to load the language into the database.") :0)));`
	`937`	`+errhint("Use CREATEEXTENSION to load the language into the database.") :0)));`
`938`	`938`
`939`	`939`	`languageOid=HeapTupleGetOid(languageTuple);`
`940`	`940`	`languageStruct= (Form_pg_language)GETSTRUCT(languageTuple);`
`@@ -2136,7 +2136,7 @@ ExecuteDoStmt(DoStmt *stmt, bool atomic)`
`2136`	`2136`	`(errcode(ERRCODE_UNDEFINED_OBJECT),`
`2137`	`2137`	`errmsg("language \"%s\" does not exist",language),`
`2138`	`2138`	`(PLTemplateExists(language) ?`
`2139`		`-errhint("Use CREATELANGUAGE to load the language into the database.") :0)));`
	`2139`	`+errhint("Use CREATEEXTENSION to load the language into the database.") :0)));`
`2140`	`2140`
`2141`	`2141`	`codeblock->langOid=HeapTupleGetOid(languageTuple);`
`2142`	`2142`	`languageStruct= (Form_pg_language)GETSTRUCT(languageTuple);`

Comments

(0)