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.
Show quoted text
-----Original Message-----
From: Dave Page
Sent: 10 June 2002 15:11
To: PostgreSQL-development
Subject: ALTER TABLE... OWNER bugetteIn 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.
Show quoted text
-----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 relationFixed.
regards, tom lane
Import Notes
Resolved by subject fallback