Foreign key constraint not enforced??

I'm not sure what is going on here. I feel like I'm missing something
obvious. Seems like a bug, so I'm posting on -bugs.

Please see the transcript below:

postgres(at)moshe=>isesdb:apache=# \d tb_error_log_event
Table "public.tb_error_log_event"
Column | Type |
Modifiers
----------------------+-----------------------------+-----------------------------------------------------
error_log_event | bigint | not null default
nextval('sq_pk_error_log_event'::r.
| |.egclass)
created | timestamp without time zone | not null default now()
logged | timestamp without time zone | not null
message_placeholders | integer[] |
error_log_message | bigint | not null
client_ip | inet | not null
server | integer | not null
domain | integer | not null
log_level | integer | not null
Indexes:
"tb_error_log_event_pkey" PRIMARY KEY, btree (error_log_event)
Foreign-key constraints:
"tb_error_log_event_domain_fkey" FOREIGN KEY (domain) REFERENCES
tb_domain(domain)
"tb_error_log_event_error_log_message_fkey" FOREIGN KEY
(error_log_message) REFERENCES tb_error_log_message(error_log_message)
"tb_error_log_event_log_level_fkey" FOREIGN KEY (log_level)
REFERENCES tb_log_level(log_level)
"tb_error_log_event_server_fkey" FOREIGN KEY (server) REFERENCES
tb_server(server)
Number of child tables: 1 (Use \d+ to list them.)

postgres(at)moshe=>isesdb:apache=# select error_log_event,
error_log_message from tb_error_log_event;
error_log_event | error_log_message
-----------------+-------------------
17 | 5
18 | 6
(2 rows)

Time: 0.853 ms
postgres(at)moshe=>isesdb:apache=# select * from tb_error_log_message;
error_log_message | message_body
-------------------+--------------------------------------------------------------------------------------
6 | test error log message ? ? ? ? ? ?-lalala ,
referer: http://ises.robert.neadwerx.co.
|.m/reports/reports.php
(1 row)

Time: 0.782 ms
postgres(at)moshe=>isesdb:apache=#

Surprisingly, I was able to pg_dump and pg_restore the database, and the
inconsistency remained!

Fortunately, also, I am able to share the pg_dump. You can download it here:

Binary dump: https://dl.dropboxusercontent.com/u/12192123/apache.pg_dump
Text dump: https://dl.dropboxusercontent.com/u/12192123/apache.pg_dump.sql

Thanks for any insight.

Moshe Jacobson
Manager of Systems Engineering, Nead Werx Inc. <http://www.neadwerx.com>
2323 Cumberland Parkway · Suite 201 · Atlanta, GA 30339

"Quality is not an act, it is a habit." -- Aristotle