The following bug has been logged online:

Bug reference: 1152
Logged by: Daniel Ruoso

Email address: daniel (AT) ruoso (DOT) com

PostgreSQL version: 7.4

Operating system: Debian GNU/Linux sid

Description: Primary key not applied in inherited tables

Details:

Hi,

I have the following set of tables

The main table is:
Titulo

And the following tables inherits the main table:
TituloCheque
TituloEDI
TituloDocumento

All these tables have the primary key on "idTitulo" which is inherited in
all tables from table Titulo.

The problem is:

When inserting a register in TituloCheque, postgresql didn't complain when
the value for idTitulo is already present on table Titulo.

Result:

Because of a bug in my software when generating the unnique ids for inserts
in Titulo (or any of the inherited tables) two registers in the table Titulo
(actually one in TituloEDI and other in TituloCheque). With the same Primary
Key value.

Expected Behavior:

Postgresql should refuse the insert of the second register with the same
primary key value.



---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster