Thread: FW: ALTER TABLE... OWNER bugette (repost)
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. >
"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
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 > >