Received: from localhost (maia-5.hub.org [200.46.204.182])
	by postgresql.org (Postfix) with ESMTP id B97179FA110
	for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 31 Jul 2007 10:07:09 -0300 (ADT)
Received: from postgresql.org ([200.46.204.71])
	by localhost (mx1.hub.org [200.46.204.182]) (amavisd-maia, port 10024)
	with ESMTP id 80932-05 for <pgsql-sql-postgresql.org@postgresql.org>;
	Tue, 31 Jul 2007 10:07:01 -0300 (ADT)
X-Greylist: from auto-whitelisted by SQLgrey-1.7.5
Received: from smtp2.yandex.ru (smtp2.yandex.ru [213.180.200.18])
	by postgresql.org (Postfix) with ESMTP id B40459FA1BF
	for <pgsql-sql@postgresql.org>; Tue, 31 Jul 2007 10:07:05 -0300 (ADT)
Received: from dial-up.82.209.218.6.grodno.by ([82.209.218.6]:13045 "EHLO
	asu2.mshome.net" smtp-auth: "sql4-en" TLS-CIPHER: <none> TLS-PEER-CN1:
	<none>) by mail.yandex.ru with ESMTP id S4395501AbXGaNG4 (ORCPT
	<rfc822;pgsql-sql@postgresql.org>); Tue, 31 Jul 2007 17:06:56 +0400
X-Comment: RFC 2476 MSA function at smtp2.yandex.ru logged sender identity as:
	sql4-en
Date: Tue, 31 Jul 2007 16:08:23 +0300
From: Dmitry Turin <sql4-en@narod.ru>
X-Mailer: The Bat! (v3.85.03) Professional
Reply-To: Dmitry Turin <sql4-en@narod.ru>
X-Priority: 3 (Normal)
Message-ID: <125615350.20070731160823@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: calling webservice through postgresql function
In-Reply-To: <467967778.20070727094013@narod.ru>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
	<414476065.20070716161857@narod.ru>
	<002e01c7c831$f2b61380$d8223a80$@com>
	<467967778.20070727094013@narod.ru>
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Virus-Scanned: Maia Mailguard 1.0.1
X-Spam-Status: No, hits=2.185 tagged_above=0 required=5 tests=AWL=-0.958,
	BAYES_50=0.001, RCVD_IN_NJABL_PROXY=1.643, URIBL_SBL=1.499
X-Spam-Level: **
X-Archive-Number: 200707/196
X-Sequence-Number: 28931

Good day, Jyoti.

JS>> (e.g. pl/perlu).
DT>   __You as man (by hands) install connect__ between DBMS and external world
DT> by procedural language once again.
DT> You are wrong once again:
DT> advantage is to __refuse__ from procedural language (to install connect)
DT> instead of put it from outside of DBMS into inside of DBMS.
DT> All, which is necessary, is DBMS itself listen some port/protocol.

My version:

(1.1)
User send to remote database (HTTP will ask login):
c:/dir>  xml2http.exe database.my.com username password a.xml
for example
c:/dir>  dbf2xml.exe a.dbf | xml2http.exe database.my.com username password

(1.2)
User send to local database (at transformation data between DBMS-s):
c:/dir>  xml2http.exe 127.0.0.1 username password a.xml
for example
c:/dir>  dbf2xml.exe a.dbf | xml2http.exe 127.0.0.1 username password

(2.1)
Database send to local file (at transformation data between DBMS-s):
pg>      copy a.b.c to filename.xml;

(2.2)
Database send to remote database
(if 'sys.username' and 'sys.password' are equal null,
then database sends as anonymous):
pg>      update sys set
pg>        ral="database.remote.com",
pg>        username=
pg>        password= ;
pg>      a.b.c ->;
or
pg>      update sys set
pg>        ran="101.102.103.104",
pg>        username=
pg>        password= ;
pg>      a.b.c ->;
or if you prefer to export per table
pg>      update sys set ral="database.remote.com";
pg>      create view av as select * from a where ...
pg>      create view bv as select * from b where ...
pg>      create view cv as select * from c where ...
pg>      av ->;
pg>      bv ->;
pg>      cv ->;


Once again: users need simple instruments, instead of your (in you link)
JS>>    CREATE OR REPLACE FUNCTION
JS>>    use DBI;
JS>>    my $dbh = DBI->connect('dbi:mysql:'.$_[0],$_[1],$_[2],
JS>>       { RaiseError => 1, AutoCommit = > });

Do you understand me ?


Dmitry Turin
SQL4      (4.1.3)  http://sql40.chat.ru
HTML6     (6.3.0)  http://html6.by.ru
Unicode2  (2.0.1)  http://unicode2.chat.ru
Computer2 (2.0.3)  http://computer20.chat.ru