Re: [GENERAL] array_agg for 8.3

2009-01-19 Thread Jeff Davis
On Mon, 2009-01-19 at 14:09 -0500, Faheem Mitha wrote: > Yes, I have pg superuser privileges. I *think* this is the same as having > sudo rights for postgres, right? Are you suggesting adding another entry > to the library path, or whatever this is called? Like ~/.postgresql/ or > something like

Re: [GENERAL] array_agg for 8.3

2009-01-19 Thread Jeff Davis
On Mon, 2009-01-19 at 13:40 -0500, Faheem Mitha wrote: > In any case, I don't have admin permissions on the machine I'm trying to > install it to. At absolute minimum, you need PostgreSQL superuser privileges. If you don't, you need to set up a new PostgreSQL instance (which you can do as a norma

Re: [GENERAL] array_agg for 8.3

2009-01-19 Thread Faheem Mitha
On Mon, 19 Jan 2009, Jeff Davis wrote: On Mon, 2009-01-19 at 13:40 -0500, Faheem Mitha wrote: In any case, I don't have admin permissions on the machine I'm trying to install it to. At absolute minimum, you need PostgreSQL superuser privileges. If you don't, you need to set up a new Postgre

Re: [GENERAL] array_agg for 8.3

2009-01-19 Thread Faheem Mitha
Hi Jeff, On Sun, 18 Jan 2009, Jeff Davis wrote: On Sun, 2009-01-18 at 16:52 -0500, Faheem Mitha wrote: Hi Jeff, When I try to run array_agg.sql inside psql I get btsnp_test=# \i '/tmp/array_agg/array_agg.sql' BEGIN psql:/tmp/array_agg/array_agg.sql:5: ERROR: could not access file "$libdir/

Re: [GENERAL] array_agg for 8.3

2009-01-17 Thread Jeff Davis
On Sat, 2009-01-17 at 02:09 -0500, Faheem Mitha wrote: > Hi, > > Can anyone comment on the practicality of using the code for array_agg > from the dev repos, file src/backend/utils/adt/array_userfuncs.c in 8.3 as > a user defined function? It looks like this code was recently added, Nov > 13th/

[GENERAL] array_agg for 8.3

2009-01-16 Thread Faheem Mitha
Hi, Can anyone comment on the practicality of using the code for array_agg from the dev repos, file src/backend/utils/adt/array_userfuncs.c in 8.3 as a user defined function? It looks like this code was recently added, Nov 13th/14th. There are two functions, array_agg_transfn and array_agg_f