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
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
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
* 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
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
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
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
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, 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
* 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, 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
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
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
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
14 matches
Mail list logo
