Radicore Forum: RADICORE Installation Issues » Problem using PostgreSQL 9.1

Home » RADICORE » RADICORE Installation Issues » Problem using PostgreSQL 9.1

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Re: Problem using PostgreSQL 9.1 [message #2845 is a reply to message #2844]

Wed, 14 December 2011 12:15

AJM
Messages: 2376
Registered: April 2006
Location: Surrey, UK

Senior Member

I've managed to change the pgsql class to convert the arguments in the DATE_SUB() function into the correct types, as follows:

WHERE DATE_SUB(due_date::timestamp, visibility * '1 day'::interval) <= '2011-12-14'

I've also had to change the where2indexedArray() function in the library to accept '::' in column names.

The two changed files are in the attached update. See if this fixes your problem.

Attachment: postgres-fix-2011-12-14.zip
(Size: 53.55KB, Downloaded 1270 times)

Tony Marston
http://www.tonymarston.net
http://www.radicore.org

Report message to a moderator

[Message index]

		Problem using PostgreSQL 9.1 By: roderickm on Tue, 13 December 2011 09:14
		Re: Problem using PostgreSQL 9.1 By: AJM on Tue, 13 December 2011 15:48
		Re: Problem using PostgreSQL 9.1 By: AJM on Wed, 14 December 2011 04:30
		Re: Problem using PostgreSQL 9.1 By: roderickm on Wed, 14 December 2011 09:20
		Re: Problem using PostgreSQL 9.1 By: AJM on Wed, 14 December 2011 12:15
		Re: Problem using PostgreSQL 9.1 By: roderickm on Thu, 15 December 2011 03:16
		Re: Problem using PostgreSQL 9.1 By: smithcharles on Thu, 15 December 2011 00:16
		Re: Problem using PostgreSQL 9.1 By: AJM on Thu, 15 December 2011 04:30
		Re: Problem using PostgreSQL 9.1 By: kong on Tue, 20 March 2012 11:31
		Re: Problem using PostgreSQL 9.1 By: AJM on Tue, 20 March 2012 14:29

Previous Topic:	Login Error
Next Topic:	Class 'radicore_view' not found

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

] [

]

Current Time: Sun Feb 16 09:13:24 EST 2025

Total time taken to generate the page: 0.01064 seconds