Re: [SQL] non-cachable 'C' language functions

2000-08-11 Thread Tom Lane
Forest Wilkinson <[EMAIL PROTECTED]> writes: > Is my understanding correct? What should I do about it? The postgresql > 6.5.2 docs for CREATE FUNCTION don't tell me how to make my functions > non-cachable. 6.5 doesn't pay any attention to proiscachable, AFAIR. 7.0 does, but it defaults to assu

[SQL] non-cachable 'C' language functions

2000-08-11 Thread Forest Wilkinson
(using postgresql 6.5.2) I have created a set of postgres extension functions in C (which use SPI to perform queries), and added them to my database with something like this: CREATE FUNCTION my_next_uid(text) RETURNS text AS '/usr/lib/pgsql/my_uids.so' LANGUAGE 'c'; My functions are designed