No upcoming events available

Yeap I've seen the "There is an unfortunate bug in the upgrade path from event 5 to 6. Any help that helps to fix this is greatly appreciated." I'm not sure how deep the bug goes .. but I know that running Drupal 6.19, PostgreSQL 8.3.11 and Event 6.x-2.x-dev and even if I have an upcoming event, I'm told I don't.

I've started with a fresh install of drupal and the only non-core module enabled is Event.

After some digging I end up at event_database.pgsql.inc

I grabbed the select statement from line 121 and attempted to run it direct from psql ..

"SELECT n.nid, n.title, n.type, n.status, n.changed, e.event_start, e.event_end, e.timezone, e.has_time, e.has_end_date, extract('day' from event_start - '%s')*24 + cast(substring(cast(event_start - '%s' as varchar) from ' (..):') as integer) || substring(cast(event_start - '%s' as varchar) from ' ..(:..:..)') as time_left, 0 AS days_left FROM {node} n INNER JOIN {event} e ON n.nid = e.nid WHERE n.status = 1 AND (((e.event_start <> e.event_end) AND ('%s' >= e.event_start AND '%s' < e.event_end)) OR ((e.event_start = e.event_end) AND ('%s' <= e.event_start + '%d seconds')) OR e.event_start >= '%s') AND n.type IN ($placeholders) ORDER BY event_start;

Obviously there are some things that were passed to the sql that ended up being changed ..

{node} = node
{event} = event
'$s' = now()
$placeholders = 'event'
$d = 0

I swap out those so line 121 of event_database.pgsql.inc is ..

$query = "SELECT n.nid, n.title, n.type, n.status, n.changed, e.event_start, e.event_end, e.timezone, e.has_time, e.has_end_date, extract('day' from event_start - now())*24 + cast(substring(cast(event_start - now() as varchar) from ' (..):') as integer) || substring(cast(event_start - now() as varchar) from ' ..(:..:..)') as time_left, 0 AS days_left FROM node n INNER JOIN event e ON n.nid = e.nid WHERE n.status = 1 AND (((e.event_start <> e.event_end) AND (now() >= e.event_start AND now() < e.event_end)) OR ((e.event_start = e.event_end) AND (now() <= e.event_start + '0 seconds')) OR e.event_start >= now()) AND n.type IN ('event') ORDER BY event_start";

And then I get my upcoming event appearing. Next step find out which of those variables are causing the problem .. and then why .. and then how to fix it.