Re: pgsql functions and transactions?

Betsy Barker <betsy.barker@supportservicesinc.com> writes:
> WARNING:  ShmemAlloc: out of memory
> WARNING:  Error occurred while executing PL/pgSQL function get_facility_percentiles
> WARNING:  line 37 at execute statement
> ERROR:  LockAcquire: lock table 1 is out of memory

Hmm, are you touching a whole lot of different tables in one
transaction?  If so you may need to raise the max_locks_per_transaction
parameter.

If that doesn't help, we need more details about what you're doing.

            regards, tom lane