[Vtigercrm-developers] postgres support in v5

[Michel JACQUEMES]

Hi Allan,

I know it works because vtiger never use this feature. I have never tested
it directly and don't know what are doing MySql or Postgres. Anyway I don't
think it is a good practice. Code has to master record deletion, know if
there are depending records and so on.

You will find joined a loop sample but there are several others. The problem
with MsSQL is that it makes its control at constraint creation. If you leave
the schema as it is you loose all the constraints.

I have submitted a ticket, Mike has scheduled it for rc5.
http://vtiger.fosslabs.com/cgi-bin/trac.cgi/ticket/53

I will test Postgres branch soon.

Michel

> -----Message d'origine-----
> De : vtigercrm-developers-bounces at lists.vtigercrm.com [mailto:vtigercrm-
> developers-bounces at lists.vtigercrm.com] De la part de Allan Bush
> Envoyé : jeudi 4 mai 2006 17:59
> À : vtigercrm-developers at lists.vtigercrm.com
> Objet : Re: [Vtigercrm-developers] postgres support in v5
> 
> 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
-------------- next part --------------
A non-text attachment was scrubbed...
Name: SchemaCRMEntity.jpg
Type: image/jpeg
Size: 56957 bytes
Desc: not available
Url : http://lists.vtigercrm.com/pipermail/vtigercrm-developers/attachments/20060505/e4a8ed5e/attachment-0003.jpg