BUG #5988: CTINE duplicates constraints

From: "Marko Tiikkaja" <marko(dot)tiikkaja(at)2ndquadrant(dot)com>
To: pgsql-bugs(at)postgresql(dot)org
Subject: BUG #5988: CTINE duplicates constraints
Date: 2011-04-20 12:51:50
Message-ID: 201104201251.p3KCpox7062445@wwwmaster.postgresql.org
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-bugs


The following bug has been logged online:

Bug reference: 5988
Logged by: Marko Tiikkaja
Email address: marko(dot)tiikkaja(at)2ndquadrant(dot)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.

Responses

Browse pgsql-bugs by date

  From Date Subject
Next Message Tom Lane 2011-04-20 13:11:16 Re: BUG #5985: CLUSTER ... USING can fail with ERROR: index xxx does not belong to table yyy
Previous Message Joshua Tolley 2011-04-20 09:45:26 Re: BUG #5966: extract(epoch..) function error