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@moshe=3D>isesdb:apache=3D# \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@moshe=3D>isesdb:apache=3D# 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@moshe=3D>isesdb:apache=3D# 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@moshe=3D>isesdb:apache=3D#
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 =B7 Suite 201 =B7 Atlanta, GA 30339
"Quality is not an act, it is a habit." -- Aristotle