aboutsummaryrefslogtreecommitdiff
path: root/doc/src/sgml/ref/create_function.sgml
Commit message (Collapse)AuthorAge
* Fix erroneous handling of shared dependencies (ie dependencies on roles)Tom Lane2009-10-02
| | | | | | | | | | | | | | in CREATE OR REPLACE FUNCTION. The original code would update pg_shdepend as if a new function was being created, even if it wasn't, with two bad consequences: pg_shdepend might record the wrong owner for the function, and any dependencies for roles mentioned in the function's ACL would be lost. The fix is very easy: just don't touch pg_shdepend at all when doing a function replacement. Also update the CREATE FUNCTION reference page, which never explained exactly what changes and doesn't change in a function replacement. In passing, fix the CREATE VIEW reference page similarly; there's no code bug there, but the docs didn't say what happens.
* Fix newly-introduced documentation typo.Neil Conway2007-04-23
|
* Support explicit placement of the temporary-table schema within search_path.Tom Lane2007-04-20
| | | | | | | | | | | | | This is needed to allow a security-definer function to set a truly secure value of search_path. Without it, a malicious user can use temporary objects to execute code with the privileges of the security-definer function. Even pushing the temp schema to the back of the search path is not quite good enough, because a function or operator at the back of the path might still capture control from one nearer the front due to having a more exact datatype match. Hence, disable searching the temp schema altogether for functions and operators. Security: CVE-2007-2138
* Make an editorial pass over the reference pages.Tom Lane2005-11-01
|
* This doc patch replaces all inappropriate references to SQL:1999 when itNeil Conway2005-07-14
| | | | | is used as if it were the latest (and/or still valid) SQL standard. SQL:2003 is used in its place. Patch from Simon Riggs.
* First phase of OUT-parameters project. We can now define and use SQLTom Lane2005-03-31
| | | | | functions with OUT parameters. The various PLs still need work, as does pg_dump. Rudimentary docs and regression tests included.
* More minor updates and copy-editing.Tom Lane2005-01-04
|
* Update of conformance information to SQL:2003Peter Eisentraut2004-11-27
| | | | | | by Troels Arvin, Simon Riggs, Elein Mustain Make spelling of SQL standard names uniform.
* Remove more traces of libpgtcl from the source tree. Also, make someNeil Conway2004-10-01
| | | | | semi-related SGML cleanup. Original patch from ljb220@mindspring.com, additional cleanup by Neil Conway.
* Some editorializing on the docs for the dollar-quoting feature: fixTom Lane2004-09-20
| | | | | grammar, don't drop discussions into the middle of unrelated discussions, etc.
* Minor doc tweak: mention that function names can be optionally schema-Neil Conway2004-09-16
| | | | qualified.
* Redesign query-snapshot timing so that volatile functions in READ COMMITTEDTom Lane2004-09-13
| | | | | | | | | | | | | mode see a fresh snapshot for each command in the function, rather than using the latest interactive command's snapshot. Also, suppress fresh snapshots as well as CommandCounterIncrement inside STABLE and IMMUTABLE functions, instead using the snapshot taken for the most closely nested regular query. (This behavior is only sane for read-only functions, so the patch also enforces that such functions contain only SELECT commands.) As per my proposal of 6-Sep-2004; I note that I floated essentially the same proposal on 19-Jun-2002, but that discussion tailed off without any action. Since 8.0 seems like the right place to be taking possibly nontrivial backwards compatibility hits, let's get it done now.
* Example for create function using argument namesBruce Momjian2004-07-11
| | | | Gavin Sherry
* Add argument name to syntax.Dennis Bjorklund2004-06-25
|
* Add documentation for the new "dollar quoting" feature, and update existingNeil Conway2004-05-16
| | | | | examples to use dollar quoting when appropriate. Original patch from David Fetter, additional work and editorializing by Neil Conway.
* $Header: -> $PostgreSQL Changes ...PostgreSQL Daemon2003-11-29
|
* Documentation cleanupPeter Eisentraut2003-11-12
|
* Add mention of quotes on function body to NOTES section.Bruce Momjian2003-10-26
| | | | Oliver Elphick
* This patch fixes a few missed GUC variables that were still upper case,Bruce Momjian2003-09-11
| | | | | | | makes a few more small improvements to runtime.sgml, and makes some SGML conventions more consistent. Neil Conway
* This patch fixes a trivial typo in the CREATE FUNCTION ref page.Bruce Momjian2003-09-10
| | | | Neil Conway
* Remove a bunch of content-free Diagnostics sections, as per previousTom Lane2003-09-09
| | | | discussion. (Still have some work to do editing the remainder.)
* Add/edit index entries.Peter Eisentraut2003-08-31
|
* First batch of object rename commands.Peter Eisentraut2003-06-27
|
* More editing of reference pages.Peter Eisentraut2003-04-22
|
* Merge documentation into one book. (Build with "make html".) ReplacePeter Eisentraut2003-03-25
| | | | vague cross-references with real links.
* Minor doc patch: create functionBruce Momjian2003-03-20
| | | | Gavin Sherry
* This patch includes a lot of minor cleanups to the SGML documentation,Bruce Momjian2003-01-19
| | | | | | | | | | | | | | | | | | including: - replacing all the appropriate usages of <citetitle>PostgreSQL ...</citetitle> with &cite-user;, &cite-admin;, and so on - fix an omission in the EXECUTE documentation - add some more text to the EXPLAIN documentation - improve the PL/PgSQL RETURN NEXT documentation (more work to do here) - minor markup fixes Neil Conway
* Add more appropriate markup.Peter Eisentraut2002-09-21
|
* Add a bunch of pseudo-types to replace the behavior formerly associatedTom Lane2002-08-22
| | | | | | with OPAQUE, as per recent pghackers discussion. I still want to do some more work on the 'cstring' pseudo-type, but I'm going to commit the bulk of the changes now before the tree starts shifting under me ...
* Remove unused system table columns:Peter Eisentraut2002-07-24
| | | | | | | | | | | | | | | | | | | | | | | | pg_language.lancompiler pg_operator.oprprec pg_operator.oprisleft pg_proc.proimplicit pg_proc.probyte_pct pg_proc.properbyte_cpu pg_proc.propercall_cpu pg_proc.prooutin_ratio pg_shadow.usetrace pg_type.typprtlen pg_type.typreceive pg_type.typsend Attempts to use the obsoleted attributes of pg_operator or pg_proc in the CREATE commands will be greeted by a warning. For pg_type, there is no warning (yet) because pg_dump scripts still contain these attributes. Also remove new but already obsolete spellings isVolatile, isStable, isImmutable in WITH clause. (Use new syntax instead.)
* pg_cast table, and standards-compliant CREATE/DROP CAST commands, plusPeter Eisentraut2002-07-18
| | | | | | | | | | | extension to create binary compatible casts. Includes dependency tracking as well. pg_proc.proimplicit is now defunct, but will be removed in a separate commit. pg_dump provides a migration path from the previous scheme to declare casts. Dumping binary compatible casts is currently impossible, though.
* Allow functions to be executed with the privileges of the function owner.Peter Eisentraut2002-05-18
| | | | I took the opportunity to remove the pg_proc.proistrusted field.
* Extend syntax of CREATE FUNCTION to resemble SQL99.Peter Eisentraut2002-05-17
|
* Update SQL-command reference pages for schema features.Tom Lane2002-04-23
|
* Restructure representation of aggregate functions so that they have pg_procTom Lane2002-04-11
| | | | | | | | | | entries, per pghackers discussion. This fixes aggregates to live in namespaces, and also simplifies/speeds up lookup in parse_func.c. Also, add a 'proimplicit' flag to pg_proc that controls whether a type coercion function may be invoked implicitly, or only explicitly. The current settings of these flags are more permissive than I would like, but we will need to debate and refine the behavior; for now, I avoided breaking regression tests as much as I could.
* Divide functions into three volatility classes (immutable, stable, andTom Lane2002-04-05
| | | | | | | volatile), rather than the old cachable/noncachable distinction. This allows indexscan optimizations in many places where we formerly didn't. Also, add a pronamespace column to pg_proc (it doesn't do anything yet, however).
* Spell checking and markup additionsPeter Eisentraut2002-03-22
|
* Revert quotes, 7.2 doesn't need them for CREATE FUNCTION.Bruce Momjian2002-03-01
|
* Oops, we didn't have single quotes around 'langname' in CREATE FUNCTIONBruce Momjian2002-03-01
| | | | manual page; pointed out by IRC user.
* Privileges on functions and procedural languagesPeter Eisentraut2002-02-18
|
* Use PostgreSQL consistantly throughout docs. Before, usage was split evenlyThomas G. Lockhart2001-12-08
| | | | between Postgres and PostgreSQL.
* Initial round of tweakage for man pagesPeter Eisentraut2001-11-18
|
* More cleanup of CREATE FUNCTION examples.Tom Lane2001-10-26
|
* Add CREATE OR REPLACE FUNCTION syntax to allow replacing a functionTom Lane2001-10-02
| | | | | definition without changing the function's OID, thereby not breaking rules, views, triggers, etc that depend on it. From Gavin Sherry.
* Put some kind of grammatical uniformity in the <refpurpose> lines.Peter Eisentraut2001-09-03
|
* Make LANCOMPILER clause in CREATE LANGUAGE optional. Allow "identifier"Peter Eisentraut2001-08-13
| | | | | | | | | | | | syntax for language names (instead of 'string'). createlang now handles the case where a second language uses the same call handler as an already installed language (e.g., plperl/plperlu). droplang now handles the reverse case, i.e., dropping a language where the call handler is still used by another language. Moreover, droplang can now be used to drop any user-defined language, not just the supplied ones.
* This patch adds support for %TYPE in CREATE FUNCTION argument and returnBruce Momjian2001-06-04
| | | | | | | types. This version has an elog() to remind the user the type resolution is not dynamic. Ian Lance Taylor
* Allow special '$libdir' macro to show up in object file path in CREATEPeter Eisentraut2001-05-19
| | | | | FUNCTION command. Guard against trying to load a directory. Update documentation some.
* In create_function there is a remark concerning SQL/PSM notBruce Momjian2001-04-28
| | | | | | | | | | being ratified as yet. This is certainly no longer true, it wasn't even true in Q2/1998 when I did a little research for Date's book. SQL/PSM had been published on 1996-12-15 as ISO/IEC 9075:4. So you might want to update that section. Frank Wegmann
* Refine some things to create better looking man pages.Peter Eisentraut2000-12-25
|
generated by cgit v1.2.3 (git 2.25.1) at 2025-08-07 17:33:36 +0000