Getting issue when recreate view for custom schema

bill-ramos-rmoswi / babelfish_postgresql_towel

Bill Ramos's knowledge base for tips, tricks, and best practices for migrating SQL Server solutions to Babelfish for PostgreSQL and the open-source WiltonDB for Windows

Apache License 2.0

1 stars 1 forks source link

Getting issue when recreate view for custom schema #19

Open JayakumarEMIS opened 6 days ago

JayakumarEMIS commented 6 days ago

Hi @bill-ramos-rmoswi,

 We created the custom schema and creating view one view next we dropped the view and when we trying to recreate the view we getting below exception, but in some times is not occur that, sharing script below kindly check it if issue can reproduce.

` CREATE SCHEMA RWR

CREATE VIEW RWR.[StockItemView] AS SELECT 1

DROP VIEW RWR.[StockItemView]

CREATE VIEW RWR.[StockItemView] AS SELECT 1`

staticlibs commented 6 days ago

@JayakumarEMIS

This seems to be a duplicate of #57.

JayakumarEMIS commented 6 days ago

Thanks @staticlibs, believe will fix in future