ALTER TABLE behind-the-scenes effects' CONTEXT

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

Responses

Browse pgsql-hackers by date

  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