Re: [HACKERS] question re internal functions requiring initdb

2002-07-13 Thread Joe Conway
Tom Lane wrote: > Joe Conway <[EMAIL PROTECTED]> writes: >>It made me wonder why don't we always create internal functions this >>way, or at least all except a core set of bootstrapped functions. > > I don't believe it will actually work: you *must* add an internal > function to include/catalog/

Re: [HACKERS] question re internal functions requiring initdb

2002-07-13 Thread Tom Lane
Joe Conway <[EMAIL PROTECTED]> writes: > It made me wonder why don't we always create internal functions this > way, or at least all except a core set of bootstrapped functions. I don't believe it will actually work: you *must* add an internal function to include/catalog/pg_proc.h, or it won't g

[HACKERS] question re internal functions requiring initdb

2002-07-13 Thread Joe Conway
I was trying to see if it was possible to create an 'internal' function after bootstrap (i.e. without listing in pg_proc.h). The test case below illustrates that it is indeed possible. test=# CREATE OR REPLACE FUNCTION mytest(text,int,int) RETURNS text AS 'text_substr' LANGUAGE 'internal' IMMU