On 10/03/2011 04:14 AM, Sim Zacks wrote: > I don't know if there is an official definition, but an extension is > generally a compiled program that is accessed by the SQL. It must be > compiled with the postgresql headers and have the magic number defined. > The compiled file must then be put into the lib directory with the other > postgresql extensions. > > A user defined function does extend postgresql, but it doesn't have any > of the complications.
As of 9.1 (and I *was* thinking in terms of 9.1 when I wrote "EXTENSION"), there is a definition in: http://www.postgresql.org/docs/9.1/static/sql-createextension.html http://www.postgresql.org/docs/9.1/static/extend-extensions.html You'll notice that in the latter there is an example of a SQL-only extension. That's why I thinking of Pyrseas as some plpython functions as a true EXTENSION. Joe -- Sent via pgsql-general mailing list (pgsql-general@postgresql.org) To make changes to your subscription: http://www.postgresql.org/mailpref/pgsql-general
