I haven't used the clickstream module at all, so I can't help you there. But I remember reading somewhere that someone, can't recall who, had ported it to Postgres for OpenForce. It has never been released as far as I know, but you might want to ask them about it. It could be that it wasn't released because it turned out not to be useful, as Talli says at the top of this thread.
