RESTORE Error

From: "Jeanna Geier" <jgeier(at)apt-cafm(dot)com>
To: "pgsql-general" <pgsql-general(at)postgresql(dot)org>
Subject: RESTORE Error
Date: 2007-01-11 21:09:58
Message-ID: FBEGJLLJBCOMCDBJHIMEGEPDCCAA.jgeier@apt-cafm.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

Hi List!

I'm attempting to do a restore of a database and I'm getting the following
error the I'm not familiar with:

COPY workorder (work_order_id, projectname, request_date, requestor,
request_detail, request_completion_date, request_a...
pg_restore: restoring data for table "worksite"
pg_restore: [archiver (db)] Error from TOC entry 2584; 0 6536819 TABLE DATA
worksite postgres
pg_restore: [archiver (db)] could not execute query: ERROR: syntax error at
or near "255454" at character 1
Command was: 255454 3 WestSalem 2006-05-12 14:10:18.578-05 greg clean it
2006-05-12 17:00:00-05 W6037 Ruth Lane Onalaska Wisconsin 54650 ...
pg_restore: restoring data for table "BLOBS"
pg_restore: restored 0 large objects
WARNING: errors ignored on restore: 73

Process returned exit code 1.

The '255454' here is in the OID column of the table...

And here's the CREATE stmt for the workorder table:

CREATE TABLE workorder.workorder
(
work_order_id serial NOT NULL,
projectname varchar NOT NULL,
request_date timestamptz,
requestor varchar NOT NULL,
request_detail varchar NOT NULL,
request_completion_date timestamptz,
request_address varchar,
request_city varchar,
request_state varchar,
request_zip varchar,
request_location_description varchar,
request_floor varchar,
request_department varchar,
request_priority varchar,
request_health_security_concern varchar,
request_vandalism varchar,
request_recurring_interval varchar,
request_roomid varchar,
request_tagid varchar,
request_presence_required bool,
request_available_date timestamptz,
site_name varchar NOT NULL,
authorizer varchar,
date_authorized timestamptz,
elementid int8,
element_description varchar,
priority varchar,
work_detail varchar,
est_start_time timestamptz,
actual_start_time timestamptz,
est_completion_time timestamptz,
actual_completion_time timestamptz,
actual_labor_cost numeric,
actual_material_cost numeric,
comments varchar,
recurrence_interval int8,
account_name varchar,
CONSTRAINT pk_workorder PRIMARY KEY (work_order_id),
CONSTRAINT "Relationship238" FOREIGN KEY (projectname) REFERENCES project
(projectname) ON UPDATE CASCADE ON DELETE CASCADE,
CONSTRAINT "Relationship245" FOREIGN KEY (requestor) REFERENCES
projectuser (userid) ON UPDATE CASCADE ON DELETE RESTRICT,
CONSTRAINT "Relationship246" FOREIGN KEY (authorizer) REFERENCES
projectuser (userid) ON UPDATE CASCADE ON DELETE RESTRICT,
CONSTRAINT "Relationship254" FOREIGN KEY (projectname, account_name)
REFERENCES projectdata.account (projectname, account_name) ON UPDATE CASCADE
ON DELETE RESTRICT,
CONSTRAINT "Relationship265" FOREIGN KEY (projectname, site_name)
REFERENCES workorder.worksite (projectname, site_name) ON UPDATE CASCADE ON
DELETE RESTRICT
)

Any thoughts or ideas on the error? Thanks in advance for your help!
-Jeanna

Responses

Browse pgsql-general by date

  From Date Subject
Next Message Rafal Pietrak 2007-01-11 21:12:27 Re: TRIGGER BEFORE INSERT
Previous Message Bruno Wolff III 2007-01-11 20:32:14 Re: generate_series with month intervals