Re: [GENERAL] Unique/Primary key not inherited in partition, workaround?

2012-11-07 Thread François Beausoleil
Le 2012-11-07 à 13:58, Nicholas Wilson a écrit : > Regarding the caveats here > http://www.postgresql.org/docs/9.1/interactive/ddl-inherit.html#DDL-INHERIT-CAVEATS > > I am attempting to logically structure my location data. Say for example I > have cities/states/countries. I have objects that

[GENERAL] Unique/Primary key not inherited in partition, workaround?

2012-11-07 Thread Nicholas Wilson
Regarding the caveats here http://www.postgresql.org/docs/9.1/interactive/ddl-inherit.html#DDL-INHERIT-CAVEATS I am attempting to logically structure my location data. Say for example I have cities/states/countries. I have objects that reference a location, but at any level. An object may referenc