Обсуждение: no. of functions

Hi,

   I have 30 tables and I want to write BEFORE trigger for INSERT,
DELETE and UPDATE opeation on all the
tables.

   So, can I write all the 'C' functions in a single '.so' file and load
it once? There will be in all 90 functions.
Is there any limit on how many functions can be loaded? do they need to
be in separate file?

Thanks,

Sandeep Joshi

Sandeep Joshi writes:

>    So, can I write all the 'C' functions in a single '.so' file and load
> it once? There will be in all 90 functions.

Yes.

> Is there any limit on how many functions can be loaded?

None besides running out of oids, memory, etc.

> do they need to be in separate file?

No.

--
Peter Eisentraut      peter_e@gmx.net       http://yi.org/peter-e/