Re: [HACKERS] PL contribution guidelines?

2003-09-28 Thread Shridhar Daithankar
On Sunday 28 September 2003 11:53, mlg7 wrote:
> >On Saturday 27 September 2003 19:46, Peter Eisentraut wrote:
> >> mlg7 writes:
> >> > Is there a centralized list of pgsql PL's ?
> >>
> >> I'm not aware of one.
> >
> >http://techdocs.postgresql.org/guides/PLLanguages
> >
> >Josh posted it on advocacy few days back.
> >
> > Shridhar
>
> That does not work:
> : Proxy Error
> : The proxy server received an invalid response from an upstream server.
> :
> : The proxy server could not handle the request GET /guides/PLLanguages.
> :
> : Reason: Could not connect to remote machine: Operation timed out

Try google cache

http://www.google.co.in/search?q=cache:iDjd8nA-l2IJ:techdocs.postgresql.org/guides/PLLanguages+list+of+postgresql+procedural+languages&hl=mr&ie=UTF-8

The google search term I used was "list of postgresql procedural languages". 
Look for first techdocs link.

Yesterday when I got same error, I thought there was problem with 
international link again...:-) Hard to tell where exactly problem is..

 Shridhar


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


Re: [HACKERS] PL contribution guidelines?

2003-09-27 Thread mlg7
>On Saturday 27 September 2003 19:46, Peter Eisentraut wrote:
>> mlg7 writes:
>> > Is there a centralized list of pgsql PL's ?
>>
>> I'm not aware of one.
>
>http://techdocs.postgresql.org/guides/PLLanguages
>
>Josh posted it on advocacy few days back.
>
> Shridhar
>

That does not work:

: Proxy Error
: The proxy server received an invalid response from an upstream server.
:
: The proxy server could not handle the request GET /guides/PLLanguages.
:
: Reason: Could not connect to remote machine: Operation timed out


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [HACKERS] PL contribution guidelines?

2003-09-27 Thread Shridhar Daithankar
On Saturday 27 September 2003 19:46, Peter Eisentraut wrote:
> mlg7 writes:
> > Is there a centralized list of pgsql PL's ?
>
> I'm not aware of one.

http://techdocs.postgresql.org/guides/PLLanguages

Josh posted it on advocacy few days back.

 Shridhar


---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [HACKERS] PL contribution guidelines?

2003-09-27 Thread Peter Eisentraut
mlg7 writes:

> Is there a centralized list of pgsql PL's ?

I'm not aware of one.

> At that URL, I see:
> pgplsh-1.0-7.3.tar.gz   17-Dec-2002 19:17   244k  GZIP compressed docume>
> pgplsh-20010821.tar.gz  23-Sep-2002 18:0899k  GZIP compressed docume>
> pgplsh-20010914.tar.gz  23-Sep-2002 18:08   101k  GZIP compressed docume>
> pgplsh-20011005.tar.gz  23-Sep-2002 18:08   102k  GZIP compressed docume>
> which version should I prefer? What is the difference between them?

They are different historical versions.  Use the newest one.

-- 
Peter Eisentraut   [EMAIL PROTECTED]


---(end of broadcast)---
TIP 2: you can get off all lists at once with the unregister command
(send "unregister YourEmailAddressHere" to [EMAIL PROTECTED])


Re: [HACKERS] PL contribution guidelines?

2003-09-27 Thread mlg7
Peter Eisentraut wrote:
> 
> mlg3 writes:
> 
> > I understand that pgsql uses autoconf but not other autotools.
> > The best location for such contribution is in
> > src/pl/pl
> >
> > Now, how do I include my PL into the build list?
> > What files must I provide? (preferrably, by borrowing
> > them from another PL, e.g. PLPERL or TCL])
> 
> There is currently some disagreement about whether every now procedural
> language implementation should be included in the core distribution.  If
> you choose to distribute your package separately, you can take a look at
> http://developer.postgresql.org/~petere/plsh.html as an example for how to
> package it.

1)
Is there a centralized list of pgsql PL's ?

2)
At that URL, I see:
pgplsh-1.0-7.3.tar.gz   17-Dec-2002 19:17   244k  GZIP compressed docume>
pgplsh-20010821.tar.gz  23-Sep-2002 18:0899k  GZIP compressed docume>
pgplsh-20010914.tar.gz  23-Sep-2002 18:08   101k  GZIP compressed docume>
pgplsh-20011005.tar.gz  23-Sep-2002 18:08   102k  GZIP compressed docume>
which version should I prefer? What is the difference between them?

---(end of broadcast)---
TIP 3: if posting/reading through Usenet, please send an appropriate
  subscribe-nomail command to [EMAIL PROTECTED] so that your
  message can get through to the mailing list cleanly


Re: [HACKERS] PL contribution guidelines?

2003-09-25 Thread Robert Treat
On Thu, 2003-09-25 at 13:26, Bruce Momjian wrote:
> scott.marlowe wrote:
> > On 25 Sep 2003, Robert Treat wrote:
> > 
> > > oh.. and i'm not forgetting plphp, but it has both licensing issues and
> > > isn't ready for prime time.
> > 
> > I thought there weren't any license issues, except mayhaps with the name.
> > 
> > http://www.php.net/license/3_0.txt
> 
> That is what I thought too.  Originally PlPHP was stated as being
> released as GPL (which the author thought was used by PHP), but later
> corrected to be the BSD license.
> 

The naming issue was the one that had stuck in my head. 

(Noting that it isn't BSD licensed, it's PHP licensed, which might be a
problem for some, but seems fairly BSD compatible).  

Robert Treat
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [HACKERS] PL contribution guidelines?

