BUG #6734: create table (like ...) fails if an index has a comment
| От | daniele.varrazzo@gmail.com |
|---|---|
| Тема | BUG #6734: create table (like ...) fails if an index has a comment |
| Дата | |
| Msg-id | E1SpeXe-0002yi-Rr@wrigleys.postgresql.org обсуждение исходный текст |
| Ответы |
Re: BUG #6734: create table (like ...) fails if an index
has a comment
Re: BUG #6734: create table (like ...) fails if an index has a comment |
| Список | pgsql-bugs |
The following bug has been logged on the website: Bug reference: 6734 Logged by: Daniele Varrazzo Email address: daniele.varrazzo@gmail.com PostgreSQL version: 9.1.4 Operating system: Linux Description:=20=20=20=20=20=20=20=20 Weird, isn't it? Test case below.=20 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;
В списке pgsql-bugs по дате отправления: