On Mon, Jan 26, 2004 at 04:40:33PM -0500, Matthew Jones wrote: > Is there a way, when a function is created (in language SQL for example), > for it to be available globally, as the pg_catalog functions are. All of > the ones I create are only available on the database they were created, > and I can't figure out a way to make it so they're available to all > without having to run the functions in every database. When you run a > select on pg_proc they won't even appear, but all of the 'catalog' ones > will.
If you create a function in template1 it will be automatically transferred to new database created, but not to existing ones. So just after installation, add them to template1, then create the other databases. -- Martijn van Oosterhout <[EMAIL PROTECTED]> http://svana.org/kleptog/ > (... have gone from d-i being barely usable even by its developers > anywhere, to being about 20% done. Sweet. And the last 80% usually takes > 20% of the time, too, right?) -- Anthony Towns, debian-devel-announce
pgp00000.pgp
Description: PGP signature
