The following bug has been logged online:

Bug reference: 2355
Logged by: Jaime Lara Alvarez
Email address: jimmy_tec (AT) yahoo (DOT) com.mx
PostgreSQL version: 8.1.3
Operating system: Windows
Description: Problem with INHERITS
Details:

// ----------- 1 --------------------------- //

CREATE TABLE cities (
id varchar(5) PRIMARY KEY,
name text
);

CREATE TABLE capitals (
state text
) INHERITS (cities);

//------------ 2 ------------------------------//
insert into cities values ('C-001','Houston');
insert into cities values ('C-002','San Antonio');

insert into capitals values ('C-003','Dallas','TX');

// ------------3 --------------------------------//
insert into cities values ('C-004','Washington')

insert into capitals values ('C-004','Washington','W')

//------------ 4 ---------------------------------//

select * from cities

Data Output
Row id(varchar) name(text)
1 "C-001" "Houston"
2 "C-002" "San Antonio"
3 "C-004" "Washington" <------
4 "C-003" "Dallas"
5 "C-004" "Washington" <------

That's a problem with the primary key

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
subscribe-nomail command to majordomo (AT) postgresql (DOT) org so that your
message can get through to the mailing list cleanly

"Jaime Lara Alvarez" <jimmy_tec (AT) yahoo (DOT) com.mx> writes:
Please note the caveats at the bottom of
http://www.postgresql.org/docs/8.1/s...l-inherit.html

regards, tom lane

---------------------------(end of broadcast)---------------------------
TIP 5: don't forget to increase your free space map settings