Hi!! Is there a way to execute script in OS from plpgsql???
__________________________________________________ _______________
Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org 12 2193
Yes, you can use plsh http://developer.postgresql.org/~petere/plsh.html
regards
Pavel
On Tue, 14 Oct 2003, Edwin Quijada wrote: Hi!! Is there a way to execute script in OS from plpgsql???
__________________________________________________ _______________ Charla con tus amigos en línea mediante MSN Messenger: http://messenger.yupimsn.com/
---------------------------(end of broadcast)--------------------------- TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
---------------------------(end of broadcast)---------------------------
TIP 8: explain analyze is your friend
Edwin Quijada writes: Hi!! Is there a way to execute script in OS from plpgsql???
No, you need to call a function written in an untrusted language, such as
PL/perlu.
--
Peter Eisentraut pe*****@gmx.net
---------------------------(end of broadcast)---------------------------
TIP 7: don't forget to increase your free space map settings
On Tuesday 14 October 2003 16:38, Edwin Quijada wrote: Hi!! Is there a way to execute script in OS from plpgsql???
I think there's a pl/sh procedural language (in contrib or gborg iirc), but
you could probably use any of the untrusted procedural languages.
Better, would be to use the LISTEN/NOTIFY feature to talk to an external
daemon that handles things for you, otherwise your script will run as the
same user as the backend.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
On Tue, 14 Oct 2003, CoL wrote: hi,
Pavel Stehule wrote, On 10/14/2003 5:47 PM: Yes, you can use plsh
http://developer.postgresql.org/~petere/plsh.html
regards Pavel
or plperl, or plphp too :)
I think the new version must run in safe mode, as it installs as a trusted
language, or at least that's the impression I got.
Senior Drake?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
On Tuesday 14 October 2003 17:15, Richard Huxton wrote: On Tuesday 14 October 2003 16:38, Edwin Quijada wrote:
How can I use NOtify to do this?
Please make sure you reply to the list too.
In your daemon you do something like: "LISTEN signal1", and in a trigger (say)
you issue "NOTIFY signal1". Your daemon will receive an asynchronoums message
"signal1" and you can then check the relevant tables for
updates/deletions/whatever signal1 means.
In practice, I usually don't care about responding that quickly, and just have
a cron job start up a script every 5 mins to check a "pending_jobs" table.
--
Richard Huxton
Archonet Ltd
---------------------------(end of broadcast)---------------------------
TIP 4: Don't 'kill -9' the postmaster
Richard Huxton wrote: On Tuesday 14 October 2003 16:38, Edwin Quijada wrote: Hi!! Is there a way to execute script in OS from plpgsql???
I think there's a pl/sh procedural language (in contrib or gborg iirc), but you could probably use any of the untrusted procedural languages.
There is certainly PL/TclU in the core distro.
Jan
--
#================================================= =====================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
On Tue, 14 Oct 2003, CoL wrote: hi,
Pavel Stehule wrote, On 10/14/2003 5:47 PM: Yes, you can use plsh
http://developer.postgresql.org/~petere/plsh.html
regards Pavel
or plperl, or plphp too :)
I think the new version must run in safe mode, as it installs as a trusted
language, or at least that's the impression I got.
Senior Drake?
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Richard Huxton wrote: On Tuesday 14 October 2003 16:38, Edwin Quijada wrote: Hi!! Is there a way to execute script in OS from plpgsql???
I think there's a pl/sh procedural language (in contrib or gborg iirc), but you could probably use any of the untrusted procedural languages.
There is certainly PL/TclU in the core distro.
Jan
--
#================================================= =====================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================= = Ja******@Yahoo.com #
---------------------------(end of broadcast)---------------------------
TIP 5: Have you checked our extensive FAQ? http://www.postgresql.org/docs/faqs/FAQ.html
Hi,
scott.marlowe wrote, On 10/14/2003 9:54 PM: On Tue, 14 Oct 2003, CoL wrote:
hi,
Pavel Stehule wrote, On 10/14/2003 5:47 PM: > Yes, you can use plsh > > http://developer.postgresql.org/~petere/plsh.html > > regards > Pavel
or plperl, or plphp too :)
I think the new version must run in safe mode, as it installs as a trusted language, or at least that's the impression I got.
Senior Drake?
You are right.
C.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org
Hi,
scott.marlowe wrote, On 10/14/2003 9:54 PM: On Tue, 14 Oct 2003, CoL wrote:
hi,
Pavel Stehule wrote, On 10/14/2003 5:47 PM: > Yes, you can use plsh > > http://developer.postgresql.org/~petere/plsh.html > > regards > Pavel
or plperl, or plphp too :)
I think the new version must run in safe mode, as it installs as a trusted language, or at least that's the impression I got.
Senior Drake?
You are right.
C.
---------------------------(end of broadcast)---------------------------
TIP 1: subscribe and unsubscribe commands go to ma*******@postgresql.org This thread has been closed and replies have been disabled. Please start a new discussion. Similar topics
by: Mark Mikulec |
last post by:
Hi there,
I wonder if anyone can shed some light on a very frustrating problem.
I'm running a debian linux 3.0 "woody" server, nothing special, with
the latest version of postres that apt-get...
|
by: Edwin Quijada |
last post by:
Hi!! Is there a way to execute script in OS from plpgsql???
_________________________________________________________________
Charla con tus amigos en línea mediante MSN Messenger:...
|
by: Martin Marques |
last post by:
We are trying to make some things work with plpgsql. The problem is that I
built several functions that call one another, and I thought that the way of
calling it was just making the assign:
...
|
by: Rajesh Kumar Mallah |
last post by:
Hi,
profile_row profile_master%ROWTYPE;
in a plpgsql function
gives the error below
tradein_clients=# SELECT general.create_accounts();
WARNING: plpgsql: ERROR during compile of...
|
by: Steve Wampler |
last post by:
Hmmm, I've always used plpgsql.so (also formerly known
as libplpgsql.so, I think...) as in:
CREATE FUNCTION plpgsql_call_handler () RETURNS language_handler
AS '/usr/lib/plpgsql.so',...
|
by: lnd |
last post by:
After copied pg database from one PC to another
-I could not find plpgsql function(s) in the copied database.
-had to instal plpgsql language handler again
-whilst tables and data moved...
|
by: Bill Moran |
last post by:
I've got a bit of a strange problem that's causing me some MAJOR
headaches.
I'm developing the server-side of a large database application in
PostgreSQL. This consists of a C daemon, and a LOT...
|
by: Karl O. Pinc |
last post by:
Hi,
Thought perhaps some other eyes than mine can tell if I'm doing
something wrong here or if there's a bug somewhere. I've never
passed a ROWTYPE varaible to a function but I don't see where...
|
by: sripathy sena |
last post by:
Hi,
I am trying to install OPenacs with postgres 7.4.3 as
the database.
The openacs requires plpgsql to be installed. When I
try to do this by running "CREATELANG plpgsql
template1". I get a...
|
by: Karl O. Pinc |
last post by:
FYI, mostly. But I do have questions as to how to write code
that will continue to work in subsequent postgresql versions.
See code below.
begintest() uses EXIT to exit a BEGIN block from...
|
by: Charles Arthur |
last post by:
How do i turn on java script on a villaon, callus and itel keypad mobile phone
|
by: emmanuelkatto |
last post by:
Hi All, I am Emmanuel katto from Uganda. I want to ask what challenges you've faced while migrating a website to cloud.
Please let me know.
Thanks!
Emmanuel
|
by: BarryA |
last post by:
What are the essential steps and strategies outlined in the Data Structures and Algorithms (DSA) roadmap for aspiring data scientists? How can individuals effectively utilize this roadmap to progress...
|
by: nemocccc |
last post by:
hello, everyone, I want to develop a software for my android phone for daily needs, any suggestions?
|
by: Hystou |
last post by:
There are some requirements for setting up RAID:
1. The motherboard and BIOS support RAID configuration.
2. The motherboard has 2 or more available SATA protocol SSD/HDD slots (including MSATA, M.2...
|
by: Hystou |
last post by:
Most computers default to English, but sometimes we require a different language, especially when relocating. Forgot to request a specific language before your computer shipped? No problem! You can...
|
by: Oralloy |
last post by:
Hello folks,
I am unable to find appropriate documentation on the type promotion of bit-fields when using the generalised comparison operator "<=>".
The problem is that using the GNU compilers,...
|
by: tracyyun |
last post by:
Dear forum friends,
With the development of smart home technology, a variety of wireless communication protocols have appeared on the market, such as Zigbee, Z-Wave, Wi-Fi, Bluetooth, etc. Each...
|
by: isladogs |
last post by:
The next Access Europe User Group meeting will be on Wednesday 1 May 2024 starting at 18:00 UK time (6PM UTC+1) and finishing by 19:30 (7.30PM).
In this session, we are pleased to welcome a new...
| |