Re: [HACKERS] drop operator class..using .. left dependency behind.

2017-06-19 Thread Tom Lane
Rajkumar Raghuwanshi writes: > I have observed that even after dropping operator class, not able to drop > schema containing it. below is a example. You didn't read the error message closely: > *postgres=# DROP SCHEMA sch_test;ERROR: cannot drop schema sch_test > because other objects depend on

[HACKERS] drop operator class..using .. left dependency behind.

2017-06-19 Thread Rajkumar Raghuwanshi
Hi, I have observed that even after dropping operator class, not able to drop schema containing it. below is a example. postgres=# CREATE SCHEMA sch_test; CREATE SCHEMA postgres=# SET search_path TO 'sch_test'; SET postgres=# CREATE OR REPLACE FUNCTION sch_test.dummy_hashint4_39779(a int4) RETURN