[Dspace-tech] Postgresq 8.3x error

[Jeffrey Trimble]

I've run into this error in Dspace 1.4.x when invoking index all  
(after upgrading to 8.3x).


Exception in thread "main" org.postgresql.util.PSQLException: ERROR:  
operator does not exist: integer = character varying


I've read some postings on other listservs the following solution.   
Has **anyone** seen or done this?  Or is there another work

around?

CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE  
LANGUAGE SQL AS 'SELECT textin(int4out($1));';
CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer)  
AS IMPLICIT;
COMMENT ON FUNCTION pg_catalog.text(integer) IS 'convert integer to  
text';


CREATE FUNCTION pg_catalog.text(bigint) RETURNS text STRICT IMMUTABLE  
LANGUAGE SQL AS 'SELECT textin(int8out($1));';
CREATE CAST (bigint AS text) WITH FUNCTION pg_catalog.text(bigint) AS  
IMPLICIT;

COMMENT ON FUNCTION pg_catalog.text(bigint) IS 'convert bigint to text';

Thanks in advance,


Jeffrey Trimble
System LIbrarian
William F.  Maag Library
Youngstown State University
330.941.2483 (Office)
jtrim...@cc.ysu.edu
http://www.maag.ysu.edu
http://digital.maag.ysu.edu



--
Apps built with the Adobe(R) Flex(R) framework and Flex Builder(TM) are
powering Web 2.0 with engaging, cross-platform capabilities. Quickly and
easily build your RIAs with Flex Builder, the Eclipse(TM)based development
software that enables intelligent coding and step-through debugging.
Download the free 60 day trial. http://p.sf.net/sfu/www-adobe-com___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Postgresq 8.3x error

[Allen Lam]

dspace 1.4.x does not work with postgres 8.3.

Your workaround options are upgrading to dspace 1.5.x or downgrading 
postgres to 8.2.

If you want to fix it in a hurry, changing postgres version is easier.

Regards,
Allen Lam.
HKU Hub Administrator, http://hub.hku.hk

Jeffrey Trimble wrote:
> I've run into this error in Dspace 1.4.x when invoking index all 
> (after upgrading to 8.3x).
>
> Exception in thread "main" org.postgresql.util.PSQLException: ERROR: 
> operator does not exist: integer = character varying
>
> I've read some postings on other listservs the following solution. 
>  Has **anyone** seen or done this?  Or is there another work
> around?
>
> CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT IMMUTABLE 
> LANGUAGE SQL AS 'SELECT textin(int4out($1));';
> CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer) 
> AS IMPLICIT;
> COMMENT ON FUNCTION pg_catalog.text(integer) IS 'convert integer to text';
>
> CREATE FUNCTION pg_catalog.text(bigint) RETURNS text STRICT IMMUTABLE 
> LANGUAGE SQL AS 'SELECT textin(int8out($1));';
> CREATE CAST (bigint AS text) WITH FUNCTION pg_catalog.text(bigint) AS 
> IMPLICIT;
> COMMENT ON FUNCTION pg_catalog.text(bigint) IS 'convert bigint to text';
>
> Thanks in advance,
>
>
> Jeffrey Trimble
> System LIbrarian
> William F.  Maag Library
> Youngstown State University
> 330.941.2483 (Office)
> jtrim...@cc.ysu.edu 
> http://www.maag.ysu.edu
> http://digital.maag.ysu.edu
>

--
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech

Re: [Dspace-tech] Postgresq 8.3x error

[Jeffrey Trimble]

Thanks all for the information.  After experimenting, because I really  
wanted to get onto 8.3,
the  statements below from a web site did work and our installation  
seems to be working.
I'm going to be doing some more testing with this due to some other  
issues I can ran into.

I'm planning to migrate from 14.x to 1.5x quite fast.

I'll report any final results later in the week.

Again, thanks for all the help.

-_Jeff


Jeffrey Trimble
System LIbrarian
William F.  Maag Library
Youngstown State University
330.941.2483 (Office)
jtrim...@cc.ysu.edu
http://www.maag.ysu.edu
http://digital.maag.ysu.edu



On Mar 25, 2009, at 12:37 PM, Allen Lam wrote:

> dspace 1.4.x does not work with postgres 8.3.
>
> Your workaround options are upgrading to dspace 1.5.x or downgrading
> postgres to 8.2.
>
> If you want to fix it in a hurry, changing postgres version is easier.
>
> Regards,
> Allen Lam.
> HKU Hub Administrator, http://hub.hku.hk
>
> Jeffrey Trimble wrote:
>> I've run into this error in Dspace 1.4.x when invoking index all
>> (after upgrading to 8.3x).
>>
>> Exception in thread "main" org.postgresql.util.PSQLException: ERROR:
>> operator does not exist: integer = character varying
>>
>> I've read some postings on other listservs the following solution.
>> Has **anyone** seen or done this?  Or is there another work
>> around?
>>
>> CREATE FUNCTION pg_catalog.text(integer) RETURNS text STRICT  
>> IMMUTABLE
>> LANGUAGE SQL AS 'SELECT textin(int4out($1));';
>> CREATE CAST (integer AS text) WITH FUNCTION pg_catalog.text(integer)
>> AS IMPLICIT;
>> COMMENT ON FUNCTION pg_catalog.text(integer) IS 'convert integer to  
>> text';
>>
>> CREATE FUNCTION pg_catalog.text(bigint) RETURNS text STRICT IMMUTABLE
>> LANGUAGE SQL AS 'SELECT textin(int8out($1));';
>> CREATE CAST (bigint AS text) WITH FUNCTION pg_catalog.text(bigint) AS
>> IMPLICIT;
>> COMMENT ON FUNCTION pg_catalog.text(bigint) IS 'convert bigint to  
>> text';
>>
>> Thanks in advance,
>>
>>
>> Jeffrey Trimble
>> System LIbrarian
>> William F.  Maag Library
>> Youngstown State University
>> 330.941.2483 (Office)
>> jtrim...@cc.ysu.edu 
>> http://www.maag.ysu.edu
>> http://digital.maag.ysu.edu
>>
>
> --
> ___
> DSpace-tech mailing list
> DSpace-tech@lists.sourceforge.net
> https://lists.sourceforge.net/lists/listinfo/dspace-tech


--
___
DSpace-tech mailing list
DSpace-tech@lists.sourceforge.net
https://lists.sourceforge.net/lists/listinfo/dspace-tech