Hi Amy!
Not that I completely understand it, but I run
*dspace=# \set a 15b3ebc4-ae05-461e-ab9d-3a39bdb1bb50*
*dspace=# SELECT requestitem_id AS b FROM requestitem WHERE bitstream_id =
:'a'; b--- 2 3(2 rows)*
and then
*dspace=# UPDATE requestitem SET bitstream_id = null WHERE
You could try substituting requestitem_id for item_id in those same
queries. It's the Primary Key in the requestitem table, and thus cannot be
empty, so you should get 2 unique values that you can use to update the
records. You will just have to run the update query for each value returned.
On
For clarity, the error is
*Caused by: org.postgresql.util.PSQLException: ERROR: update or delete on
table "bitstream" violates foreign key constraint
"requestitem_bitstream_id_fkey" on table "requestitem"*
* Detail: Key (uuid)=(15b3ebc4-ae05-461e-ab9d-3a39bdb1bb50) is still
referenced from
Hi!
I have the same error on cleanup. Trying to use this method to fix it.
But I receive 2 empty rows here instead of some uuids
*\set a 15b3ebc4-ae05-461e-ab9d-3a39bdb1bb50 dspace=# SELECT item_id AS b
FROM requestitem WHERE bitstream_id = :'a';*b
- - -
(2 rows)
This looks OK though
Thanks so much. Just what I needed. -- Wally
On Wednesday, July 5, 2023 at 2:29:31 AM UTC-4 Technologiczny Informator
wrote:
> Hi,
>
> Mark was replying to my post then. While cleaning I had the same one case
> as yours. Since you got to know Mark's method, I'm throwing you my
> "procedure"
Hi,
Mark was replying to my post then. While cleaning I had the same one case
as yours. Since you got to know Mark's method, I'm throwing you my
"procedure" without comment:
*ERROR: update or delete on table "bitstream" violates foreign key
constraint "requestitem_bitstream_id_fkey" on table
