Subject Re: [firebird-support] Generator limits
Author Lucas Franzen
Magni Thor Mortensen schrieb:
> Martijn Tonies wrote:
>
>>>Is there a limit on how many generators you can create ?
>>>
>>
>>There was a limit before, but in the later Firebird versions,
>>there's no real limit.
>>
>>But what is your plan?
>>
>
> My plan is to create a generator for each row in a table by an after
> insert trigger.

You cannot perform DDL in triggers / stored procedures.
(well, you can by the means of using EXECUTEMENT STATEMENT but it's a
bad idea).
Maybe you should tell us what you like to have these generators for;
sure there's a better way to achieve whatever you want.

Luc.