From: | Travis Bauer <trbauer(at)indiana(dot)edu> |
---|---|
To: | Hitesh Patel <hitesh(at)presys(dot)com> |
Cc: | pgsql-general(at)postgresql(dot)org |
Subject: | Re: PL/Perl Question |
Date: | 2001-04-20 15:59:09 |
Message-ID: | 20010420105909.A8132@ghost.cs.indiana.edu |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
I think this is problematic with the default compilation fo PL/Perl.
The perl interpretor you get in a plperl function is inside of a
"sandbox" (can't remember the official name) where it is limited
to only a relatively small set of functions. I don't think that
SQL commands are included.
--
----------------------------------------------------------------
Travis Bauer | CS Grad Student | IU |www.cs.indiana.edu/~trbauer
----------------------------------------------------------------
Hitesh Patel (hitesh(at)presys(dot)com) wrote:
> I need to be able to execute SQL commands from inside a plperl function and
> can't figure if I can do this. Also.. after executing the query I need to be
> able to grab the number of tuples returned and there values.. how would I go
> about doing this.. any help would be appreciated.
>
> --
> Hitesh Patel
> hitesh(at)presys(dot)com
>
> ---------------------------(end of broadcast)---------------------------
> TIP 5: Have you checked our extensive FAQ?
>
> http://www.postgresql.org/users-lounge/docs/faq.html
From | Date | Subject | |
---|---|---|---|
Next Message | Steve Wolfe | 2001-04-20 16:10:56 | Re: Delete w/ regexp |
Previous Message | Patrick LOGE | 2001-04-20 15:55:04 | Websphere on linux with PostgreSQL |