Dmitry Yemanov wrote:

>"Ann W. Harrison" <aharrison@...> wrote:
>
>
>>My suggestion is that we add the RDB$PROCEDURE_TYPE
>>field, filled in when the procedure is compiled and
>>do nothing else. No additional checks, errors, or
>>anything.
>>
>>1) Existing stuff, including really warped procedures
>>that do one thing when invoked with EXECUTE PROCEDURE
>>and another when SELECTED still work - as well as they
>>ever did.
>>
>>2) Interface layers no longer have to parse procedures
>>to guess the best way to invoke them.
>>
>>3) Naive users get a hint of how the system thinks their
>>procedure should be invoked.
>>
>>
>
>Nice summary, Ann :-) I second this suggestion.
>
>

I continue to think we should have a standalone program to do to
existing databases what the procedure compiler will do in future
databases. An I also think that gpre should be extended to backup and
restore rdb$procedure_type.


[Non-text portions of this message have been removed]