From: | Joe Slag <joe(dot)slag(at)walkerart(dot)org> |
---|---|
To: | pgsql-bugs(at)postgresql(dot)org |
Subject: | 7.1 -> 7.3 migration timestamp problem |
Date: | 2003-04-18 22:06:55 |
Message-ID: | 200304181706.55980.joe.slag@walkerart.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-bugs |
System Configuration
---------------------
Architecture (example: Intel Pentium) : pIII
Operating System (example: Linux 2.0.26 ELF) : OpenBSD 3.2
PostgreSQL version (example: PostgreSQL-7.3.2): PostgreSQL-7.3.2
Compiler used (example: gcc 2.95.2) : 2.95.3
Please enter a FULL description of your problem:
------------------------------------------------
Migrated from 7.1.3 to 7.3.2 by running 7.3.2's pg_dumpall on existing
databases, running initdb on a new data directory, starting up the new data
with the new pg binary, and running the addepends script in the contrib
directory.
Everything works, except inserting or updating on tables with timestamps.
Trying to do so from psql produces this:
redes=# update admin set email='flake' where admin_id = 1;
FATAL: Pre-7.3 object file made an elog() call. Recompile.
server closed the connection unexpectedly
This probably means the server terminated abnormally
before or while processing the request.
The connection to the server was lost. Attempting reset: Succeeded.
The table for this example looks like this:
redes=# \d admin
Table "public.admin"
Column | Type | Modifiers
-------------+--------------------------+-------------------------------------------------------------
admin_id | integer | not null default
nextval('public.admin_admin_id_seq'::text)
email | text | not null
password | text | not null
first_name | text |
last_name | text |
create_date | timestamp with time zone |
update_date | timestamp with time zone |
Indexes: admin_pkey primary key btree (admin_id),
admin_email_key unique btree (email)
Triggers: admin_create_tr,
admin_update_tr
If I create a new table with a timestamp column, everything works just fine.
From | Date | Subject | |
---|---|---|---|
Next Message | Peter of the Norse | 2003-04-20 03:19:48 | libpq.so.2 not found (RedHat 7.3 RPMs) |
Previous Message | Timothy.Oliver | 2003-04-18 17:28:20 | postgres sql 7.1.1 |