Quoting A James Lewis <[EMAIL PROTECTED]>:
>
> Before I go investigating this, is it possible to trigger an arbitrary
> program from the SQL, say a shell script?
In theory yes, but I'd suspect not a good idea.
Even more so with java, as the JVM's startup time is pretty big. Having it talk
to
Before I go investigating this, is it possible to trigger an arbitrary
program from the SQL, say a shell script?
Also, why am I getting "not subscribed messages", I am subscribed since
I'm replying to a message that was sent to me!!
On Thu, 29 Mar 2001, Peter Mount wrote:
> At 21:37 26/03/01 +
Tom Lane writes:
> I'm generally pretty suspicious of any system design that requires
> calling outside programs from an SQL function. The problem is that
> this fundamentally breaks transactional semantics: if the transaction
> is rolled back after the function call, its effects inside the data
Peter Eisentraut <[EMAIL PROTECTED]> writes:
> A James Lewis writes:
>> Before I go investigating this, is it possible to trigger an arbitrary
>> program from the SQL, say a shell script?
> At the lowest level, you can generally do anything a C program can do.
> Writing the equivalent of system()
A James Lewis writes:
> Before I go investigating this, is it possible to trigger an arbitrary
> program from the SQL, say a shell script?
At the lowest level, you can generally do anything a C program can do.
Writing the equivalent of system() in SQL should be rather trivial.
You can also take
Peter Mount wrote:
>
> At 10:33 26/03/01 +0200, Mathijs Brands wrote:
>
> >Has anybody ever tried calling Java code from a pgsql trigger written
> >in C? Shouldn't this be possible using JNI?
>
> This was discussed recently.
>
> >I'm not exactly a Java expert myself, but this is the way PHP al
On Thu, Mar 29, 2001 at 10:10:44AM +0100, Peter Mount allegedly wrote:
> At 21:37 26/03/01 +0200, Mathijs Brands wrote:
> >On Mon, Mar 26, 2001 at 07:00:43PM +0200, Peter Eisentraut allegedly wrote:
> > > Mathijs Brands writes:
> > >
> > > > Has anybody ever tried calling Java code from a pgsql tr
At 21:37 26/03/01 +0200, Mathijs Brands wrote:
>On Mon, Mar 26, 2001 at 07:00:43PM +0200, Peter Eisentraut allegedly wrote:
> > Mathijs Brands writes:
> >
> > > Has anybody ever tried calling Java code from a pgsql trigger written
> > > in C? Shouldn't this be possible using JNI?
> >
> > I have, a
At 10:33 26/03/01 +0200, Mathijs Brands wrote:
>Has anybody ever tried calling Java code from a pgsql trigger written
>in C? Shouldn't this be possible using JNI?
This was discussed recently.
>I'm not exactly a Java expert myself, but this is the way PHP allows
>you to call Java code from your
On Mon, Mar 26, 2001 at 07:00:43PM +0200, Peter Eisentraut allegedly wrote:
> Mathijs Brands writes:
>
> > Has anybody ever tried calling Java code from a pgsql trigger written
> > in C? Shouldn't this be possible using JNI?
>
> I have, and given the current Java implementations it's a desaster.
Mathijs Brands writes:
> Has anybody ever tried calling Java code from a pgsql trigger written
> in C? Shouldn't this be possible using JNI?
I have, and given the current Java implementations it's a desaster.
--
Peter Eisentraut [EMAIL PROTECTED] http://yi.org/peter-e/
---
On Mon, Mar 26, 2001 at 09:53:52AM +0200, Poul L. Christiansen allegedly wrote:
> Log into PostgreSQL using psql and run the help command:
> "\h create trigger".
>
> See also:
> http://www.postgresql.org/users-lounge/docs/6.5/postgres/sql-createtrigger.htm
>
> HTH,
> Poul L. Christiansen
>
> On
Log into PostgreSQL using psql and run the help command:
"\h create trigger".
See also:
http://www.postgresql.org/users-lounge/docs/6.5/postgres/sql-createtrigger.htm
HTH,
Poul L. Christiansen
On Sun, 25 Mar 2001, [iso-8859-1] Mohamed ebrahim wrote:
> Hi
> I am an user of postgresql. I wan
13 matches
Mail list logo
