Converting TBL->View complaining about indexes - Mailing list pgsql-sql

From KÖPFERL Robert
Subject Converting TBL->View complaining about indexes
Date
Msg-id ED4E30DD9C43D5118DFB00508BBBA76EB1679E@neptun.sonorys.at
Whole thread Raw
Responses Re: Converting TBL->View complaining about indexes  (Michael Fuhr <mike@fuhr.org>)
List pgsql-sql
Hi, 
I'm currently trying to make a table (where many fcns depend on) become a
view.

Thus I did a _truncate_ and lots of _alter table drop constraint_ and  _drop
index_

and then
CREATE OR REPLACE RULE "_RETURN" AS  ON SELECT TO "smsMessagesrewtet"  DO INSTEAD 
SELECT  "MessageID",.....


Postgres keeps returning 
ERROR:  could not convert table "smsMessagesrewtet" to a view because it has
indexes


However I am sure there are no indexes nor PK or any constraints. What else
could it be?


Thanks


pgsql-sql by date:

Previous
From: Tom Lane
Date:
Subject: Re: empty view, replace view, column type change?
Next
From: Michael Fuhr
Date:
Subject: Re: Converting TBL->View complaining about indexes