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;
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 |