BUG #6734: create table (like ...) fails if an index has a comment

From: daniele(dot)varrazzo(at)gmail(dot)com
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #6734: create table (like ...) fails if an index has a comment
Date: 2012-07-13 12:00:14
Message-ID: E1SpeXe-0002yi-Rr@wrigleys.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs

The following bug has been logged on the website:

Bug reference: 6734
Logged by: Daniele Varrazzo
Email address: daniele(dot)varrazzo(at)gmail(dot)com
PostgreSQL version: 9.1.4
Operating system: Linux
Description:

Weird, isn't it? Test case below.

Dropping the comment, the create table command works as expected. The
command fails with an: "ERROR: relation "foo2_f1_idx" already exists".

begin;

CREATE TABLE foo
(
id serial primary key,
f1 integer NOT NULL
);

CREATE INDEX foo_idx1 ON foo (f1);

CREATE INDEX foo_idx2 ON foo (f1) WHERE id > 10;

COMMENT ON INDEX foo_idx2 IS 'whatever';

create table foo2 (like foo including all);

rollback;

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message tsialiam 2012-07-13 13:00:23 BUG #6735: PANIC: 42501: could not open control file "global/pg_control": Permission denied
Previous Message Craig Ringer 2012-07-13 10:55:46 Re: BUG #6697: postgres.exe crashed