[rt-users] incompatibility with Postgres 7.3

[Louis-David Mitterrand]

Hi,

I just installed RT on our debian (unstable) server and think I came
accross a bug triggered by a change in the way Postgres 7.3 handles
integer comparisons: you can no longer INSERT or equate an INTEGER to an
empty space. In 7.2 the empty space would be silently treated as 0, now
it triggers this error:

auction=# select 0 = '';
ERROR:  pg_atoi: zero-length string

In RT 2.1.75 the bug is triggered when creating a ticket from the web
interface:

	[Thu Feb 20 13:45:25 2003] [warning]: DBD::Pg::st execute failed: ERROR:  pg_atoi: zero-length string at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 376. (/usr/local/rt3/lib/RT.pm:220)
	[Thu Feb 20 13:45:25 2003] [warning]: RT::Handle=HASH(0xaafb37c) couldn't execute the query 'INSERT INTO Tickets (TimeEstimated, Status, Queue, Type, InitialPriority, Starts, TimeWorked, LastUpdated, Subject, FinalPriority, TimeLeft, Creator, Owner, LastUpdatedBy, Resolved, Created, Priority, Due) VALUES (?, ?, ?, ?, ? , ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)' at /usr/share/perl5/DBIx/SearchBuilder/Handle.pm line 383. (/usr/local/rt3/lib/RT.pm:220)

Let me know if you need more details,

Best regards, thanks for what seems like a great app!

-- 
ldm at apartia.org