pg.ddx.io pgsql-sql@postgresql.org mailing list archive
help / color / mirror / Atom feedPL/Perl?
11+ messages / 8 participants
[nested] [flat]
* PL/Perl?
@ 1999-02-24 17:03 Dr. Nisai Wanakule <nisai@m1p17-235.waterauthority.state.fl.us>
0 siblings, 1 reply; 11+ messages in thread
From: Dr. Nisai Wanakule @ 1999-02-24 17:03 UTC (permalink / raw)
To: pgsql-sql
Is there such thing as PL for Perl?
If there is, please direct me to the pertinent document.
If not, is there a plan in working?
Thanks.
--
Nisai Wanakule, PH.D., P.E.
Tampa Bay Water
2535 Landmark Dr., Suite 211
Clearwater, FL 33761
Tel 727/791-2373
Fax 727/791-2388
SunCom: 513-7010
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: [SQL] PL/Perl?
@ 1999-02-25 08:25 Victor M. Mondragon A. <mdragon@vera.net>
parent: Dr. Nisai Wanakule <nisai@m1p17-235.waterauthority.state.fl.us>
0 siblings, 0 replies; 11+ messages in thread
From: Victor M. Mondragon A. @ 1999-02-25 08:25 UTC (permalink / raw)
To: Dr. Nisai Wanakule <nisai@m1p17-235.waterauthority.state.fl.us>; +Cc: pgsql-sql
Try DBI and DBD you can fetch them from the CPAN.
# perl -MCPAN -e 'install DBI'
# perl -MCPAN -e 'install DBD::Pg'
---------------------------------------------------------------------------
Victor Manuel Mondragon mdragon@vera.net
---------------------------------------------------------------------------
On Wed, 24 Feb 1999, Dr. Nisai Wanakule wrote:
> Is there such thing as PL for Perl?
> If there is, please direct me to the pertinent document.
> If not, is there a plan in working?
>
> Thanks.
>
> --
> Nisai Wanakule, PH.D., P.E.
> Tampa Bay Water
> 2535 Landmark Dr., Suite 211
> Clearwater, FL 33761
> Tel 727/791-2373
> Fax 727/791-2388
> SunCom: 513-7010
>
>
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: [SQL] PL/Perl?
@ 1999-02-25 14:16 Dr. Nisai Wanakule <nisai@m1p17-235.waterauthority.state.fl.us>
0 siblings, 0 replies; 11+ messages in thread
From: Dr. Nisai Wanakule @ 1999-02-25 14:16 UTC (permalink / raw)
To: pgsql-sql; +Cc: mdragon@vera.net
I'm currently using DBI/DBD with perl_mod/embperl/Apache.
I try to find a way to generalize the aggregate functions that Pg lack
intead of fetch data and perform the fucntions in Perl-subs.
Thanks.
>Date: Thu, 25 Feb 1999 08:25:04 +0000 ( )
>From: "Victor M. Mondragon A." <mdragon@vera.net>
>To: "Dr. Nisai Wanakule" <nisai@m1p17-235.waterauthority.state.fl.us>
>cc: pgsql-sql@postgreSQL.org
>Subject: Re: [SQL] PL/Perl?
>MIME-Version: 1.0
>
>
>Try DBI and DBD you can fetch them from the CPAN.
>
># perl -MCPAN -e 'install DBI'
># perl -MCPAN -e 'install DBD::Pg'
>
>
>---------------------------------------------------------------------------
>Victor Manuel Mondragon mdragon@vera.net
>---------------------------------------------------------------------------
>
>On Wed, 24 Feb 1999, Dr. Nisai Wanakule wrote:
>
>> Is there such thing as PL for Perl?
>> If there is, please direct me to the pertinent document.
>> If not, is there a plan in working?
>>
>> Thanks.
>>
>> --
>> Nisai Wanakule, PH.D., P.E.
>> Tampa Bay Water
>> 2535 Landmark Dr., Suite 211
>> Clearwater, FL 33761
>> Tel 727/791-2373
>> Fax 727/791-2388
>> SunCom: 513-7010
>>
>>
>>
>
--
Nisai Wanakule, PH.D., P.E.
Tampa Bay Water
2535 Landmark Dr., Suite 211
Clearwater, FL 33761
Tel 727/791-2373
Fax 727/791-2388
SunCom: 513-7010
^ permalink raw reply [nested|flat] 11+ messages in thread
* pl/Perl
@ 2001-02-21 17:39 Jeff MacDonald <jeff@pgsql.com>
0 siblings, 1 reply; 11+ messages in thread
From: Jeff MacDonald @ 2001-02-21 17:39 UTC (permalink / raw)
To: pgsql-sql
Hello
Few questions about pl/perl as the docs on this are very sparse..
(i find that with our procedural language docs in general)
1: can you call other stored procedures from within pl/Perl
2: from within a pl/Perl script , can i do a select etc..
i'm assuming no, because you cannot use DBI.. but just wondering
if there is a way..
3: installing it.. i installed postgres 7.0.3 from ports on my fbsd system.
when i tried to install pl/perl i get this..
cd /usr/ports/databases/postgresql7/work/postgresql-7.0.2/src/pl/plperl/
perl Makefile.pl
make
"../../../src/Makefile.global", line 135: Need an operator
"../../../src/Makefile.global", line 139: Missing dependency operator
"../../../src/Makefile.global", line 143: Need an operator
"../../../src/Makefile.global", line 144: Missing dependency operator
"../../../src/Makefile.global", line 148: Need an operator
"../../../src/Makefile.global", line 149: Need an operator
"../../../src/Makefile.global", line 150: Need an operator
"../../../src/Makefile.port", line 1: Need an operator
"../../../src/Makefile.port", line 3: Need an operator
"../../../src/Makefile.port", line 6: Need an operator
"../../../src/Makefile.port", line 8: Need an operator
"../../../src/Makefile.port", line 16: Need an operator
"../../../src/Makefile.global", line 246: Missing dependency operator
"../../../src/Makefile.global", line 247: Could not find ../../../src/Makefile.custom
"../../../src/Makefile.global", line 248: Need an operator
"../../../src/Makefile.global", line 253: Missing dependency operator
"../../../src/Makefile.global", line 255: Need an operator
"../../../src/Makefile.global", line 284: Missing dependency operator
"../../../src/Makefile.global", line 286: Need an operator
"../../../src/Makefile.global", line 288: Missing dependency operator
"../../../src/Makefile.global", line 290: Need an operator
"../../../src/Makefile.global", line 292: Missing dependency operator
"../../../src/Makefile.global", line 294: Need an operator
"../../../src/Makefile.global", line 296: Need an operator
"../../../src/Makefile.global", line 299: Need an operator
"../../../src/Makefile.global", line 301: Need an operator
"../../../src/Makefile.global", line 304: Need an operator
make: fatal errors encountered -- cannot continue
any tips ?
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick : bignose
PGP Public Key : http://bignose.hub.org/public.txt
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/Perl
@ 2001-02-21 19:19 Alex Pilosov <alex@pilosoft.com>
parent: Jeff MacDonald <jeff@pgsql.com>
0 siblings, 1 reply; 11+ messages in thread
From: Alex Pilosov @ 2001-02-21 19:19 UTC (permalink / raw)
To: Jeff MacDonald <jeff@pgsql.com>; +Cc: pgsql-sql
On Wed, 21 Feb 2001, Jeff MacDonald wrote:
> 1: can you call other stored procedures from within pl/Perl
No.
> 2: from within a pl/Perl script , can i do a select etc..
> i'm assuming no, because you cannot use DBI.. but just wondering
> if there is a way..
Not currently.
> 3: installing it.. i installed postgres 7.0.3 from ports on my fbsd system.
> when i tried to install pl/perl i get this..
>
> cd /usr/ports/databases/postgresql7/work/postgresql-7.0.2/src/pl/plperl/
> perl Makefile.pl
> make
Try using gmake instead of make (cd /usr/ports/devel/gmake, make)
>
> "../../../src/Makefile.global", line 135: Need an operator
> "../../../src/Makefile.global", line 139: Missing dependency operator
> "../../../src/Makefile.global", line 143: Need an operator
> "../../../src/Makefile.global", line 144: Missing dependency operator
> "../../../src/Makefile.global", line 148: Need an operator
> "../../../src/Makefile.global", line 149: Need an operator
> "../../../src/Makefile.global", line 150: Need an operator
> "../../../src/Makefile.port", line 1: Need an operator
> "../../../src/Makefile.port", line 3: Need an operator
> "../../../src/Makefile.port", line 6: Need an operator
> "../../../src/Makefile.port", line 8: Need an operator
> "../../../src/Makefile.port", line 16: Need an operator
> "../../../src/Makefile.global", line 246: Missing dependency operator
> "../../../src/Makefile.global", line 247: Could not find ../../../src/Makefile.custom
> "../../../src/Makefile.global", line 248: Need an operator
> "../../../src/Makefile.global", line 253: Missing dependency operator
> "../../../src/Makefile.global", line 255: Need an operator
> "../../../src/Makefile.global", line 284: Missing dependency operator
> "../../../src/Makefile.global", line 286: Need an operator
> "../../../src/Makefile.global", line 288: Missing dependency operator
> "../../../src/Makefile.global", line 290: Need an operator
> "../../../src/Makefile.global", line 292: Missing dependency operator
> "../../../src/Makefile.global", line 294: Need an operator
> "../../../src/Makefile.global", line 296: Need an operator
> "../../../src/Makefile.global", line 299: Need an operator
> "../../../src/Makefile.global", line 301: Need an operator
> "../../../src/Makefile.global", line 304: Need an operator
> make: fatal errors encountered -- cannot continue
>
> any tips ?
>
> Jeff MacDonald,
>
> -----------------------------------------------------
> PostgreSQL Inc | Hub.Org Networking Services
> jeff@pgsql.com | jeff@hub.org
> www.pgsql.com | www.hub.org
> 1-902-542-0713 | 1-902-542-3657
> -----------------------------------------------------
> Facsimile : 1 902 542 5386
> IRC Nick : bignose
> PGP Public Key : http://bignose.hub.org/public.txt
>
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/Perl
@ 2001-02-21 20:08 Jeff MacDonald <jeff@pgsql.com>
parent: Alex Pilosov <alex@pilosoft.com>
0 siblings, 1 reply; 11+ messages in thread
From: Jeff MacDonald @ 2001-02-21 20:08 UTC (permalink / raw)
To: Alex Pilosov <alex@pilosoft.com>; +Cc: pgsql-sql
> > 1: can you call other stored procedures from within pl/Perl
> No.
darn.
>
> > 2: from within a pl/Perl script , can i do a select etc..
> > i'm assuming no, because you cannot use DBI.. but just wondering
> > if there is a way..
> Not currently.
darn.
> > 3: installing it.. i installed postgres 7.0.3 from ports on my fbsd system.
> > when i tried to install pl/perl i get this..
> >
> > cd /usr/ports/databases/postgresql7/work/postgresql-7.0.2/src/pl/plperl/
> > perl Makefile.pl
> > make
> Try using gmake instead of make (cd /usr/ports/devel/gmake, make)
thanks ! works great.
Jeff MacDonald,
-----------------------------------------------------
PostgreSQL Inc | Hub.Org Networking Services
jeff@pgsql.com | jeff@hub.org
www.pgsql.com | www.hub.org
1-902-542-0713 | 1-902-542-3657
-----------------------------------------------------
Facsimile : 1 902 542 5386
IRC Nick : bignose
PGP Public Key : http://bignose.hub.org/public.txt
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/Perl
@ 2001-02-21 20:38 Jie Liang <jliang@ipinc.com>
parent: Jeff MacDonald <jeff@pgsql.com>
0 siblings, 1 reply; 11+ messages in thread
From: Jie Liang @ 2001-02-21 20:38 UTC (permalink / raw)
To: Jeff MacDonald <jeff@pgsql.com>; +Cc: Alex Pilosov <alex@pilosoft.com>; pgsql-sql
FYI,
My choice:
if involving a lot of regular expressions, pl/Perl is better;
if involving a lot of SQLs or other functions(or store procedures),
then pl/pgsql is better.
Jie LIANG
St. Bernard Software
Internet Products Inc.
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.stbernard.com
www.ipinc.com
On Wed, 21 Feb 2001, Jeff MacDonald wrote:
> > > 1: can you call other stored procedures from within pl/Perl
> > No.
>
> darn.
>
> >
> > > 2: from within a pl/Perl script , can i do a select etc..
> > > i'm assuming no, because you cannot use DBI.. but just wondering
> > > if there is a way..
> > Not currently.
>
> darn.
>
> > > 3: installing it.. i installed postgres 7.0.3 from ports on my fbsd system.
> > > when i tried to install pl/perl i get this..
> > >
> > > cd /usr/ports/databases/postgresql7/work/postgresql-7.0.2/src/pl/plperl/
> > > perl Makefile.pl
> > > make
> > Try using gmake instead of make (cd /usr/ports/devel/gmake, make)
>
> thanks ! works great.
>
>
> Jeff MacDonald,
>
> -----------------------------------------------------
> PostgreSQL Inc | Hub.Org Networking Services
> jeff@pgsql.com | jeff@hub.org
> www.pgsql.com | www.hub.org
> 1-902-542-0713 | 1-902-542-3657
> -----------------------------------------------------
> Facsimile : 1 902 542 5386
> IRC Nick : bignose
> PGP Public Key : http://bignose.hub.org/public.txt
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/Perl
@ 2001-02-21 21:04 Tom Lane <tgl@sss.pgh.pa.us>
parent: Jie Liang <jliang@ipinc.com>
0 siblings, 1 reply; 11+ messages in thread
From: Tom Lane @ 2001-02-21 21:04 UTC (permalink / raw)
To: Jie Liang <jliang@ipinc.com>; +Cc: Jeff MacDonald <jeff@pgsql.com>; Alex Pilosov <alex@pilosoft.com>; pgsql-sql
Jie Liang <jliang@ipinc.com> writes:
> My choice:
> if involving a lot of regular expressions, pl/Perl is better;
> if involving a lot of SQLs or other functions(or store procedures),
> then pl/pgsql is better.
Also consider pltcl, which has pretty nearly perl-equivalent regexp
support, and can do queries too. Besides which it's easier to build/
install than plperl.
It's a shame that plperl doesn't yet have support for making queries.
It hasn't really progressed much past the proof-of-concept stage IMHO,
but no one is working on it :-(
regards, tom lane
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/Perl
@ 2001-03-14 17:04 Jie Liang <jliang@ipinc.com>
parent: Tom Lane <tgl@sss.pgh.pa.us>
0 siblings, 2 replies; 11+ messages in thread
From: Jie Liang @ 2001-03-14 17:04 UTC (permalink / raw)
To: Tom Lane <tgl@sss.pgh.pa.us>; +Cc: pgsql-sql
Tom,
1.Where or how I can get pltcl.so? I have not find this file anywhere in
my
source except a pltcl.c.
2.Dose installation same as plpgsql?
i.e.
CREATE FUNCTION pltcl_call_handler () RETURNS OPAQUE AS
'/usr/local/pgsql/lib/pltcl.so' LANGUAGE 'C';
CREATE TRUSTED PROCEDURAL LANGUAGE 'pltcl'
HANDLER pltcl_call_handler
LANCOMPILER 'PL/pgtcl';
3.Where I can find more doc about pltcl?
Thanks for your time.
Jie LIANG
St. Bernard Software
10350 Science Center Drive
Suite 100, San Diego, CA 92121
Office:(858)320-4873
jliang@ipinc.com
www.stbernard.com
www.ipinc.com
On Wed, 21 Feb 2001, Tom Lane wrote:
> Jie Liang <jliang@ipinc.com> writes:
> > My choice:
> > if involving a lot of regular expressions, pl/Perl is better;
> > if involving a lot of SQLs or other functions(or store procedures),
> > then pl/pgsql is better.
>
> Also consider pltcl, which has pretty nearly perl-equivalent regexp
> support, and can do queries too. Besides which it's easier to build/
> install than plperl.
>
> It's a shame that plperl doesn't yet have support for making queries.
> It hasn't really progressed much past the proof-of-concept stage IMHO,
> but no one is working on it :-(
>
> regards, tom lane
>
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/Perl
@ 2001-03-14 20:57 Richard H <dev@archonet.com>
parent: Jie Liang <jliang@ipinc.com>
1 sibling, 0 replies; 11+ messages in thread
From: Richard H @ 2001-03-14 20:57 UTC (permalink / raw)
To: Jie Liang <jliang@ipinc.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql
On 3/14/01, 5:04:49 PM, Jie Liang <jliang@ipinc.com> wrote regarding Re:
[SQL] pl/Perl :
> Tom,
I'm not the organ grinder, but maybe the monkey can help ;-)
> 1.Where or how I can get pltcl.so? I have not find this file anywhere in
> my
> source except a pltcl.c.
Did you set the relevant parameter with ./configure? Something like
--with-tcl probably --help will give a list of options.
> 2.Dose installation same as plpgsql?
> i.e.
> CREATE FUNCTION pltcl_call_handler () RETURNS OPAQUE AS
> '/usr/local/pgsql/lib/pltcl.so' LANGUAGE 'C';
I just use the "createlang" command-line tool.
> CREATE TRUSTED PROCEDURAL LANGUAGE 'pltcl'
> HANDLER pltcl_call_handler
> LANCOMPILER 'PL/pgtcl';
> 3.Where I can find more doc about pltcl?
There's a bit in the user-manual (developer's version - 7.1 - anyway) on
the website.
Actually - there seems to be a break in the "Next" links in my local copy
of the docs. Is that just me?
Try a google search for tcl/tk - should turn up plenty of general stuff
on the language. I don't use it myself, but it seems great for simple
projects.
- Richard Huxton
> Thanks for your time.
> Jie LIANG
^ permalink raw reply [nested|flat] 11+ messages in thread
* Re: pl/Perl
@ 2001-03-15 21:26 Jan Wieck <JanWieck@Yahoo.com>
parent: Jie Liang <jliang@ipinc.com>
1 sibling, 0 replies; 11+ messages in thread
From: Jan Wieck @ 2001-03-15 21:26 UTC (permalink / raw)
To: Jie Liang <jliang@ipinc.com>; +Cc: Tom Lane <tgl@sss.pgh.pa.us>; pgsql-sql
Jie Liang wrote:
> Tom,
>
> 1.Where or how I can get pltcl.so? I have not find this file anywhere in
> my
> source except a pltcl.c.
> 2.Dose installation same as plpgsql?
> i.e.
> CREATE FUNCTION pltcl_call_handler () RETURNS OPAQUE AS
> '/usr/local/pgsql/lib/pltcl.so' LANGUAGE 'C';
> CREATE TRUSTED PROCEDURAL LANGUAGE 'pltcl'
> HANDLER pltcl_call_handler
> LANCOMPILER 'PL/pgtcl';
No! Please switch to using the createlang shell script.
> 3.Where I can find more doc about pltcl?
Chapter 11 of the PostgreSQL users documentation.
Jan
--
#======================================================================#
# It's easier to get forgiveness for being wrong than for being right. #
# Let's break this rule - forgive me. #
#================================================== JanWieck@Yahoo.com #
_________________________________________________________
Do You Yahoo!?
Get your free @yahoo.com address at http://mail.yahoo.com
^ permalink raw reply [nested|flat] 11+ messages in thread
end of thread, other threads:[~2001-03-15 21:26 UTC | newest]
Thread overview: 11+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
1999-02-24 17:03 PL/Perl? Dr. Nisai Wanakule <nisai@m1p17-235.waterauthority.state.fl.us>
1999-02-25 08:25 ` Victor M. Mondragon A. <mdragon@vera.net>
1999-02-25 14:16 Re: [SQL] PL/Perl? Dr. Nisai Wanakule <nisai@m1p17-235.waterauthority.state.fl.us>
2001-02-21 17:39 pl/Perl Jeff MacDonald <jeff@pgsql.com>
2001-02-21 19:19 ` Re: pl/Perl Alex Pilosov <alex@pilosoft.com>
2001-02-21 20:08 ` Re: pl/Perl Jeff MacDonald <jeff@pgsql.com>
2001-02-21 20:38 ` Re: pl/Perl Jie Liang <jliang@ipinc.com>
2001-02-21 21:04 ` Re: pl/Perl Tom Lane <tgl@sss.pgh.pa.us>
2001-03-14 17:04 ` Re: pl/Perl Jie Liang <jliang@ipinc.com>
2001-03-14 20:57 ` Re: pl/Perl Richard H <dev@archonet.com>
2001-03-15 21:26 ` Re: pl/Perl Jan Wieck <JanWieck@Yahoo.com>
This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox