Re: Creating functions and triggers

From: nolan(at)celery(dot)tssi(dot)com
To: bruno(at)wolff(dot)to (Bruno Wolff III)
Cc: netadmin(at)vcsn(dot)com (Network Administrator), pgsql-general(at)postgresql(dot)org
Subject: Re: Creating functions and triggers
Date: 2003-05-13 21:22:56
Message-ID: 20030513212256.14984.qmail@celery.tssi.com
Views: Raw Message | Whole Thread | Download mbox | Resend email
Thread:
Lists: pgsql-general

> > The initial reason for my post is that I [thought] I saw some talk about writing
> > files as using PL/Perl instead of PL/Sh and I thought PL/Perl did not allow
> > regular users to write files to the file system, no?
>
> I haven't played with PL/Perl myself, but I do believe that there are
> both trusted and untrusted versions of that. Presumably the untrusted
> one would have full access to perl and be able to write to files.

I haven't done file I/O, but I have written a function in plperlu
which connects to another pgsql database, so I think you can probably
do just about anything you want in the untrusted version.

Looking at the replication project(s) is still on my 'to do' list, but
I figure if I have to I can write trigger procedures to implement
master/slave databases.
--
Mike Nolan

In response to

Browse pgsql-general by date

  From Date Subject
Next Message alex b. 2003-05-13 21:50:17 VARCHAR to TIME
Previous Message Stephan Szabo 2003-05-13 20:57:24 Re: Relation "pg_relcheck" does not exist