Postgres Pro
Downloads
Home   >   mailing lists

Thread: no. of functions

no. of functions

From
Sandeep Joshi
Date:
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

Re: no. of functions

From
Peter Eisentraut
Date:
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/