From: Dmitry Turin <sql4-en@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: calling webservice through postgresql function
Date: Tue, 31 Jul 2007 16:08:23 +0300
Message-ID: <125615350.20070731160823@narod.ru> (raw)
In-Reply-To: <467967778.20070727094013@narod.ru>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
<414476065.20070716161857@narod.ru>
<002e01c7c831$f2b61380$d8223a80$@com>
<467967778.20070727094013@narod.ru>
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
Reply instructions:
You may reply publicly to this message via plain-text email
using any one of the following methods:
* Reply to all the recipients using the --to and --cc options:
reply via email
To: pgsql-sql@postgresql.org
Cc: sql4-en@narod.ru
Subject: Re: calling webservice through postgresql function
In-Reply-To: <125615350.20070731160823@narod.ru>
* Save the following mbox file, import it into your mail client,
and reply-to-all from there: mbox
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox