Re: BUG #13860: Duplicated primary key - Mailing list pgsql-bugs

From Baso10 Dev
Subject Re: BUG #13860: Duplicated primary key
Date
Msg-id CAKZHju3auXfsa0dMXUFhz2=OnGsCyur5F87w3RopXjPhMn3Jkg@mail.gmail.com
Whole thread Raw
In response to Re: BUG #13860: Duplicated primary key  (Tom Lane <tgl@sss.pgh.pa.us>)
List pgsql-bugs
Yes, I am seeing behaviour like in the link. I guess it is not a bug then.

Regards,
Domen

2016-01-12 1:39 GMT+02:00 Tom Lane <tgl@sss.pgh.pa.us>:

> 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 by date:

Previous
From: Frik Brits
Date:
Subject: permissions.
Next
From: Mark Kirkwood
Date:
Subject: Re: BUG #13852: SQL Select Slow Issues