> 2020年4月29日 下午7:46，tushar <tushar.ah...@enterprisedb.com> 写道： > > On 4/29/20 8:52 AM, 曾文旌 wrote: >> Fixed the error message to make the expression more accurate. In v33. > > Thanks wenjing > > Please refer this scenario , where getting an error while performing cluster > o/p > > 1) > > X terminal - > > postgres=# create global temp table f(n int); > CREATE TABLE > > Y Terminal - > > postgres=# create index index12 on f(n); > CREATE INDEX > postgres=# \q > > X terminal - > > postgres=# reindex index index12; > REINDEX > postgres=# cluster f using index12; > ERROR: cannot cluster on invalid index "index12" > postgres=# drop index index12; > DROP INDEX > > if this is an expected , could we try to make the error message more > simpler, if possible. > > Another issue - > > X terminal - > > postgres=# create global temp table f11(n int); > CREATE TABLE > postgres=# create index ind1 on f11(n); > CREATE INDEX > postgres=# create index ind2 on f11(n); > CREATE INDEX > postgres=# > > Y terminal - > > postgres=# drop table f11; > ERROR: cannot drop index ind2 or global temporary table f11 > HINT: Because the index is created on the global temporary table and other > backend attached it. > postgres=# > > it is only mentioning about ind2 index but what about ind1 and what if - > they have lots of indexes ? > i think - we should not mix index information while dropping the table and > vice versa. postgres=# drop index index12; ERROR: cannot drop index index12 or global temporary table f HINT: Because the index is created on the global temporary table and other backend attached it.
postgres=# drop table f; ERROR: cannot drop index index12 or global temporary table f HINT: Because the index is created on the global temporary table and other backend attached it. postgres=# Dropping an index on a GTT and dropping a GTT with an index can both trigger this message, so the message looks like this, and it feels like there's no better way to do it. Wenjing > > -- > regards,tushar > EnterpriseDB https://www.enterprisedb.com/ > The Enterprise PostgreSQL Company
smime.p7s
Description: S/MIME cryptographic signature
