On 15/03/2022 15:20, Vlad Khorsun wrote: >> So CREATEd LTTs cannot be used in PSQL routines, only by DSQL? > > At first look I see two way's to go: > a) PSQL routines can't see CREATE'd LTT's, or > b) PSQL routines can see and use LTT definition that exists at the > moment of routine > definition\loading into metadata cache. Such LTT's definition should > be not changed > while dependend PSQL routine reside in metadata cache, or PSQL > routine should be > invalidated when LTT definition it depends on is changed. > > Of course, there could be something else, lets continue to think on it. >
I think (a) is the best option. (b) seems not friendly for Firebird and for this usage GTT seems the way to go. Adriano Firebird-Devel mailing list, web interface at https://lists.sourceforge.net/lists/listinfo/firebird-devel