[Vtigercrm-developers] postgres support in v5

[Allan Bush]

I'd love to support MsSQL as well, unfortunately I don't have a MsSQL
test environment which make it pretty impractical for me to make the
required changes.

Have you tried checking out the latest code from the 4.2 branch to see
how it works on MsSQL?  I'd be interested to know how it works out for
you, I anticipate you'll have a few rough spots where I made some ugly
hacks based on the database being Postgres.

The ON DELETE CASCADEs work really well in Postgres actually (not that
anything really ever gets deleted via the web interface).  Do you have
an example of a loop so I can test that part out?

Let me know of the issues you have and I'll try and incorporate them
into the Postgres changeset.

Allan

On 5/4/06, Michel JACQUEMES <m.jacquemes at neuf.fr> wrote:
> I don't want to give you more work on Postgres support but maybe you
> remember I have done some work on MsSQL few time ago. I found that most of
> the efforts you have done normalizing queries were compatible with MsSQL.
>
> I have already made V5 work on this database but my code is not clean enough
> to contribute. What I would be interested is to follow your work and, if you
> agree, eventually make suggestions to have more portable queries.
>
> There is unfortunately a prerequisite for MsSQL about database schema. MsSql
> needs that all foreign key constraints ON DELETE CASCADE be replaced by ON
> DELETE NO ACTION. I have tested this change and it doesn't affect vtiger. I
> have already posted some lmails about that but never had feedback.
> This clause is actually silly because there are loops in vtiger database
> schema and I don't know how will react Postgres if it is activated.
>
> I do think that if we could have MsSQL support at the same time it will be a
> plus for vtiger.
>
> Michel
>
> _______________________________________________
> This vtiger.com email is sponsored by Zoho Planner. Still scribbling down your To-Do's on bits of paper & palms of your hands? Try the AJAX enabled, personal organizer online, Zoho Planner for FREE instead! http://zohoplanner.com/?vt
>