| Subject | Re: [ib-support] Maximal "size" of a PSQL code module? |
|---|---|
| Author | Paul Reeves |
| Post date | 2003-04-23T11:10:41Z |
Thomas Steinmaurer wrote:
That may or may not be the _real_ maximum. One of the problems with the
specifications is that they often quote theoretical limits. Often there
are other practical limits that lower those limits.
In any case triggers can call stored procedures. You should be able to
break the trigger up into chunks if you have hit the BLR limit.
Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase
> Hi,48Kb of compiled BLR is the maximum.
>
> I've a pretty large (size of the source code) trigger, which
> doesn't compile with the error message "Unexpected end of
> command", but I'm sure that the source code is correct.
>
> I know I've somewhere read mentioning the maximal size of a
> PSQL code module, but I can't remember exactly that limitation
> (something around 64K?).
>
> Is it the size of the source code, the compiled BLR, the number
> of lines ...? I'm using FB 1.0.2.
>
That may or may not be the _real_ maximum. One of the problems with the
specifications is that they often quote theoretical limits. Often there
are other practical limits that lower those limits.
In any case triggers can call stored procedures. You should be able to
break the trigger up into chunks if you have hit the BLR limit.
Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase