On Tuesday, June 26, 2018, Pavel Stehule <
pavel.stehule@gmail.com> wrote:
But the command say "drop table" and so it must only be concerned with that subset of the namespace when searching. The note about the view is helpful, but it shouldn't change whether the command succeeded with a notice or errors.
Yes, this is what should be happening. CREATE does have to care about the whole namespace since it creating a new identifier.
I'm doubtful that there is any meaningful technical/practical challenge involved here. And as you say when doing paired drop/creates one of them is going to fail anyway so it doesn't really matter which one. But if someone wants to convert a table to a view imdompotently (the point if INE) right now they cannot using the features that are documented to do just that.
David J.