BUG #5988: CTINE duplicates constraints

Поиск
Список
Период
Сортировка
От Marko Tiikkaja
Тема BUG #5988: CTINE duplicates constraints
Дата
Msg-id 201104201251.p3KCpox7062445@wwwmaster.postgresql.org
обсуждение исходный текст
Ответы Re: BUG #5988: CTINE duplicates constraints  (Tom Lane <tgl@sss.pgh.pa.us>)
Список pgsql-bugs
The following bug has been logged online:

Bug reference:      5988
Logged by:          Marko Tiikkaja
Email address:      marko.tiikkaja@2ndquadrant.com
PostgreSQL version: git master
Operating system:   Linux
Description:        CTINE duplicates constraints
Details:

CREATE TABLE IF NOT EXISTS duplicates some constraints if the new table
isn't created:

=# create table foo(a int primary key);
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey"
for table "foo"
CREATE TABLE

=# create table if not exists foo(a int primary key);
NOTICE:  relation "foo" already exists, skipping
NOTICE:  CREATE TABLE / PRIMARY KEY will create implicit index "foo_pkey1"
for table "foo"
CREATE TABLE

=# \d foo
      Table "public.foo"
 Column |  Type   | Modifiers
--------+---------+-----------
 a      | integer | not null
Indexes:
    "foo_pkey" PRIMARY KEY, btree (a)
    "foo_pkey1" PRIMARY KEY, btree (a)

It seems to do that at least for PRIMARY KEY and UNIQUE constraints.

В списке pgsql-bugs по дате отправления:

Предыдущее
От: Joshua Tolley
Дата:
Сообщение: Re: BUG #5966: extract(epoch..) function error
Следующее
От: Tom Lane
Дата:
Сообщение: Re: BUG #5985: CLUSTER ... USING can fail with ERROR: index xxx does not belong to table yyy