Postgres Pro
Downloads
Home   >   mailing lists

ALTER TABLE... OWNER bugette - Mailing list pgsql-hackers

From Dave Page
Subject ALTER TABLE... OWNER bugette
Date
Msg-id D85C66DA59BA044EB96AB9683819CF6101536F@dogbert.vale-housing.co.uk
Whole thread Raw
List pgsql-hackers
Tree view 
In a 7.3 dev test database, I have a table called msysconf in a schema
called biblio. If I execute:

ALTER TABLE biblio.msysconf OWNER TO dpage

I get:

ERROR:  msysconf_idx is an index relation

There is an index with this name on the table.

Any ideas?

Regards, Dave.

pgsql-hackers by date:

Previous
From: Tom Lane
Date:
Subject: Re: Missing types in C header files
Next
From: Tom Lane
Date:
Subject: Re: [SQL] Efficient DELETE Strategies