That is correct. But table old will NOT be converted to new because
only the schema name is converted. And table "old" WILL exist because it will also be copied.
I have tested and it works properly.
Please do not provide hypothetical examples. Give me an actual working example that causes the problem.
This statement:SELECT old.field FROM old.old;selects column “field” from table “old” which is in schema “old”.Your script converts it into:SELECT new.field FROM new.oldwhich will try to select column “field” from table “old” in schema “new”. Again:SELECT new.fieldmeans select column “field” from table “new”, which does not exists.Not sure, what other example you need.Regards,Igor Neyman
This statement:
SELECT old.field FROM old.old;
selects column “field” from table “old” which is in schema “old”.
Your script converts it into:
SELECT new.field FROM new.old
which will try to select column “field” from table “old” in schema “new”.
Again:
SELECT new.field
means select column “field” from table “new”, which does not exists.
Not sure, what other example you need.
Regards,
Igor Neyman
pgsql-general by date:
Соглашаюсь с условиями обработки персональных данных
