Browse categories
PostgreSQL releases
- PostgreSQL 14 (dev)
- PostgreSQL 13 (latest)
- PostgreSQL 12
- PostgreSQL 11
- PostgreSQL 10
- PostgreSQL 9.6
- PostgreSQL 9.5
- PostgreSQL 9.4 (EOL)

Version charts

SQL commands
System catalog tables
System catalog views
System statistics views
File system functions

Progress reporting views
Contrib modules
Storage parameters (relopts)

Useful overviews

xlog renaming in Pg 10
Online tools for PostgreSQL

Useful links

PostgreSQL documentation
PostgreSQL feature matrix
PostgreSQL versioning policy
PostgreSQL latest versions

@postgrespedia

Contents

Change history
References
Categories
See also

ALTER FUNCTION

A DDL command for modifying a function

ALTER FUNCTION is a DDL command for modifying an existing function.

ALTER FUNCTION was added in PostgreSQL 7.4.

Change history

PostgreSQL 12
- option SUPPORT added (commit 1fb57af9)
PostgreSQL 9.6
- DEPENDS ON EXTENSION syntax added (commit f2fcad27)
- PARALLEL { UNSAFE | RESTRICTED | SAFE } option added (commit 7aea8e4f)
PostgreSQL 8.3
- options COST and ROWS added (commit 5a7471c3)
- ALTER FUNCTION ... [ SET | RESET ] syntax added (commit 2abae34a)
- ALTER FUNCTION ... SET ... FROM CURRENT syntax added (commit e7889b83)
PostgreSQL 8.1
- ALTER FUNCTION ... action [ RESTRICT ] syntax added (commit c0696554)
- ALTER FUNCTION ... SET SCHEMA ... syntax added (commit 35508d1c)
PostgreSQL 8.0
- ALTER FUNCTION ... OWNER TO ... syntax added (commit 0adfa2c3)
PostgreSQL 7.4
- added (commit b256f242)

References

PostgreSQL documentation: ALTER FUNCTION

Categories

See also

CREATE FUNCTION, DROP FUNCTION, ALTER ROUTINE, ALTER PROCEDURE