there is none at the moment.

i'll be working on it over the next couple of weeks, but i'm a newb to postgres, so any help would be greatly appreciated.

CommentFileSizeAuthor
#8 chatroom.install_1.patch.txt2.77 KBk4ml
#7 chatroom.install_0.patch2.77 KBdarren oh
#6 chatroom.install7.75 KBk4ml

Comments

Anonymous’s picture

Anonymous (not verified) commented
Version: » master

i've started work on this. i have a fresh postgres install and i've got a site running off it.

should be able to get to the point of seeing what breaks this weekend.

if any postgres gurus read this and want to review the schema and sql with an eye for postgres issues, i'd much appreciate it.

cheers
justin

Anonymous’s picture

Anonymous (not verified) commented
Assigned: » Unassigned
darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented
Status: Active » Fixed
k4ml’s picture

k4ml commented

hi, I checkout chatroom from cvs (cvs -z6 -d:pserver:anonymous:anonymous@cvs.drupal.org:/cvs/drupal-contrib co contributions/modules/chatroom) but can't find any postgresql schema in .install. I know it's trivial to port the mysql schema to postgres (already done it actually) but I would like to see your work and make sure we're in sync.

darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented
Status: Fixed » Active

I was mistaken about this being fixed. No work on postgresql has be contributed yet. k4ml, could you post your code for us to test?

k4ml’s picture

k4ml commented
StatusFileSize
new chatroom.install7.75 KB

can't get the code properly formatted here, so I attached the full file.

to be honest, I still can't get chatroom working but I would reserve that for another issue.

darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented
Status: Active » Fixed
StatusFileSize
new chatroom.install_0.patch2.77 KB

Thanks. Committed to DRUPAL-4-7 and HEAD.

k4ml’s picture

k4ml commented
StatusFileSize
new chatroom.install_1.patch.txt2.77 KB

there's serious bug in the patch where the primary key of table chatroom_msg_archive, chatroom_ban_list, chatroom_online_list, chatroom_chat_invites not set to SERIAL (postgresql equiv. of AUTO_INCREMENT). sorry, it's my fault. attach the fixed patch.

darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented

Kamal, I would like to add you to the developers list for the Chatroom project, but first I need a way to contact you directly. Please e-mail me or set your Drupal account to accept e-mail.

darren oh’s picture

darren oh
Primary language English
Location Lakeland, Florida
commented

Committed to DRUPAL-4-7 and HEAD.

Anonymous’s picture

(not verified) commented
Status: Fixed » Closed (fixed)