From: | Marko Tiikkaja <marko(at)joh(dot)to> |
---|---|
To: | PostgreSQL Hackers <pgsql-hackers(at)postgresql(dot)org> |
Subject: | ALTER TABLE behind-the-scenes effects' CONTEXT |
Date: | 2015-10-04 22:08:49 |
Message-ID: | 5611A371.2030704@joh.to |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
Hi,
In the past I've found the error message in cases such as this somewhat
less helpful than it could be:
=# CREATE TABLE qqq (a int);
=# CREATE UNIQUE INDEX IF NOT EXISTS qqq_a_idx ON qqq(a);
=# ALTER TABLE qqq ALTER COLUMN a TYPE json USING NULL;
ERROR: data type json has no default operator class for access method
"btree"
HINT: You must specify an operator class for the index or define a
default operator class for the data type.
The attached patch adds a CONTEXT line to index and constraint rebuilds,
e.g:
CONTEXT: while rebuilding index qqq_a_idx
Any feedback welcome.
.m
Attachment | Content-Type | Size |
---|---|---|
alter_column_bhs_effects_context.v0.patch | text/plain | 4.4 KB |
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2015-10-04 22:10:23 | Re: Less than ideal error reporting in pg_stat_statements |
Previous Message | Peter Geoghegan | 2015-10-04 20:25:21 | Re: Less than ideal error reporting in pg_stat_statements |