Peter,
Thanks. Our system was created using a 7.x version but we are currently
running an 8.x version. Now, on to the statistics!
From: [email protected] [mailto:[email protected]] On Behalf Of Peter Dietz
Sent: Friday, March 05, 2010 9:43 AM
To: Poulter, Dale
Cc: [email protected]
Subject: Re: [Dspace-tech] Error when updating scheme from 1.5.2. to 1.6
Hi Dale,
I've run into that when upgrading instances during testathon. 1.5.2 -> 1.6rc1 |
1.6rc2
I've had to comment out those lines, and I haven't noticed any issues.
Especially since its dropping a constraint which doesn't exist.
Also, since I find it easier to just run a correct query as opposed to backup,
run bad query, restore backup, ... I find it easier to wrap database upgrade
scripts into a transaction so it either all works, or doesn't alter anything.
BEGIN;
whole bunch of db scripts
# ALTER TABLE community2collection DROP CONSTRAINT
community2collection_collection_id_fkey;
# ALTER TABLE community2community DROP CONSTRAINT
community2community_child_comm_id_fkey;
#ALTER TABLE collection2item DROP CONSTRAINT collection2item_item_id_fkey;
COMMIT;
I had asked this on the IRC #dspace back in December, and I think Mark Diggory
had asked me what version of postgres I was using, if it was pre-postgres 8.x.
Our production server is 8.1.11, however initial install and previous upgrades
would likely have been on an older version of pg.
On Fri, Mar 5, 2010 at 10:03 AM, Poulter, Dale
<[email protected]<mailto:[email protected]>> wrote:
Good morning,
We are attempting to upgrade our development instance to 1.6 and received the
errors below when updating the schema. Any suggestions as to the
cause/correction? Thanks.
psql:./database_schema_15-16.sql:105: ERROR: constraint
"community2collection_collection_id_fkey" of relation "community2collection"
does not exist
ALTER TABLE
psql:./database_schema_15-16.sql:108: ERROR: constraint
"community2community_child_comm_id_fkey" of relation "community2community" does
not exist
ALTER TABLE
psql:./database_schema_15-16.sql:111: ERROR: constraint
"collection2item_item_id_fkey" of relation "collection2item" does not exist
--Dale
---------------------------------------
Dale Poulter
Automation Coordinator
Library Information Technology Services
Vanderbilt University
Suite 700
110 21st Avenue South
Nashville, TN 37240
(615)343-5388
(615)343-8834 (fax)
(615)207-9705 (cell)
[email protected]<mailto:[email protected]>
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
DSpace-tech mailing list
[email protected]<mailto:[email protected]>
https://lists.sourceforge.net/lists/listinfo/dspace-tech
--
Peter Dietz
Systems Developer/Engineer
Ohio State University Libraries
------------------------------------------------------------------------------
Download Intel® Parallel Studio Eval
Try the new software tools for yourself. Speed compiling, find bugs
proactively, and fine-tune applications for parallel performance.
See why Intel Parallel Studio got high marks during beta.
http://p.sf.net/sfu/intel-sw-dev
_______________________________________________
DSpace-tech mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/dspace-tech
