On Fri, Jun 24, 2005 at 05:49:02PM +0200, KÖPFERL Robert wrote:
>
> ERROR: could not convert table "smsMessagesrewtet" to a view because it has
> indexes
See the comments for pg_class.relhasindex:
http://www.postgresql.org/docs/8.0/static/catalog-pg-class.html
"True if this is a table and it ha
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",.
Post
