From: Dmitry Turin <sql4-en@narod.ru>
To: pgsql-sql@postgresql.org
Subject: Re: calling webservice through postgresql function
Date: Fri, 27 Jul 2007 09:40:13 +0300
Message-ID: <467967778.20070727094013@narod.ru> (raw)
In-Reply-To: <002e01c7c831$f2b61380$d8223a80$@com>
References: <00b101c7c51d$7754fb50$65fef1f0$@com>
<414476065.20070716161857@narod.ru>
<002e01c7c831$f2b61380$d8223a80$@com>
Good day, Jyoti.
JS> we can use any of the "untrusted" procedural languages
JS> http://www.pgsql.cz/index.php/PL/Perlu_-_Untrusted_Perl_(en)
What !! There is no need to have
CREATE OR REPLACE FUNCTION
open FILE, $_[0]; my @cntn = ();
while (<FILE>) { }
__You as man (by hands) convert__ tree of data into database tables
by procedural language once again.
You are wrong: all, which is necessary, is to have __a.b.c__ in language for
JS> create table a (
JS> id num primary key,
JS> data float
JS> );
JS> create table b (
JS> id num primary key,
JS> ref num references a(id),
JS> data float
JS> );
JS> create table c (
JS> id num primary key,
JS> link num references b(id),
JS> data float
JS> );
JS> to access resources outside the database
JS> (e.g. pl/perlu).
There is no need to have
CREATE OR REPLACE FUNCTION
use DBI;
my $dbh = DBI->connect('dbi:mysql:'.$_[0],$_[1],$_[2],
{ RaiseError => 1, AutoCommit = > });
__You as man (by hands) install connect__ between DBMS and external world
by procedural language once again.
You are wrong once again:
advantage is to __refuse__ from procedural language (to install connect)
instead of put it from outside of DBMS into inside of DBMS.
All, which is necessary, is DBMS itself listen some port/protocol.
Dmitry Turin
SQL4 (4.1.3) http://sql40.chat.ru
HTML6 (6.3.0) http://html6.by.ru
Unicode2 (2.0.0) 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: <467967778.20070727094013@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