Subject Re: [firebird-support] effect of CREATE VIEW not visible to transaction?
Author Ann W. Harrison
unordained wrote:
> I'm not going nuts, right?

Sorry, I'm not qualified to opine on that subject.
>
> If a transaction creates a view, it can't see the view (can't drop it, either)? But if it commits,
> then that view is visible to new transactions, and if it rolls back, the view (that it can't see)
> is dropped?

Metadata changes are instantiated during commit. There's no such thing
as a transaction-scope view.


Regards,


Ann