On 17/08/2009, at 9:46 AM, Kim Shepherd wrote:
> I assume this is to do with database schema rather than metadata > registry schema, so it probably isn't relevant.. sorry if I didn't > explain what I meant by 'schema' very well. If you inspect your > metadatafieldregistry table, you'll see the "schema ID" I'm talking > about. > Yep, that would be the `metadata_schema_id'. Thanks. > Cheers, > > Kim > >> -----Original Message----- >> From: Van Ly [mailto:v...@usyd.edu.au] >> Sent: Monday, 17 August 2009 11:36 a.m. >> To: DSpace-tech@lists.sourceforge.net >> Subject: Re: [Dspace-tech] [Dspace-devel] statistics >> >> >> On 17/08/2009, at 5:56 AM, Kim Shepherd wrote: >> >>> the subquery run by stat-initial (when it’s getting a count of >>> non-withdrawn items) looks for metadata with element ‘date’ and >>> qualifier ‘accessioned’ but ignores schema ID – both results are >>> returned, and the exception is thrown because the subquery should >>> only have returned one result. >> >> >> >> There is a definable schema `search_path' mentioned in section 5.7.3 >> Postgresql 8.1 manual which might help. >> >> Van Ly >> vly at usyd dot edu dot au >> ------------------------------------------------------------------------------ Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day trial. Simplify your report design, integration and deployment - and focus on what you do best, core application coding. Discover what's new with Crystal Reports now. http://p.sf.net/sfu/bobj-july _______________________________________________ DSpace-tech mailing list DSpace-tech@lists.sourceforge.net https://lists.sourceforge.net/lists/listinfo/dspace-tech
