This works in isolating the deleted bitstreams.
"SELECT
bitstream.*
FROM
public.bitstream
WHERE
bitstream.deleted = 't';"
On 14 March 2013 15:59, helix84 <heli...@centrum.sk> wrote:
> On Thu, Mar 14, 2013 at 2:11 PM, Hilton Gibson <hilton.gib...@gmail.com>
> wrote:
> > Nope. It does not work on a new test system using DSpace 1.8.2.
> > My "bundle" table has blanks for "primary_bitstream_id".
>
> Here are my results (DSpace 3.0, database originally from 1.6, but cleaned
> in the past):
>
> dspace=> SELECT bundle.* FROM bitstream, bundle2bitstream, bundle
> WHERE bitstream.bitstream_id = bundle2bitstream.bitstream_id
> AND bundle2bitstream.bundle_id = bundle.bundle_id
> AND deleted='t';
> bundle_id | name | primary_bitstream_id
> -----------+------+----------------------
> (0 rows)
>
>
>
> Regards,
> ~~helix84
>
> Compulsory reading: DSpace Mailing List Etiquette
> https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
>
--
*Hilton Gibson*
Systems Administrator
JS Gericke Library
Room 1025D
Stellenbosch University
Private Bag X5036
Stellenbosch
7599
South Africa
Tel: +27 21 808 4100 | Cell: +27 84 646 4758
http://library.sun.ac.za
http://scholar.sun.ac.za
http://ar1.sun.ac.za
http://aj1.sun.ac.za
------------------------------------------------------------------------------
Everyone hates slow websites. So do we.
Make your web apps faster with AppDynamics
Download AppDynamics Lite for free today:
http://p.sf.net/sfu/appdyn_d2d_mar
_______________________________________________
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech
List Etiquette: https://wiki.duraspace.org/display/DSPACE/Mailing+List+Etiquette
