| From: | Jeff Davis <pgsql(at)j-davis(dot)com> |
|---|---|
| To: | Faheem Mitha <faheem(at)email(dot)unc(dot)edu> |
| Cc: | pgsql-general(at)postgresql(dot)org |
| Subject: | Re: array_agg for 8.3 |
| Date: | 2009-01-19 19:22:37 |
| Message-ID: | 1232392957.9065.9.camel@dell.linuxdev.us.dell.com |
| Views: | Raw Message | Whole Thread | Download mbox | Resend email |
| Thread: | |
| Lists: | pgsql-general |
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 that?
If you have sudo rights for postgres, that should be fine. All you need
to do is "make" in the module, and it will produce a file array_agg.so.
Copy the .so file to someplace (wherever makes the most sense for you),
and then change all the paths in the .sql file to point to that .so
file. Then run the .sql file as the postgresql superuser.
Regards,
Jeff Davis
| From | Date | Subject | |
|---|---|---|---|
| Next Message | Ivan Sergio Borgonovo | 2009-01-19 20:26:27 | Re: left join with smaller table or index on (XXX is not null) to avoid upsert |
| Previous Message | Reg Me Please | 2009-01-19 19:19:06 | CREATE parametric partial INDEX within a function body |