Received: from localhost (wm.hub.org [200.46.204.128]) by postgresql.org (Postfix) with ESMTP id 244259FB1C0 for ; Sat, 11 Nov 2006 07:22:46 -0400 (AST) Received: from postgresql.org ([200.46.204.71]) by localhost (mx1.hub.org [200.46.204.128]) (amavisd-new, port 10024) with ESMTP id 52669-03 for ; Sat, 11 Nov 2006 11:22:42 +0000 (UTC) X-Greylist: domain auto-whitelisted by SQLgrey- Received: from nz-out-0102.google.com (nz-out-0102.google.com [64.233.162.197]) by postgresql.org (Postfix) with ESMTP id B71C79FB2C6 for ; Sat, 11 Nov 2006 07:22:40 -0400 (AST) Received: by nz-out-0102.google.com with SMTP id i11so443032nzh for ; Sat, 11 Nov 2006 03:22:39 -0800 (PST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:to:subject:mime-version:content-type; b=efRojio0+UjQ/nE/wosKtD0Th9iCpjuTTO/GPgT5CyI/r6ie2W0+l+y7aIT7oO4IjpuAqzrh/BV0H1k67JL0TBY56jCZOyN+Pe7JtOzuWtSzGYutuRGFJWRDytlvXujNk+EvDQZlJVoFlecVC9MOsRo50b0ss/C2TuBgbFgA5DU= Received: by 10.64.3.9 with SMTP id 9mr24105qbc.1163244159660; Sat, 11 Nov 2006 03:22:39 -0800 (PST) Received: by 10.65.249.11 with HTTP; Sat, 11 Nov 2006 03:22:39 -0800 (PST) Message-ID: <7b872b430611110322o22e34fb6ybd50b72c79e98093@mail.gmail.com> Date: Sat, 11 Nov 2006 14:52:39 +0330 From: "Servers24 Network" To: pgsql-php@postgresql.org Subject: Re: PgSQL and integration between 2 PHP programs and a Java program MIME-Version: 1.0 Content-Type: multipart/alternative; boundary="----=_Part_28259_23270118.1163244159623" X-Virus-Scanned: Maia Mailguard 1.0.1 X-Archive-Number: 200611/40 X-Sequence-Number: 3657 ------=_Part_28259_23270118.1163244159623 Content-Type: text/plain; charset=UTF-8; format=flowed Content-Transfer-Encoding: 7bit Content-Disposition: inline Juan, Well in the case of using PgSQL for all my application I will have to rewrite a lot of codes, so I think it's much better to use their native MySQL databases instead. Also it seems to me that DBI-Link can not do what I want, as it seems, it updates ALL the fields of table in remotre database & not just the changed fields. If this is true, it will rewrite some user setting that is specific for an application that was previously updated by the application itself. So this way it will cause a roll back to these settings that user is made in a specific application. Although I'm not sure about this, I will ask it in their mailing list to see if it only updates the fields I want, or all the fields.. Anyhow, after all, I can go ahead with a simple transaction code in Liferay that triggers a series of connections to different MySQL DBs, update special user information tables and then close connections. Also I can use LOCK table method to lock the tables that Liferay is writing to, so that other applications can not write to the same table at that moment & show a "temporary out of service" message to the user. Although this will not occure much, as this incidence is very rare to happen. Also I should ask about a feature in MySQL. Is it possible to LOCK a row in a table in MySQL? I mean for e.g if I lock the table "members" , then no member related functions can be done by ANY of my members. But if for example, I can LOCK the 1st row only that contains the data about my first user, then his account information will be updated and meanwhile others can use the system with no problem. I'm not that familiar with this LOCK method. If anyone can help me and show me how to use it, I will appreciate. -- Warm Regards, Amir ------=_Part_28259_23270118.1163244159623 Content-Type: text/html; charset=UTF-8 Content-Transfer-Encoding: 7bit Content-Disposition: inline
Juan,
 
Well in the case of using PgSQL for all my application I will have to rewrite a lot of codes, so I think it's much better to use their native MySQL databases instead.
Also it seems to me that DBI-Link can not do what I want, as it seems, it updates ALL the fields of table in remotre database & not just the changed fields. If this is true, it will rewrite some user setting that is specific for an application that was previously updated by the application itself. So this way it will cause a roll back to these settings that user is made in a specific application. Although I'm not sure about this, I will ask it in their mailing list to see if it only updates the fields I want, or all the fields..
Anyhow, after all, I can go ahead with a simple transaction code in Liferay that triggers a series of connections to different MySQL DBs, update special user information tables and then close connections. Also I can use LOCK table method to lock the tables that Liferay is writing to, so that other applications can not write to the same table at that moment & show a "temporary out of service" message to the user. Although this will not occure much, as this incidence is very rare to happen.
Also I should ask about a feature in MySQL. Is it possible to LOCK a row in a table in MySQL? I mean for e.g if I lock the table "members" , then no member related functions can be done by ANY of my members. But if for example, I can LOCK the 1st row only that contains the data about my first user, then his account information will be updated and meanwhile others can use the system with no problem.
I'm not that familiar with this LOCK method. If anyone can help me and show me how to use it, I will appreciate.
 
 
 
 
--

Warm Regards,
Amir
------=_Part_28259_23270118.1163244159623--