Postgres support (Patch)
jnicolson at gmail.com
Sun Nov 20 11:43:10 CET 2005
As I only run a Postgres server at home, I have been trying to get
roundcube running on postgres.
However, I am not a coder, so what would take most of you guys no time
at all took me all day! But I think I'm getting somewhere.
I've attached a patch which passes an extra argument into
rcube_write_cache when it's been called from rcube_imap. All it does
it makes sure the sess_id variable is set when it's trying to write
the the cache, otherwise a foreign key constraint is violated. I
guess we could have just got rid of the constraint, but it makes sense
to leave them in to me.
This is more just getting rid of error messages, but there was a lot
of them, which is annoying.
The patch is in CVS diff format, hope that's ok.
Also, in the postgres SQL schema file, a column is missing in the
contacts table. However when I generated a diff against it with my
change, it erased the whole file and then wrote it all again (making
for a large patch, well, compared to the one line change). I suspect
it has something to do with line endings.
The column definition is:
changed timestamptz NOT NULL DEFAULT now(),
Insert that at line 208.
Getting the address book and settings working is next, but that will
probably take me another 2 days to figure out!
Any progress on a wiki? It'd make it much easier to ask questions.
Also, has anyone considered adding documentation tags to the code?
Something like PHPDoc, to make generating a class/method/variable list
- Jarl Nicolson
-------------- next part --------------
A non-text attachment was scrubbed...
Size: 667 bytes
Desc: not available
More information about the Dev