Postgres support

Yes, I do plan on making postgres support. Expect a patch rollout to update the module to support postgres in the next few days.

I want to stabalize the main code base before implmeneting postgres. i will get to is asap though.

Hello. I just wanted to open this up. If anyone wants to write the install file for postgres, I shall start to add/implement postgres support.

I manage to generate the tables with this:

CREATE TABLE pontomail_servers (
sid SERIAL PRIMARY KEY,
server_name varchar(200) default NULL,
server_port int default NULL,
server_type varchar(10) default NULL,
uid int NOT NULL default '0',
server_address varchar(50) default NULL,
"user" varchar(40) default NULL,
password varchar(20) default NULL,
enabled int default '1',
secure int default '0',
con_ssl char(1) default '0',
no_tls char(1) default '1',
validate_cert char(1) default '0',
archive_sent_mail int NOT NULL default 0,
save_remote_copy int NOT NULL default 0,
save_remote_copy_folder varchar(255)
);

CREATE TABLE pontomail_pager_holder (
id varchar(18) default NULL,
uid int default NULL
);

CREATE TABLE pontomail_sendmail_groups (
cid int NOT NULL default '0',
category varchar(255) NOT NULL default '',
recipients text NOT NULL,
reply text NOT NULL,
weight smallint NOT NULL default '0',
selected smallint NOT NULL default '0'
);

Mind you, my Postgres knowledge is fairly basic.

Jac

Could someone place this in a patch? I'm an drupalcon, and I will patch it immediatley, I just don't want to do it right now. I know, it's simple, but doing tons of things right now. Thanks. :)

Or still better, maybe you could make it database independent (from http://drupal.org/node/87073 :-)):

http://drupal.org/node/1395

Jac

Jac,

Good point. Here I am preaching about "dirty sql" statements, and patching Oracle, and I have my own ditry laundary. :).
I'll rewrite some sql statements and update the DDL and re-roll. Sheesh, I feel awful, my own hipocrite. Sorry guys. I'll re-roll and patch soon.

- Souvent22

I've been working with PostgreSQL on my site and have pontomail working but not thorouhgly tested.

The biggest challenge I bumped into that I'd like to suggest should be handled through a change in code is with the pontomail_servers table design.

This table contains a field called 'user' which is a challenge because 'user' is a reserved word in Postgres. It would be useful if we could change this to usernm or some similar alternative.

Other than that, I have a ponotmail.pgsql file written and would be happy to overhaul the install script if necessary.