Just a bit more info: Running Postgres 8.0 and the: 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 ... is a row (the first row) that should be inserted/restored into the 'workorder.workorder' table. Hope that helps! -Jeanna -----Original Message----- From: pgsql-general-owner@xxxxxxxxxxxxxx [mailto:pgsql-general-owner@xxxxxxxxxxxxxx]On Behalf Of Jeanna Geier Sent: Thursday, January 11, 2007 3:10 PM To: pgsql-general Subject: [GENERAL] RESTORE Error 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 ---------------------------(end of broadcast)--------------------------- TIP 5: don't forget to increase your free space map settings
