I have an update statement (no transaction controls surround these
statements):
update sessions set sessdate = 0 where sessid in ( long list of ids);
How long will the rows being updated be locked for this statement? Will all
be locked until all updates are completed or will the row locking only
How can I call a shell script from within a pl/pgsql function that is called
as from a trigger. I do not want to interact with the script I just want it
to run. I do want the trigger to wait for the script it called to complete
before returning a value.
Any ideas would be greatly appreciated.
Th
On Mon, 10 Sep 2001, Jeff Barrett wrote:
> I have an update statement (no transaction controls surround these
> statements):
>
> update sessions set sessdate = 0 where sessid in ( long list of ids);
>
> How long will the rows being updated be locked for this statement? Will all
> be locked unti
On Mon, 10 Sep 2001, Jeff Barrett wrote:
> How can I call a shell script from within a pl/pgsql function that is called
> as from a trigger. I do not want to interact with the script I just want it
> to run. I do want the trigger to wait for the script it called to complete
> before returning a v
* Stephan Szabo <[EMAIL PROTECTED]> [010910 12:37]:
> On Mon, 10 Sep 2001, Jeff Barrett wrote:
>
> > How can I call a shell script from within a pl/pgsql function that is called
> > as from a trigger. I do not want to interact with the script I just want it
> > to run. I do want the trigger to wa
On Mon, 10 Sep 2001, Stephan Szabo wrote:
> On Mon, 10 Sep 2001, Jeff Barrett wrote:
>
> > How can I call a shell script from within a pl/pgsql function that is called
> > as from a trigger. I do not want to interact with the script I just want it
> > to run. I do want the trigger to wait for th
On Mon, 10 Sep 2001, Alex Pilosov wrote:
> On Mon, 10 Sep 2001, Stephan Szabo wrote:
>
> > On Mon, 10 Sep 2001, Jeff Barrett wrote:
> >
> > > How can I call a shell script from within a pl/pgsql function that is called
> > > as from a trigger. I do not want to interact with the script I just w
On Mon, 10 Sep 2001, Stephan Szabo wrote:
>
> On Mon, 10 Sep 2001, Alex Pilosov wrote:
>
> > On Mon, 10 Sep 2001, Stephan Szabo wrote:
> >
> > > On Mon, 10 Sep 2001, Jeff Barrett wrote:
> > >
> > > > How can I call a shell script from within a pl/pgsql function that is called
> > > > as from
Stephan Szabo wrote:
>
> On Mon, 10 Sep 2001, Jeff Barrett wrote:
>
> > How can I call a shell script from within a pl/pgsql function that is called
> > as from a trigger. I do not want to interact with the script I just want it
> > to run. I do want the trigger to wait for the script it called
Thanks for the suggestions.
I am running 7.1.2 and going to 7.1.3 soon.
If I use pl/tclu or pl/perlu I can call this executable from within the
code?
I have a signifigant limitation, I cannot duplicate the action of the
programs I want to call in a program I write within postgres, I need to cal
* Jeff Barrett <[EMAIL PROTECTED]> [010910 14:48]:
> Thanks for the suggestions.
>
> I am running 7.1.2 and going to 7.1.3 soon.
>
> If I use pl/tclu or pl/perlu I can call this executable from within the
> code?
>
> I have a signifigant limitation, I cannot duplicate the action of the
> progra
Alex Pilosov writes:
> Actually, I remember that Jan once mentioned something about pl/SH. I
> don't know what's the status of it?
http://webmail.postgresql.org/~petere/plsh.html
It's a toy project of mine. It's usable, but there are probably some
portability problems.
--
Peter Eisentraut
Could someome explain these error messages to me? Why am I being asked to group by
j.id?
And why is the subquery worried about ml.oid if ml.oid is used in an aggregate?
Follows: script, then output.
select version();
create table j (id int, created timestamp default current_timestamp, fkey
Joseph,
The subject line could describe a lot of what I see outside my house
every day (I live in San Francisco CA).
> Could someome explain these error messages to me? Why am I being
> asked to group by j.id?
Because you've asked the db engine to count on mj.mid. The parser want
you to be s
14 matches
Mail list logo