2003-09-25 Thread Joshua D. Drake
Hello,

 Yes plPHP is under the BSD style PHP license. We are going to dual 
license on next release which is REAL soon
now.

Sincerley,

Joshua Drake

Bruce Momjian wrote:

scott.marlowe wrote:
 

On 25 Sep 2003, Robert Treat wrote:

   

oh.. and i'm not forgetting plphp, but it has both licensing issues and
isn't ready for prime time.
 

I thought there weren't any license issues, except mayhaps with the name.

http://www.php.net/license/3_0.txt
   

That is what I thought too.  Originally PlPHP was stated as being
released as GPL (which the author thought was used by PHP), but later
corrected to be the BSD license.
 



---(end of broadcast)---
TIP 6: Have you searched our list archives?
  http://archives.postgresql.org


Re: [HACKERS] PL contribution guidelines?

2003-09-25 Thread Bruce Momjian
scott.marlowe wrote:
> On 25 Sep 2003, Robert Treat wrote:
> 
> > oh.. and i'm not forgetting plphp, but it has both licensing issues and
> > isn't ready for prime time.
> 
> I thought there weren't any license issues, except mayhaps with the name.
> 
> http://www.php.net/license/3_0.txt

That is what I thought too.  Originally PlPHP was stated as being
released as GPL (which the author thought was used by PHP), but later
corrected to be the BSD license.

-- 
  Bruce Momjian|  http://candle.pha.pa.us
  [EMAIL PROTECTED]   |  (610) 359-1001
  +  If your life is a hard drive, |  13 Roberts Road
  +  Christ can be your backup.|  Newtown Square, Pennsylvania 19073

---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [HACKERS] PL contribution guidelines?

2003-09-25 Thread scott.marlowe
On 25 Sep 2003, Robert Treat wrote:

> oh.. and i'm not forgetting plphp, but it has both licensing issues and
> isn't ready for prime time.

I thought there weren't any license issues, except mayhaps with the name.

http://www.php.net/license/3_0.txt


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [HACKERS] PL contribution guidelines?

2003-09-25 Thread Robert Treat
On Thu, 2003-09-25 at 07:12, Peter Eisentraut wrote:
> mlg3 writes:
> > Now, how do I include my PL into the build list?
> > What files must I provide? (preferrably, by borrowing
> > them from another PL, e.g. PLPERL or TCL])
> 
> There is currently some disagreement about whether every now procedural
> language implementation should be included in the core distribution.  If
> you choose to distribute your package separately, you can take a look at
> http://developer.postgresql.org/~petere/plsh.html as an example for how to
> package it.
> 

Is there? The last new procedural language that I recall was Joe's plr,
which IIRC was moved to gborg due to license issues with the R
libraries. darn gpl license..if only it was commercially dual
licensed

otherwise my understanding is that all of the other pl authors that
distribute outside of core do so either by their own choosing or because
the proposed implementation is not quite "ready for prime time" enough
to be included.

oh.. and i'm not forgetting plphp, but it has both licensing issues and
isn't ready for prime time.

Robert Treat 
-- 
Build A Brighter Lamp :: Linux Apache {middleware} PostgreSQL


---(end of broadcast)---
TIP 9: the planner will ignore your desire to choose an index scan if your
  joining column's datatypes do not match


Re: [HACKERS] PL contribution guidelines?

2003-09-25 Thread Peter Eisentraut
mlg3 writes:

> I understand that pgsql uses autoconf but not other autotools.
> The best location for such contribution is in
> src/pl/pl
>
> Now, how do I include my PL into the build list?
> What files must I provide? (preferrably, by borrowing
> them from another PL, e.g. PLPERL or TCL])

There is currently some disagreement about whether every now procedural
language implementation should be included in the core distribution.  If
you choose to distribute your package separately, you can take a look at
http://developer.postgresql.org/~petere/plsh.html as an example for how to
package it.

> I also composed PLSAMPLE (the same implementation
> components, but empty). IMO, it (PLSAMPLE) also should be
> there in the PSQL distribution.

I think there is enough documentation about this already.  Creating a PL
handler is not a common task.  But if you have concrete points that you
would like to have mentioned somewhere, please tell us about them.

-- 
Peter Eisentraut   [EMAIL PROTECTED]


---(end of broadcast)---
TIP 1: subscribe and unsubscribe commands go to [EMAIL PROTECTED]


[HACKERS] PL contribution guidelines?

2003-09-25 Thread mlg3
I want to make a contribution.
It is a new (to pgsql) procedural language.
Currently it already works (but debugging output 
is not disabled yet).

I've got some questions and considerations, please, correct me
if I am wrong:

I understand that pgsql uses autoconf but not other autotools.
The best location for such contribution is in
src/pl/pl

Now, how do I include my PL into the build list?
What files must I provide? (preferrably, by borrowing
them from another PL, e.g. PLPERL or TCL])

Currently, I compile the C source by hands:
cc -fpic -I /pgsql/src/include -c plpfe.c
cc -shared -Wl,--rpath -Wl,/usr/local/lib -Wl,--rpath -Wl,
/usr/local/lib/pfe -o plpfe.so plpfe.o -lpfe

One part of the implementation resides in the pfe build tree,
but it needs postgres.h and fmgr.h

Currently I use
#include "/pgsql/src/include/postgres.h"
#include "/pgsql/src/include/fmgr.h"
(/pgsql is a symlink to the PostgreSQL*.*.* directory)
but IMO there should be a better way.

Should I publish the project as plpfe.sf.net, or there's
a better location?

I also composed PLSAMPLE (the same implementation
components, but empty). IMO, it (PLSAMPLE) also should be 
there in the PSQL distribution.


regards, mlg

---(end of broadcast)---
TIP 8: explain analyze is your friend