Thread: FW: ALTER TABLE... OWNER bugette (repost)

FW: ALTER TABLE... OWNER bugette (repost)

From
"Dave Page"
Date:
I posted this last week but got no responses :-( - It's not causing me
problems but if it is a bug...

Regards, Dave.


> -----Original Message-----
> From: Dave Page
> Sent: 10 June 2002 15:11
> To: PostgreSQL-development
> Subject: ALTER TABLE... OWNER bugette
>
>
> 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.
>


Re: FW: ALTER TABLE... OWNER bugette (repost)

From
Tom Lane
Date:
"Dave Page" <dpage@vale-housing.co.uk> writes:
>> ALTER TABLE biblio.msysconf OWNER TO dpage
>> ERROR:  msysconf_idx is an index relation

Fixed.
        regards, tom lane


Re: FW: ALTER TABLE... OWNER bugette (repost)

From
"Dave Page"
Date:
Thanks.

> -----Original Message-----
> From: Tom Lane [mailto:tgl@sss.pgh.pa.us]
> Sent: 17 June 2002 15:32
> To: Dave Page
> Cc: PostgreSQL-development
> Subject: Re: [HACKERS] FW: ALTER TABLE... OWNER bugette (repost)
>
>
> "Dave Page" <dpage@vale-housing.co.uk> writes:
> >> ALTER TABLE biblio.msysconf OWNER TO dpage
> >> ERROR:  msysconf_idx is an index relation
>
> Fixed.
>
>             regards, tom lane
>
>