7.1 -> 7.3 migration timestamp problem

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.

Responses

Browse pgsql-bugs by date

  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