Re: BUG #13860: Duplicated primary key

Поиск
Список
Период
Сортировка
От Tom Lane
Тема Re: BUG #13860: Duplicated primary key
Дата
Msg-id 10023.1452555556@sss.pgh.pa.us
обсуждение исходный текст
Ответ на BUG #13860: Duplicated primary key  (baso10dev@gmail.com)
Ответы Re: BUG #13860: Duplicated primary key  (Baso10 Dev <baso10dev@gmail.com>)
Список pgsql-bugs
baso10dev@gmail.com writes:
> I have a table A.
> I have created table B that inherits table A.
> After playing around I noticed there are duplicate keys in table A.

Most likely, what you're seeing is the behavior described in

http://www.postgresql.org/docs/9.4/static/ddl-inherit.html#DDL-INHERIT-CAVEATS

specifically that a unique constraint on A doesn't apply to B nor
vice versa.

If that's not it, we're going to need a concrete example.

            regards, tom lane

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

Предыдущее
От: John R Pierce
Дата:
Сообщение: Re: BUG #13860: Duplicated primary key
Следующее
От: Michael Paquier
Дата:
Сообщение: Re: BUG #13858: Server with debugger installed consumes 100% of one CPU core